Hi!
I’m new to Airtable, trying to make a monthly budget, and I started with the “Small business budget” template. I want the end of month balance for each month to roll over to the next month, but I can’t figure out how to do that. In Excel, I would use a formula referencing the previous end of month balance for the next one (eg: end of month balance = {Income (actual)} + {Previous end of month balance} - {Expenses (actual)} )
Do I need to create a new table with lookup or rollup fields? How can I reference the end of month balance for each month separately?
Thanks so much.