Hi, I’m developing an automated Order/Recipe/Stocking/Shopping List Manager in Airtable, and I am having sobre trouble with my shopping list. I want to have the values of the quantity of ingredients I need to buy accordingly to the recipes.
I already have the ingredients by quantity in each order (second column) and by recipe (third column), but they come in arrays, and cannot reach how much I have to buy (fifth column [#ERROR!]).
There’s an easier way to make this, or at least, an way to multiply the values of the array with other array, so I can reach the quantity of ingredients?