Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 16, 2024 11:27 AM - edited Sep 16, 2024 11:31 AM
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!
Solved! Go to Solution.
Sep 16, 2024 06:33 PM
Hmm, assuming you've got a link between the two tables we should be able to just add a rollup field like so:
---
If the data's keyed in row by row, then selecting the item via the linked field seems like an alright workflow?
If the data all already exists, you quickly link all the data together by:
1. In Sheet A, Click the field header with the unique item names thereby selecting the entire column
2. Hit CTRL / CMD + C
3. In Sheet A, click the field header for the linked field to Sheet B
4. Hit CTRL / CMD + V
This'll automatically link everything up and the rollup in Sheet B will populate the way you want!
Sep 16, 2024 06:33 PM
Hmm, assuming you've got a link between the two tables we should be able to just add a rollup field like so:
---
If the data's keyed in row by row, then selecting the item via the linked field seems like an alright workflow?
If the data all already exists, you quickly link all the data together by:
1. In Sheet A, Click the field header with the unique item names thereby selecting the entire column
2. Hit CTRL / CMD + C
3. In Sheet A, click the field header for the linked field to Sheet B
4. Hit CTRL / CMD + V
This'll automatically link everything up and the rollup in Sheet B will populate the way you want!