Personal Finances - Net worth formula

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.

Thanks!

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.

1 Like

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