Hi - Please can someone tell me why my actuals on the yearly budget not pulling though?
Greg
Hi Greg,
Can you check this help article and let me know if it doesn’t solve it for you?
My actuals are also broken @gregharris239 and none of the mentioned fixes in the FAQ are relevant for me (all the text matches where it’s supposed to)
Can you double check that the year 2021 is selected on the Monthly Budget dashboard using the drop downs at the top?
Yes it’s selected. I also imported a bunch of old transactions manually, selecting different months and years and it seems none are actualizing
The one clue I have is on the hidden portion of Monthly Budget, the red Actual section in Columns T-W is blank and doesn’t update. On a copy of the template I made for offline edit testing those column are working and update when I throw in a new transaction and/or category. The formulas on that sheet match what’s in my active one though.
@hgyoung, I just sent you an email via our official support channel, let’s troubleshoot this via that channel. Thanks!
Just to close the loop here from @hgyoung’s issue.
In the hidden area on the Monthly Budget dashboard the formula in V15 was broken and couldn’t write out the array (there was a REF error) and it was complaining about not being able to write out the array due to text in W15.
I cleared the text from W15 and the formula in V15 was able to write out the data and fill in the actuals.
I’m not sure why adding transactions manually might have affected this and I don’t think @hgyoung intentionally wrote the word “Actuals” into cell W15 in that hidden area so I think it’s a one off issue 
I validated in the master copy of the Foundation template that this is not an issue.
1 Like
Hi Heather
Yes, that fixed it 
Thank you
2 Likes
Nice debugging, @heather! 
2 Likes
Hi @heather,
Its looking like I am having the same issue. I went to the same place but there is no text or REF errors :(. The formula was missing in V15, so I copied and pasted from my 2021 spreadsheet, but it hasn’t worked.
Any help would be appreciated!
Roselyn
Hi @heather, I too am running into what I think is a very similar issue to the above problems outlined. I have been adding in 2021 data over the last 2 weeks or so, slowly categorizing transactions and as of this morning, none of the actuals are pulling through anymore on my monthly or yearly budget pages.
I tried following your solution from @hgyoung’s problem but don’t see any text in W15 at all.
In fear of messing something up, I don’t want to trouble shoot this myself - any thoughts?
Thanks!
Welcome, @dburke03 
Given that this is a Foundation Template issue and not a Community Solution issue, I’d reach out to our support team using the chat tool in the lower right of the Console at https://sheets.tillerhq.com/auth/login and choose > spreadsheet question > Question about Google Sheets
We also have this FAQ with several troubleshooting tips:
Heather