Parent rollup functionality in sheets

You can create parent rows by indenting other rows beneath them. These indented rows become child rows. Learn more in Hierarchy: Indenting & Outdenting Rows.

Start Date, End Date, Duration, and % Complete for parent rows

The Start Date for a parent is the earliest start date from all of its child rows. Similarly, the End Date is the latest end date from all its child rows.

The Duration on the parent reflects the number of working days between the parent row's Start Date and End Date. Instead of a sum of their durations, it provides a full-time span from the start of the earliest subtask to the end of the latest subtask.

The % Complete on the parent row calculates a weighted percentage based on the Duration and % Complete entered on each child row. In this way, completing child rows with shorter durations doesn't impact the parent row % Complete as much as completing a longer duration child row.

The parent row rollup includes subtasks with a given Duration and a % Complete value.

Parent rows don't calculate % Complete rollups when child rows contain milestones (duration = 0).

Parent rollup functionality tips

• You can’t edit the Start Date, End Date, Duration, and % Complete columns in parent rows with dependencies enabled. To edit these values, you can deactivate the dependency functionality on the sheet or create additional columns not affected by dependencies for your calculations.
• You can’t use custom formulas to change the display or bars in the Gantt view.
• The parent task bars in dependency-enabled sheets have a grey background in the Gantt and calendar views.
• Parent rows always reflect duration in partial working days, even if you use other formats to show duration for the child rows.