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

LP_FSNY
LP_FSNY
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

 

 

Comments

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

    LP,

     

    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)

     

    Craig

     

     

    Duration.jpg

  • 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 ✭✭✭✭✭✭

    LP,

     

    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:

     

    =SUM(CHILDREN(Duration23))

     

    where the Parent row is on row 23.

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

     

    Craig

     

     

  • LP_FSNY
    LP_FSNY
    edited 03/23/17

    Thank you so much!

This discussion has been closed.