Simple question, but unable to figure it out.

richgarbutt65011

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

 

ricki

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?