I am using airtable to manage a budget, I would like to be able to add the sum of numbers from one row, (as an ending balance for example) to a column in the row below it (as a starting balance for example). So I can see a running total.
The use case would be, my ending balance at the end of Month 1, is my starting balance for Month 2, so on and so forth. This way I can evaluate how much my ending balance will be in Month 6 if I add x amount to my budget in Month 1.
I have tried several ways, but end up with circular references. Is anyone able to offer some ideas or input on functionality I am missing to be able to accomplish this?