How to get all the unique values from a select list of select from table

@Tomas_Jansson you’re looking to get the list [Apple, Banana, Kiwi], since these are the fruits used in salads listed? I would recommend doing this the inverse way.

Instead of selecting which fruits are in a salad, select which salads a fruit belongs to. You can use the same multiple lookup column.

Then, to get the list of ingredients which are used, simply use =Fruit.filter([Used in?].IsNotBlank()). In the “Recipes” table, use =Fruit.lookup([Used in?], thisRow) to see the ingredients of each recipe.

I’ve attached a screenshot of my two tables—let me know if you have any questions!

1 Like