Display Total from 1 table in another

Topic Labels: Formulas
1192 3
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve searched this topic but I’m obviously missing something because it seems too simple …

I have a table of parts, each of the parts have a cost so the table has a Total column.

I want to have that Total value appear in another table (then I’ll be deducting that value from corresponding columns to generate another figure.

How do I simply reflect the value from a column in 1 table, in another table?

Like I said, it seems crazy simple…

3 Replies 3

Hi @Herbshirt

You have to link every record from the {Parts} table to a single record (a summary record) in your other table where you want the Total to show up. Then, in the {Totals} table you’ll need to use a Rollup function to get the total from all the linked {Parts} records.

It looks something like this:

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

5 - Automation Enthusiast
5 - Automation Enthusiast

When you say 'link every record" - what if I have a hundred rows??

You can copy the value from one and paste in the others (select full column clicking the header and paste).