Applies to
- Pro
- Business
- Enterprise
Capabilities
Who can use this capability
The sheet's老板andAdminscan modify the sheetProject Settings.
Parent rollup functionality
WhenDependencies are enabledon a project sheet, Parent Rows automatically roll-up information in several of theProject Sheet Columns. Parent rows are created by indenting other rows beneath them. Learn more in our article onHierarchy: Indenting & Outdenting Rows.
Start Date, End Date, Duration, and % Complete for parent rows
TheStart Datefor a parent is the earliest start date from all of its child rows. Similarly, theEnd Dateis the last end date from all its child rows.
TheDurationon the parent reflects the number of working days between theStart DateandEnd Datein that row. It provides a full time span, from the earliest subtask to the latest, as opposed to a sum of their durations.
The% Completeon the parent row calculates a weighted percentage based on both theDurationand% Completeentered on each child row. In this way, completing child rows with shorter durations does not affect the parent row% Completeas much as completing a longer duration child row.
The parent row rollup includes only subtasks with a givenDurationand a% Completevalue.
Parent rollup functionality tips
You cannot edit parent rows with enabled dependencies in theStart Date, End Date, Duration,and% Completecolumns. To use your own calculations, you can disable theDependency functionalityon the sheet or create your desired formula in a columns not used in the dependency functionality.
You cannot use custom formulas to change the display or bars in theGanttchart.
Parent rows in dependency-enabled sheets always have a grey background color in theGanttandCalendarviews.
Parent rows always reflect duration in partial working days, even if you use other formats to show duration for the child rows.
Parent rows do not calculate % Complete rollups when any of their child rows contains milestones (duration = 0).