Duration Column is not calculating property when a task has subtask

Varinder

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

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

Varinder

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

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