Skip to main content

Personal Finances - Net worth formula

  • May 1, 2020
  • 2 replies
  • 42 views

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

Forum|alt.badge.img+1
  • New Participant
  • May 1, 2020

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.


  • Author
  • New Participant
  • May 1, 2020

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