UPSTREAMDEEP
Gets a list of references to all shapes FROM which a line has been drawn TO 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
=UPSTREAMDEEP
Examples
In the following examples, the selected shape is Shape 4
| Text | Property 1 | Property 2 |
|---|---|---|
| Shape 1 | 1 | 10 |
| Shape 2 | 4 | 18 |
| Shape 3 | 2 | 13 |
| Shape 4 | 6 | |
| Shape 5 | 8 | 12 |
=UPSTREAMDEEP → [Shape 2, Shape 1, Shape 5, Shape 3]
Get all upstream shapes from the current shape
=UPSTREAMDEEP."Property 1" → [4, 1, 8, 2]
Get all upstream shapes' shape data property "Property 1"
Updated 7 months ago