Help recreating formulas from Excel

[Heather_Slade]

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?

[Kamille_Parks]

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:

Days Difference between Previous Entry Date Formulas

Simple answer: Google Sheets makes spreadsheets, Airtable does not. There are just some features common to spreadsheets that Airtable won’t ever and shouldn’t ever add, one of which is referencing the “above” record. The reason being is in Airtable, the order records appear is arbitrary; from a data architecture perspective, there is no such thing as a record being “above” or “below” another. You would get a wildly different answer to “what is above this record” depending on what View you’re l…