Randy , to make it easier I am attached a screenshot of the category sheet. All was working well till I added Long term goals after watching your savings report video. This would account for money I accrue to send to my savings account.
Mostly, your Categories sheet looks good. The one thing I’m not used to seeing is the reuse of type names as group names (e.g. Income and Transfer). I don’t THINK that should cause problems but I’m not totally certain.
Have you tried restoring the Savings Budget sheet yet using the add-on? You will not lose any data and this may fix the issue if any formulas have been broken.
Hi! as reviewed by Randy, my categories and groups look good and the spreadsheet is filled in properly. He asked if I had tried to restore the savings budget sheet and I will over the weeknd. I will need to research that and hopefully there is a video to help. I will respond back to Randy as well.
No, I have not tried restoring the savings budget. If there is a video tutorial, please send me the link as it will be helpful. I will try to work on it over the weekend. It’s strange how the error surfaced.
Randy, Thanks so much for reviewing this issue and assisting with solutions.
Thanks Randy, it worked.
I still have this minor issue after making another sheet for the rental property expenses. These 2 items are paid from my budget with all other lines reflected on the new Rental budget page. This also shows correctly on the monthly budget but the -House Shopping needs shows on 2 lines. I can live with this if it can’t be fixed as I will be moving these expenses in a few months after the unit is rented.
Glad to hear the restore fixed the Savings Budget.
Unless you have a template with a ton of data manually typed directly into the template (i.e. green cells), running a solution-restore is an easy first step to troubleshooting. Maybe start with that on this template as well, @ljmcleggan?
If restoring this dashboard doesn’t help with that issue I’d recommend checking all your entries in the Transactions sheet in the Category column and make sure everything is spelled exactly the same way by copying a correct entry over all the other entries. I’ve seen double lines like this when there is an extra space before or after a category or even a different letter being capitalized in one but not the other.