Hi all!
I am attempting to utilize data from "Sheet A" (specifically item names and quantities) and SUM the "Quantity" in "Sheet B" when the "item name" from Sheet A matches the "item name" from Sheet B.
Is this possible in Airtable? I've played around with a few different formulas and field types but none have successfully produced what I'm looking for. I've also created a grouped view in Sheet A that groups by Item Name and it shows the Sum in that view if that helps.
If possible, I would prefer for it to be a clean formula/rollup/link/or just about any other method than manually looking up the info from one sheet and keying it into another.
To clarify - all of this information is housed in one Base just multiple sheets.
Any assistance is appreciated!