Simple question, but unable to figure it out.
HI all,
New user of SS and I am stuck trying to figure this out..
If I have a task that is 10 days to complete with 1 resource, but if I assign 2 resources it will be completed in 5 days.. It is still 10 days of effort however it has now reduced the project length by 5 days.. What do I need to do to effect the dates automatically to reflect this?
Thanks
Rich
Comments
-
Hard to be specific without more details from your sheet .....
You could have a column # resources
Then you could have a formula which would divide the Days to completion by # resources to give you calendar days to completion.
If you then needed a date you could add this number to the start date
Would this work?