I’m working on an Airtable database and running into a challenge. I want to create a running total column that works like Excel’s cumulative sum feature.
Here’s what I’m trying to achieve:
Amount Running Total
5 5
3 8
7 15
2 17
Basically, I need each row to show the sum of all values from the first row up to the current row. In Excel this would be straightforward, but I can’t figure out how to replicate this behavior in Airtable.
I’ve tried using formula fields but they don’t seem to reference previous rows easily. Has anyone successfully implemented running totals or cumulative sums in Airtable? What approach did you use?
totally relate! those formula limits can be a pain. what i did was use a combination of autonumber for ordering and rollup to get the sums from before. it’s not ideal, but i managed to make it happen!
Had this same issue last year building a budget tracker. Here’s what worked: create a formula field using SUMIF to get your running total. You’ll need an autonumber field first to track row order, then use SUMIF({Autonumber Field}, "<=" & {Autonumber Field}, {Amount Field}). This sums all amounts where the autonumber is less than or equal to the current row. Not as clean as Excel, but it works. Just heads up - if you reorder records later, your running totals will follow the new sequence instead of keeping the original order.