Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Help recreating formulas from Excel

Topic Labels: Formulas
351 1
Showing results for 
Search instead for 
Did you mean: 

I want to create a table similar to this one in AirTable. What I can’t figure out is if there is a way to calculate between rows (records).

For example, looking at this spreadsheet, the calculation in “O7” is =IFERROR(L7/L6,0)

Is there a way to mimic the same kind of calculation (formula) in AirTable?
Screen Shot 2021-06-09 at 2.32.08 PM

1 Reply 1

Calculation between records that are not linked is not possible in Airtable. You would need to copy the relvant value from one record to the other, or link the records together.

See this response form a similar recent post: