Aug 01, 2021 04:18 PM
Hello,
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.
Thanks
Aug 01, 2021 05:29 PM
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.
Aug 01, 2021 06:41 PM
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.
Aug 01, 2021 11:48 PM
thanks for the clarification