Help

Use totals in formulas

Topic Labels: Formulas
488 1
cancel
Showing results for 
Search instead for 
Did you mean: 
RicardoCorai
4 - Data Explorer
4 - Data Explorer

The status bar at the bottom of each table shows the total of each field. So we have X records and X sum. What I need is to use those values in formulas.
How can I call the total records of the table 1?
How can I call the sum of a field in the table 2?
Etc.
Could you help me with that?

1 Reply 1

Welcome to the Airtable community!

Do you come from a spreadsheet background? Welcome to the database world.
It is not possible to use values from the summary bar in a formula field in Airtable.

You can sometimes use linked record fields and rollups to the sum of a value in linked records. It isn’t the same and it requires a different way of thinking, but it might get you closer to what you need.