Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Summing record within one table

Topic Labels: Formulas
286 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

0 Replies 0