Skip to main content

I have 2 tables: “Home Staging Projects” and “Inventory Items”. In the “Home Staging Projects” table, I want to vlookup on the “Project ID” and return the sum total of “Rental Price” for each inventory item selected for that project listed on the “Inventory Items” table. I hope that makes sense.

I’m not sure if this makes a difference, but the “Inventory Items” table is linked to the “Home Staging Projects” table by (formula) “Project ID”.

Is there a way to use a formula for this?

If they are linked, then the Rollup field can be used.

Rollup Field - Overview | Airtable Support

If they are linked, then the Rollup field can be used.

Rollup Field - Overview | Airtable Support


I looked at both Rollup and Lookup and didn't see how to make it work.

Add a Rollup field to "Home Staging Projects" table

 Can you set it up like this?

OMG IT WORKED!!!! THANK YOU SO MUCH! I wouldn't have ever thought of that, and I've watched several Youtube videos to figure this out. I really appreciate it so much.

Reply


Terms & Conditions