Personal Finances - Net worth formula

Topic Labels: Formulas
2789 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

So I finally imported all of my finances into Airtable. I tried to make a net worth graph but the issue is that I do not have an updated balance each day - only when I make a transaction.

Is there any formula I can create where it keeps the value the same until the next time it is changed? Also, I need to add up the values from each account but again, they have transactions on different days.


2 Replies 2
5 - Automation Enthusiast
5 - Automation Enthusiast

formulas, by definition, automatically calculate therefore you can’t keep values stored in a formula all.

I think if you could show the structure of your airtable, it would help.


Here is the table. The “net worth” tab is what I am trying to create this formula in