Help

Filter logical operations: AND, OR

Solved
Jump to Solution
1379 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Prokup
4 - Data Explorer
4 - Data Explorer

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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.