Help

Showing Column Sum in one table to another

Topic Labels: Formulas
397 1
cancel
Showing results for 
Search instead for 
Did you mean: 
daniel-airtable
4 - Data Explorer
4 - Data Explorer

Hi Community,

I am looking to have a total sum of 1 column to reflect on a row that will match item number for another table

If you look below at the snapshot images, the 1st table provides assessments for sites and I formulated a square yard number under each column (C202(52)(C) - Removal and Disposal of Existing Portland Concrete), (C202(52)(D) - Removal and Disposal of Existing Sidewalk...

I am looking to have these total summed up quantities to reflect another table as shown on the second image, under the Total Assessment QTY linked accordingly to the item number

Any advice would be greatly appreciated!!!  

danielairtable_0-1683284404913.png 

danielairtable_1-1683284648901.png

 

 

1 Reply 1

After you've linked the records appropriately, you can use conditional rollups with `SUM(values)` to get what you're looking for I think