These docs are for v1.0. Click to read the latest docs for v1.2.

FILTERDEEP

Returns a recursively filtered list of items from a specified array that match a specified condition.

Syntax

=FILTERDEEP(array, expression)

Arguments

ArgumentTypeDescription
arrayArrayThe array to filter
expressionBooleanThe expression to evaluate for each item in the flattened array, to determine whether it should be counted or not

Examples

=FILTERDEEP(ARRAY(1, 2, 3), this > 1)[2, 3]
Filters the array to include numbers which are greater than 1.

=FILTERDEEP(children, this."Property 1" > 2)[4, 6, 7, 8]
Returns a list of children of the current shapes whose shape data property "Property 1" is greater than 2.