So, I think I need a double filter. First filter is by restaurant, and second filter is by menu type.
Is there a way of achieving this?
Thanks as usual, oiibvv.glideapp.io
I would create templates that join the restaurant name and the Menu Type together. Do this in both sheets that you want to create the relation. Now use the template columns to create the relation column.
So, for example, you will have columns with values like “Restaurant 1 - Lunch” and “Restaurant 2 - Dinner”