Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Referencing individual cells in formula

Topic Labels: Formulas
715 3
Showing results for 
Search instead for 
Did you mean: 

I am trying to write a formula to sum individual cells. It would look like =SUM(B4, H4, …) in excel. I cam across cell reference in the API (Airtable Scripting) but I am not sure how to reference individual cells in a formula within airtable.

3 Replies 3

When writing a formula in Airtable, you reference the name of the field between curly braces. A formula for SUM() would look something like this

SUM({Field Name 1}, {Field Name 2}, ...)

Scripting is something entirely separate from a formula field.

Welcome to the Airtable community!

Airtable formula fields can only access other fields in the same record/row. They cannot reference an arbitrary cell, and the cannot reference a cell in a different record/row.

thanks for the clarification