Help

Carry column from one table to another

Topic Labels: Formulas
1126 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jesse_Clark
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Jesse_Clark
5 - Automation Enthusiast
5 - Automation Enthusiast

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.