Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Use totals in formulas

Topic Labels: Formulas
908 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
kuovonne
18 - Pluto
18 - Pluto

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.