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!