Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Personal Finances - Net worth formula

Topic Labels: Formulas
1678 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

2 Replies 2

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.

image

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