How to Make a Savings Tracker in Google Sheets

[@LivePlayWatchPixels]

Cleaver and great. THanks man

[@spreadsheetlife]

Thanks for watching! 😄👍

[@desireegaling6941]

What did you click regarding the "F4" in the formula? Asap.

[@spreadsheetlife]

I just pressed the F4 key on my keyboard. Depending on your keyboard, F4 may share a key with something else. You might have to press the Fn key plus the shared key that contains F4. I hope this helps. 😊

[@tal7atal7a66]

thanks, very useful topics ❤

[@spreadsheetlife]

Super glad you've found this useful!! 😄👍

[@RosiePoulier]

Thanks for this super helpful video. How would I add in a section for debits from a save category (Ie when money is used within that category such as travel)?

[@spreadsheetlife]

What you can do is add a new column, perhaps between columns C and D. Name it "Debits" or whatever you like. And then you can enter the debit values manually.
Then all you'd have to do is adjust the formula for the saved column to also subtract out the debit values. Just add a minus sign after the SUMIFS function, and subtract the debit value. I hope this helps.

[@musicalfantasy3701]

Slight issue, when the amount saved in a category exceeds the goal amount, the chart extends downwards into the negatives, have I missed a step?

[@spreadsheetlife]

You did not miss a step. It was actually a mistake I made in the video. I forgot to consider the scenario where the saved amount exceeds the goal amount.
To solve this problem, change the formula for the remaining numbers to the following.
=IF(goalAmount