Filter logical operations: AND, OR

[Alex_Prokup]

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.

[ScottWorld · Accepted solution]

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.

[Alex_Prokup]

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.