Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Carry column from one table to another

Topic Labels: Formulas
397 2
Showing results for 
Search instead for 
Did you mean: 

I have a table a that has a column with a paid field. I want another table column to bring over that paid field column only if it is filled. Not empty.

2 Replies 2

So tomorrow I will look out for this.

It seems simple to be able to sum one column from one table and roll it up or view that total in a field in another table.

The sum of a column (as displayed in the summary bar) is not available outside of the summary bar. This is one of the ways that Airtable is different from a spreadsheet.

However, you can calculate the sum of linked records using a rollup field. If you want a record to use the sum of all the records in another table, that record needs to to link to all of the records in the other table.