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?






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?