Multiple IFs logic

There has to be a better way to do this, so I thought I'd ask.

Let's say we have a table of users and the foods they like, for example

Name, Apples, Bananas, Pears
Tomas,yes,yes,no
Aaron,no,yes,no


Then we would want to make a filter with those 3 inputs
Users who like apples bananas and pears
Users who like apples,bananas but doesn't like pears
Users who like apples, but not bananas and pears
Users who like apples, but doesn't like bananas, and likes pears
Users who doesn't like any of the 3

You can see how it can very quickly become a ton of variations, and this is how I am currently trying to do it, but I am not sure if that's the optimal way[Image]
It would be really nice to have a conditional on the filter right here ( only use it IF the input is not null)[Image]

Thank you!
Other
1 reply