Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 20, 2023 05:33 PM
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?
Solved! Go to Solution.
Aug 21, 2023 05:48 PM
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.
Aug 20, 2023 05:54 PM
If they are linked, then the Rollup field can be used.
Aug 20, 2023 06:42 PM
I looked at both Rollup and Lookup and didn't see how to make it work.
Aug 20, 2023 06:56 PM
Add a Rollup field to "Home Staging Projects" table
Can you set it up like this?
Aug 21, 2023 05:48 PM
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.