Sum duration for multiple nested child/children rows.

joecih

Why can I not get correct totals on Duration days if the parent has multiple nested children within children?

parent -> child -> childOfChild

I expect that the sums on durations would total in such order, leaving the parent with the complete duration total from all children, and related sub-children

Andrée Starå

Hi Joe,

The Start Date for a Parent will be automatically set to the earliest Start Date from all of its Child Rows. Similarly the End Date will be set to the last End Date from all its Child Rows.

The Duration on the Parent reflects the number of working days between the Start Date and End Date in that row. It provides the full time span encompassed by that section of tasks, from the earliest sub-task to the latest, as opposed to a sum of their durations.

Please see attached link/screenshot.

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

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done