- VALUEIN() formula returns a boolean indicating if a certain value is in a list.
- FILTER() can be used to filter records efficiently by transforming the formula into a SQL query.
- Using FILTER() with a lot of ORs may create a SQL statement longer than the max length allowed.
- VALUEINLARGE() only accepts INT and INT64 fields for large value checks.
- An EXIST JOIN or similar SQL statement will be created if the second parameter of VALUEIN() is a non-filtered list.
- If the second parameter of VALUEIN() is a filtered list with 0 records, it will return all records of the table being filtered.
- Alternatives to using VALUEIN() include creating a boolean field in the table or filtering the final table inside the first.
- Efficiency implications must be considered when choosing between the alternatives, based on the size evolution of the tables.
Registered users can view the full text for FREE!
Sign In Now!
