Mar 02, 2021 07:54 AM
Is it possible to use more than a single logical operator for filtering results? So far, I see there is only the option to filter based on the AND logical operator or the OR logical operator. Is it possible to combine these? For example:
WHERE
(“Status” contains “active” AND “Due Date” is within “1 month”)
OR
(“Status” contains “started” AND “Due Date” is “empty”)
Otherwise, I need two separate filters and cannot see projects side-by-side easily.
Solved! Go to Solution.
Mar 02, 2021 07:55 AM
Welcome to the community, @Alex_Prokup!
No, this is not possible with filters, but you could create a formula like that, and then filter on the formula.
Mar 02, 2021 07:55 AM
Welcome to the community, @Alex_Prokup!
No, this is not possible with filters, but you could create a formula like that, and then filter on the formula.
Mar 02, 2021 08:04 AM
Thanks for the quick reply! I think that is definitely the way to make it work. I just found this link: The essentials of Airtable formulas – Airtable Support
But I think the admin disabled formulas for our Airtable. Will have to check if this can be opened up to non-Power Users.