CONNECTEDDEEP
Get a list of references to all shapes that are connected to the current shape, via a line, as well as all shapes connected to the connected shapes, etc.
Syntax
=CONNECTEDDEEP
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 |
=CONNECTEDDEEP → [Shape 1, Shape 3, Shape 4, Shape 5]
Get all shapes connected to the current shape.
=CONNECTEDDEEP."Property 1" → [1, 2, 6, 8]
Get all shapes' shape data property "Property 1"
Updated 4 months ago