I am mapping out a project that runs over several months and I’d like to get a running timeline for each month.
I have a Gantt display which does display this, but I’d like a column to help calculate a few things.
For instance I want to calculate project costs as the number of workers grows. Say Task 1 takes 1 person 9 weeks. 7 weeks in I hire a second person for task 2 that takes 6 weeks, at week 11 I have person 1 and person 3 working on Task 3 etc.
I’d like to have a column in a table so that at the start of each month I know how many people I have working that month so I can calculate costs. (I say start of each month but start of each sprint would also work for me, eg sprint 20, team size =4. In fact having both calendar month start date summary and sprint number start summary would be useful).
I’ve tried having a column with month that looks at start date but if there’s a month with no tasks scheduled to start it misses it.