ANCESTORS
Returns a deep list of the shape's parents, starting with the shape's parent (then the parent's parent, etc.), up to the containing page.
NOTE: The ANCESTORS function operates similarly to the DESCENDANTS formula function, but includes items by navigating up the hierarchy instead of down.
Syntax
=ANCESTORS
Examples
In the following examples, the shape (Shape 8) is contained in a group (Group A), which is contained in another group (Group B). All shapes are contained in the page named "Page 1".
"Group A" is a group with 2 shapes in it, with the following text and values
| Text | Property 1 | Property 2 |
|---|---|---|
| Shape 7 | 1 | 12 |
| Shape 8 | 10 | 15 |
"Group B" is a group which contains 6 shapes, including Group A, with the following text and values:
| Text | Property 1 | Property 2 |
|---|---|---|
| Shape 1 | 1 | 10 |
| Shape 2 | 4 | 18 |
| Shape 3 | 2 | 13 |
| Shape 4 | 6 | |
| Shape 5 | 7 | 14 |
| Group A | 8 |
"Page 1" is the page that contains Group B, with the following text and values
| Text | Property 1 | Property 2 |
|---|---|---|
| Group B | 5 | 12 |
| Page 1 | 11 | 22 |
=ANCESTORS→[Group A, Group B, Page 1]
Gets all ancestors of the current object, including its containing page
=ANCESTORS."Property 1" → [8, 5, 11]
Gets the value of property "Property 1" for all ancestors of the current object, including its containing page, if present
Updated 2 months ago