Filters lock to 'And' or 'Or' after the first selection


I want to make a view where I can say:

Product Status is In Stock


Product Status is Backordered


Last Sold Date

was within the last week

However, the filter menu locks to ‘And’ or ‘Or’ dependent on your first selection. Is there any chance you would revise this?

Complex and/or chained view filters

Hello Matt, the reason we don’t allow combining AND and OR operators in the filter menu directly is that the order of precedence between the operators would be indeterminate without parenthesis. In other words, it would be ambiguous whether you meant (Condition 1 AND Condition 2) OR Condition 3, vs Condition 1 AND (Condition 2 OR Condition 3).

However, a workaround is to create a Formula column, and then reference it in your filter. For example, you could create a Formula column with the formula: "AND({Food color}=green, OR({Food Type}=“eggs”, {Food Type}=“ham))”. Then the output of the formula would be either 1 or 0, and you could filter on this value. Here’s some more info about formulas:

Hope that helps!

Creating Filters - And - Or