Indenting Rows

In Spreadsheet.com, indenting and outdenting rows allows you to create hierarchical relationships between rows.

More than just a visual indicator, indenting and outdenting turns rows into "parents" with "children." Sometimes called "grouping", indenting and outdenting rows combines groups with tabs to create hierarchical relationships that persist across Views. For instance, in Kanban Views you can sort by level, showing all rows, just parent rows, or only rows at a specific level in the hierarchy. In addition, there are unique Hierarchy Formulas that allow you to reference child data in the hierarchy.

Hierarchies are useful when you have rows of data that are related to each other, like denoting subtasks in a project plan or budget line items that roll-up to subtotals.

Introduction to Row Hierarchies

In Spreadsheet.com, rows can be indented and thereby become "children" to their "parent" row. This ability has multiple names, including row hierarchies, "tabbing" or "indenting" rows, and grouping rows.

The top-level of a hierarchy is generally referred to as the "parent" row or a "Level 1" row. Rows one indent lower are known as "child" or a "Level 2" rows. Two indents in are "grandchild" or "Level 3" rows, etc. 

Hierarchies allow you to group rows together in parent or child relationships that can then be collapsed to ride the rows. Hierarchies also change the way that your worksheet sorts data, with sorts only applying to the children within each parent row. That way different children do not get sorted between different parents.

To indent a row, you must have an editor role or higher. You can only indent entries in the primary column and cannot indent the first row.

Indenting and Outdenting Rows

By indenting a row, it becomes a "child" row to the "parent" above it. To indent data in a row, select the indent button mceclip8.png in the toolbar, and that row will become the child of the parent row above it. Or reverse your indent with the outdent button mceclip9.png in the toolbar. You can pick any cell in a row and the entire row will indent or outdent to the row above it.

Indent-outdent-buttons.png

You can also access indent and outdent options from the Edit menu.

For more details about working with row hierarchies and hierarchy functions, see our article on Creating Row Hierarchies.