Count Of Ingredients

Hello! I have a base with ingredients, recipes, and meals. I’ve seen similar bases but none that ask this specific question.

Meals reference recipes, and recipes reference ingredients. The meals table has a lookup to list all ingredients for the given meal based on the listed recipes for that meal.

How do I get the number of times each ingredient has been used based on the meals table?

Welcome to the Airtable community!

Try using a series of rollup fields. In the [Recipes] table, have a rollup with the COUNTA(values) aggregation formula that counts the number of meals. Then, in the [Ingredients] table, have a rollup with the SUM(values) aggregation formula that adds up the numbers from the [Recipes] table.

Yes - this is fantastic and works very well! Thank you!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.