Hierarchy functions allow you to include cells in other functions based on their indent level in a sheet.
USM Content
Users on an Enterprise plan can use AI to generate formulas. Learn more.
You can use hierarchy in Smartsheet to indent or outdent groups of cells, which helps to illustrate the relationships among the data more clearly. You can also incorporate a hierarchy function within another function to automatically reference all indented child cells under a parent row, even as new child rows are added. For example, you could use the following formula to sum all of the child values in a particular column: =SUM(CHILDREN())
For more information about how to use the functions that allow you to work with hierarchy, see the following in the Smartsheet function reference:
- CHILDREN Function References all child cells underneath a parent.
- PARENT Function References the direct parent cell of a child cell.
- ANCESTORS Function References all parent cells to a child cell.
Hierarchy functions aren't supported in cross-sheet formulas. Attempting to use the CHILDREN, PARENT, and ANCESTORS functions in a cross-sheet formula results in an #UNSUPPORTED CROSS-SHEET FORMULA error in the cell containing the formula. Learn more about formula error messages and referencing data from other sheets.
Keep in mind that users with Editor sharing permissions can only create and edit formulas in unlocked cells on a sheet.
Still need help?
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.