DOWNSTREAMDEEP
Gets a list of references to all shapes TO which a line has been drawn FROM the current shape, as well as all shape from that are upstream from those shapes, etc.
TRICKY: The directions of the arrows have no bearing on this.
Syntax
=DOWNSTREAMDEEP
Examples
In the following examples, the selected shape is Shape 2
| Text | Property 1 | Property 2 |
|---|---|---|
| Shape 1 | 1 | 10 |
| Shape 2 | 4 | 18 |
| Shape 3 | 2 | 13 |
| Shape 4 | 6 | |
| Shape 5 | 8 | 12 |
=DOWNSTREAMDEEP → [Shape 3, Shape 4, Shape 5]
Get all downstream shapes from the current shape
=DOWNSTREAMDEEP."Property 1" → [2, 6, 8]
Get all downstream shapes' shape data property "Property 1"
Updated 8 months ago