Year-To-Date Comparison Sheet Not Populating YTD Budget Line Items

Populates ‘Actual;’ and ‘Favorability’ but not ‘YTD Budget’. Looking for a solution as to why - thanks!

:wave: @bazza_g !

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… :grin:

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.

Any chance @Brad.warren’s suggestion helped, @bazza_g?

Unfortunately not, as when I did check N15 is was in fact set to 2021 -