PARENT() / ANCESTORS()

PARENT() returns the value of a column in the parent row. ANCESTORS() returns an array of all ancestor values. Used in child rows to inherit context from their parent.

Syntax

smartsheet-mastery

=PARENT([Column]@row) | =ANCESTORS([Column]@row)

Example

smartsheet-mastery

// Return the parent row's department
=PARENT([Department]@row)

// Check if any ancestor is "On Hold"
=IF(HAS(ANCESTORS([Status]@row), "On Hold"), "Blocked by parent", [Status]@row)