FILTER Operation

How to use the Filter operation

Definition

The FILTER operation returns a list of items that achieve certain conditions.

Example

FILTER(GT($$ITEM, 2), [1, 2, 3, 4])

Result:
[3, 4]

Syntax Guide

FILTER(condition, range)

condition - An array formula evaluating to true or false

range - The data to be filtered