Populates ‘Actual;’ and ‘Favorability’ but not ‘YTD Budget’. Looking for a solution as to why - thanks!
Do you have budget targets set on the Categories sheet for all your categories there? What month is set in column E on the Categories sheet?
Hi Heather -
Thanks for the response. I wanted to confirm how you mean ‘budget targets’? I do have amounts set for each category in Column E.
And the month set in Column E is January, 2021.
Is it possible to share screen grabs? I think that would be helpful to illustrate.
Hi @bazza_g :
Working without a net here…
On the Year to Date sheet, if you unhide Column N and look in the cell N15, does it read 2021? If not, change it to 2021 to see if your budget numbers then populate.
I changed this cell to 2018 (for example) on my sheet to reproduce the effect you may be seeing.
Let me know.