Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Parent Sum Children Duration

edited 12/09/19 in Archived 2017 Posts

Is there a way to sum the duration of children rows?


Parent row - 20 days duration

    Child - 5 days duration

    Child - 10 days duration

    Child - 15 days duration




  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    Are you implying that 20 days is incorrect or correct?

    If Dependencies are set in the Project Settings, the durations "roll up" and the number of days displayed is from the beginning of the group until the end.


    If you have three tasks of 1 day each, for example,


    The duration of the parent row is show duration from start (Jan 2) to finish (June 30) or 130 work days.


    Not effort (3 days)






  • 20 days is incorrect. It is counting the range of the children tasks, when I need it to calculate the total number of days within all of the children tasks

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    In Smartsheet, Duration is calendar time (in work-days).

    If you want to calculate 30 from your example (or 3 from mine), you'll need to do that in a different column.


    Something like this should work or get you close:




    where the Parent row is on row 23.

    This should account for working hours and non-working days in your project settings.





    edited 03/23/17

    Thank you so much!

This discussion has been closed.