Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Filter logical operations: AND, OR

Solved
Jump to Solution
305 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Solution

Accepted Solutions

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.

See Solution in Thread

2 Replies 2

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.

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.