Parent Rollup Functionality
This Help Article Appears in the Following Learning Tracks
TIP: 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 sub-task 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 sub-tasks with a given Duration and a given % Complete value will be included in the parent row roll-up.
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 being 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 sub-task 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.