UPSTREAM
Gets a list of references to all shapes FROM which a line has been drawn TO the current shape
For example, for two shapes A and B, if a line is drawn from A to B, then A is upstream of B. If another shape C is added, and a line is drawn from B to C, then B is upstream of C. If another shape D is added, and a line is drawn from D to B, then D is upstream of B.
TRICKY: The directions of the arrows have no bearing on this.
Syntax
=UPSTREAM
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 |
=UPSTREAM
→ [Shape 2, Shape 5]
Get all upstream shapes from the current shape
=UPSTREAM."Property 1"
→ [4, 8]
Get all upstream shapes' shape data property "Property 1"
Updated 6 months ago