Continuing the discussion from Tiller Budget (via Tiller Add-on) Comprehensive Guide:
Im using the foundation template spreadsheet and have everything set up nicely. As of a few days ago, the monthly and yearly budgets were population quite well. Now, the budget columns have the amounts populated, but all the actual expenses show as zero. Not sure what happened. Did a restore and that did not fix it.
@howard.siegal, can you please check the Transactions sheet and make sure that the word “Category” is in the header row (row 1) usually column D?
If not, add it there. If that doesn’t help, do you see any errors on the budget dashboard?
Usually when a dashboard shows errors or stops pulling data the common causes are:
- Missing header row the dashboard is dependent on (usual suspects are Date (B1), Description (C1), or Category (D1) in the Transactions sheet and Category (A1) on the Categories sheet).
- A direct edit to the dashboard (usually visualization only) has broken a formula that’s filling the cells based on data in another sheet (e.g. Monthly Budget pulls from Transactions/Categories). If there is a direct entry in one of those cells needed by the formula to output the results it breaks and you see #REF.
Let me know if any of that is helpful.
Heather