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.
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.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.