Duration Column is not calculating property when a task has subtask

I am trying to calculate duration required for a task which has couple of subtask . Unfortunatly greatest value of subtask duration is shown in task duration (0.5d) instead of adding duration of all subtask . Estimated hours caluculated by formula doesnt match with Duration.. any idea how to fix .ss attached

Answers

  • Melissa Yamada
    Melissa Yamada ✭✭✭✭✭

    Hello @Varinder

    When dependencies are enabled, "the Duration on the parent reflects the number of working days between the parent row's Start Date and End Date. Instead of a sum of their durations, it provides a full-time span from the start of the earliest subtask to the end of the latest subtask.".

    You might need to disable dependencies and manually add duration and create a sum formula in the parent row to be able to calculate based on your preference.

    https://help.smartsheet.com/articles/765753-parent-rollup-functionality

    Melissa Yamada
    melissa@insightfulsheets.com
    Data made simple, spreadsheets reimagined

  • Thanks @Melissa Yamada . Can you help me to provide formula to calculate end date based on combination of estimated hours + start date for child subtask and main task . I already using formula to calculate estimated hours using =SUM(CHILDREN()) .

  • Melissa Yamada
    Melissa Yamada ✭✭✭✭✭

    How about create a helper column that will change duration from hours to days?

    Helper column (Duration (days)):

    =IF(Duration@row < 24, 0, IF(Duration@row > 24, Duration@row / 24))

    Then on your End Date:

    =[Start Date]@row + [Duration (Days)]@row

    Melissa Yamada
    melissa@insightfulsheets.com
    Data made simple, spreadsheets reimagined

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!