Syntax
Filter(Table, Condition1 [, Condition2, ...])Parameters
Table- The table or data source to filter.
Condition- A test for each record. All conditions must be true.
Examples
Filter(Tasks, AssignedTo.Email = User().Email, Status <> "Done")My open tasks
Maker notes
- On large data sources, keep conditions delegable. Otherwise only the first 500 records (adjustable up to 2,000) are checked.