ANCESTORS Function

Used within another function to reference all of the ancestors in a cell’s hierarchy.
Sample Usage
COUNT(ANCESTORS([Task Name]4))
Syntax
ANCESTORS(
  • [
    reference
    ]
)
  • reference
    —[optional]
    The cell for which you want the ancestors. If no cell is specified, the function references the ancestors of the current cell.
Was this article helpful?
YesNo