Parent rollup functionality

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

The Start Date for a parent is determined by the earliest start date among all of its child rows. Similarly, the End Date is determined by the last end date among all its child rows.

The Duration on the parent indicates the number of working days between the Start Date and End Date in that row.It provides a full time span from the earliest subtask to the latest, rather than simply totaling their durations.

The % Complete on the parent row calculates a weighted percentage based on both the Duration and % Complete entered on each child row. In this way, completing child rows with shorter durations does not affect the parent row % Complete as much as completing a longer duration child row.

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

Parent rollup functionality tips

• You can't edit parent rows with enabled dependencies in the Start Date, End Date, Duration, and % Complete columns. You can use your calculations if you disable the dependency functionality on the sheet or create a custom formula in a column not used in the dependency functionality.
• You can't use custom formulas to change the display or bars in the Gantt chart.
• Parent rows in dependency-enabled sheets always 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.
• Parent rows don't calculate % Complete rollups when their child rows contain milestones (duration = 0).