Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Parent Rollup Functionality

PLANS

  • Smartsheet
  • Pro
  • Business
  • Enterprise

When Dependencies are enabled on a project sheet, Parent Rows automatically roll-up information in several of the Project Sheet Columns.

Parent rows are created by indenting other rows beneath them. Learn more in our article on Hierarchy: Indenting & Outdenting Rows.

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 subtask to the latest, as opposed to a sum of their durations.

The % Complete on the Parent row will calculate a weighted percentage based on both the Duration and % Complete entered on each child row. In this way, completing child rows with shorter durations won’t affect the Parent row % Complete as much as completing a longer duration child row. Because of the way this is calculated, only subtasks with a given Duration and a given % Complete value will be included in the parent row roll-up.

NOTES:

  • When Dependencies are enabled, Parent Rows are non-editable in the columns listed above. If you'd like to use your own calculations you can either disable the Dependency functionality on the sheet, or create your desired formula in one of the columns not used in the dependency functionality. Custom formulas can’t be used to change the display or bars in the Gantt chart.

  • Parent rows in dependency-enabled sheets will always have a grey background color in the Gantt and Calendar views.

  • Though subtask duration can be entered in a variety of formats including weeks, whole working days (e.g. 4d), partial working days (3.5d), elapsed days (e3d), hours (7h), minutes (90m), seconds (500s) and milliseconds (50000ms), parent rows will always reflect duration in partial working days.

  • % Complete rollups won't be calculated in tasks with sub-tasks containing milestones (duration = 0).

Was this article helpful?
YesNo