It it possible to in app filter recepis with X AND Y as ingredients

Say you make a list of recepis with all ingredients.
And you have sheet with all ingredients for the choice element.
Is there a way to give the user the option to filter all recepis that have all ingredients X AND Y AND Z in it? Instead of a list with all recepis with ingredient X AND all recepis with Y AND all recipes with Z?

Possibly you will need to have 3 user specific columns to store 3 choices, then filter by ingredients contains choice A and choice B and choice C.

1 Like