Using prevous or above record data in formula

[Ashley_Mills]

Hey all!
I am trying to use Airtable as an excel spreadsheet to track my budget. Is there a way to create a formula that use the previous records ‘current balance’ amount for the formula so it will update each record (transaction). I really appreciate any help you can offer!

[Kamille_Parks]

You’d need to either link your records together or use some form of Automation, script, or manual process to copy a value from the first record to the second.

Similar posts from today and yesterday:

Days Difference between Previous Entry Date Formulas

I’m tracking bicycle tire air pressure fills and my current setup include 3 main columns: Begin Date, End Date, and Duration. Duration is a DATETIME_DIFF function, calculating the days between air refills. The problem is, I have to copy each End Date to the subsequent row’s Begin Date every time. This is quick on the desktop, but on iOS it’s extra steps. Ideally, I would have just one date column and the duration column would calculate the difference from the previous record. For example, in Go…

Help recreating formulas from Excel Formulas

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]