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