Rows and hierarchy

Hierarchy lets you organize rows into groups by nesting related rows beneath a parent row. The rows nested underneath become child rows. This is useful when you want to break down a project into phases and tasks, group related items, or summarize data across multiple rows.

Hierarchy creates relationships between rows; it doesn't change how rows are formatted or styled.

Brandfolder Image

Indents are displayed only in the sheet's Primary Column, but the relationship is applied to the entire row.

When you move a parent row, all its child rows move with it. Similarly, if you delete a parent row, all its child rows are deleted too.

To delete a parent row without deleting the child rows, remove the parent-child relationship first.

How to create a hierarchy

You create a hierarchy by indenting a row. Before indenting, make sure both the row you want to indent and the row above it contain data. Hierarchy requires content in both the parent and child rows.

1. Select any cell in the row you want to indent. This is the row that becomes the child row.
2. Select Make child row   on the left side of the row.

The row above automatically becomes the parent row.

To indent a row, you can also use the keyboard shortcut Ctrl + ] or Command + ] on a Mac. 

There is no fixed level of indenting; you can indent rows on your sheet to create multiple levels of hierarchy.

If your sheet has dependencies enabled, parent rows automatically reflect a roll-up summary of the Start Date, End Date, Duration, and % Complete values from their child rows. 

How to remove hierarchy

Outdenting a row removes its parent-child relationship, moving it one level up in the hierarchy. The row's data isn’t affected.

To remove a parent-child relationship:

1. Select any cell in the child row you want to level up in the hierarchy.
2. Select Promote child row   on the left side of the row.

The row moves one level up. If it was the only child, the row above it is no longer a parent.

Brandfolder Image

To outdent a row, you can also use the keyboard shortcut Ctrl + [ or Command + [ on a Mac. 

Expand or collapse child rows

Collapsing a parent row hides its child rows from view. The data is still there, just out of sight. Expanding it brings them back. This is useful for focusing on high-level project status without the details of every individual task.

Expand or collapse a single parent row

Select the arrow icon (▶ / ▼) next to the parent row's name in the Primary Column. The arrow points right when collapsed and down when expanded.

Expand or collapse all parent rows

To expand or collapse every parent row on the sheet:

1. Right-click the Primary Column header to open the column options menu.
2. Select Expand All or Collapse All.