FILTER Operation
How to use the Filter operation with Computed Attributes
Definition
Example
Syntax Guide
Formula In Use
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
Formula In Use
What's Next
- Learn more about how to write formulas
- Check out the SEARCH operation
- Check out the IF operation
If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...
and please let us know 👇