CHILDREN Function

Used within another function to reference the child rows of the referenced parent row.
Sample Usage
COUNT(CHILDREN([Task Name]1))
Syntax
CHILDREN(
  • [
    reference
    ]
)
  • reference
    —[optional]
    A cell in a parent row. If no cell is specified, the function references the children of the current cell.
Related Functions
ANCESTORS
PARENT
IF
COUNTIF
COUNTIFS
SUMIF
SUMIFS
Was this article helpful?
YesNo