I have a country column and a rating column, each with multiple options. I wish to apply a filter to see only “a, b and c” countries that have “x” rating. This does not seem possible with Airtable, which blows my mind a bit?
I apply "Where country is “a” " at the top, then “Or b,” then “Or, c”, but I’m then unable to apply an “And” function to apply the single rating I wish to see for those countries.
Is anyone able to explain why this seemingly simple function isn’t available?
Many thanks in advance.