CHILDREN()

References all direct child rows of a parent row. Used in parent rows for roll-up calculations in hierarchical project structures.

Syntax

smartsheet-mastery

=SUM(CHILDREN()) | =AVG(CHILDREN()) | =COUNT(CHILDREN())

Example

smartsheet-mastery

// On a parent row (phase):
=SUM(CHILDREN())           // Sum of all child task budgets
=AVG(CHILDREN())           // Average % complete across tasks
=MAX(CHILDREN())           // Latest end date among child tasks
=COUNT(CHILDREN())         // Number of tasks in this phase

// Count complete children
=COUNTIF(CHILDREN([Status]@row), "Complete")