Hi! I’m having trouble with filtering a list of lists.
I have 3 tables:
- One with food products that lists the ingredients and nutrition facts for that food
- Another with instances of each food, how much I ate, calculating the nutrition facts, logging the date eaten.
- Last one which summarizes all the foods eaten in a day and totals the nutrition facts, shows the ingredients I ate that day, etc.
What I’m trying to do is be able to filter the Daily Meal Tracking table by individual ingredients, so I can see all the days I ate foods with “Black Tea” for example. Or “Black Tea” and “Pasteurized Cream”. I’d also like to get rid of the blanks and consolidate duplicate ingredients (is there a way get unique values, not just count them?
Hopefully the doc sharing below works, sorry I had to share my entire doc, because I have everything in one place: