I am having recurring errors with a weekly budget spreadsheet. I have gone through creating clean budget sheets 4 or 5 times, only for the error to either be there form the beginning, or, in the current case, to emerge after the sheet was working for 48 hours.
For whatever reason the rollover value is populating as N/A which is throwing the entire budget for a loop and cascading errors.
Have you tried restoring the dashboard? Add-ons > Tiller > Budget > Restore Dashboard?
That should correct errors here. Usually these appear when you’re directly editing the dashboard budget values. I’ve also seen weird errors appearing if any of the Amounts in the Amount column are not formatted properly as currency or have extra invalid characters (like a , instead of a .)
Finally, the template expects that you’re using U.S. date format month/day/year in the date column.
There were in fact errors in the Budget History sheet, and manually fixing them correct the errors. However, as soon as my next weekly budget period populated, the errors returned and I had to manually fix them again to remove the errors.
To clarify, these errors are appearing before I even tried to edit the budget history tab (or even knew it existed). The amount for each “Budget” since I created the spreadsheet is populating as W01 and Rollover as “n/a”. Rollover Mods are also populating as W01. If I manually replace each Rollover Mods as $0 and Rollover as $0 and manually enter each correct Budget line, the errors go away. But each week when the new Budget generates (this happens on Saturdays for me), the W01 and n/a fields snap back and the errors return.
And even before the new weekly budget populated, the errors returned overnight (during a time when I did not access the sheet). Since this is a branch new template, this would seem to point to bug in the sheet. One of my two income lines is populating as W01 for most values, which seems to be the primary issue. Unsure if the n/a’s are contributing as well.
Thanks for giving me the opportunity to explore this further with you. It looks like the Tiller Budget cannot handle a category called “Budget” I changed that in your test sheet to “Income Budget” and then re-ran Analyze Budgets History and that fixed it.
Let me know if you have further issues with it.
FYI @randy we should probably fix this at some point?
Are there any other category names that might trigger a cascade of #N/As, or anything else that can typically cause this problem? I am randomly having the same issue now with both my yearly budget and my monthly budget and I can’t figure out what I did. I do not have the Budget Add-on. Everything is showing up on the yearly and monthly budget as #N/A except for the Budget section, which shows $0.00.