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

  • ricki
    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?