# Year-To-Date Comparison Sheet Not Populating YTD Budget Line Items **URL:** \ **Category:** Google Sheets\ **Tags:** google-sheets, how-to, troubleshooting, tcs-ytd\ **Created:** [October 8, 2021, 2:51am UTC](https://community.tiller.com/t/year-to-date-comparison-sheet-not-populating-ytd-budget-line-items/9942 "2021-10-08T02:51:14Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![bazza\_g](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/bazza_g/32/7427_2.png) [@bazza\_g](https://community.tiller.com/u/bazza_g)\ **Post date:** [October 8, 2021, 2:51am UTC](https://community.tiller.com/t/year-to-date-comparison-sheet-not-populating-ytd-budget-line-items/9942/1 "2021-10-08T02:51:14Z")
Populates ‘Actual;’ and ‘Favorability’ but not ‘YTD Budget’. Looking for a solution as to why - thanks! ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [October 8, 2021, 4:35pm UTC](https://community.tiller.com/t/year-to-date-comparison-sheet-not-populating-ytd-budget-line-items/9942/2 "2021-10-08T16:35:43Z")
👋 @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? ---
**Author:** ![bazza\_g](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/bazza_g/32/7427_2.png) [@bazza\_g](https://community.tiller.com/u/bazza_g)\ **Post date:** [October 9, 2021, 12:12pm UTC](https://community.tiller.com/t/year-to-date-comparison-sheet-not-populating-ytd-budget-line-items/9942/3 "2021-10-09T12:12:46Z")
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. Thanks, Barry ---
**Author:** ![Brad.warren](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brad.warren/32/896_2.png) [@Brad.warren](https://community.tiller.com/u/Brad.warren)\ **Post date:** [October 16, 2021, 12:25am UTC](https://community.tiller.com/t/year-to-date-comparison-sheet-not-populating-ytd-budget-line-items/9942/4 "2021-10-16T00:25:28Z")
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. ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [October 18, 2021, 3:12pm UTC](https://community.tiller.com/t/year-to-date-comparison-sheet-not-populating-ytd-budget-line-items/9942/5 "2021-10-18T15:12:54Z")
Any chance @Brad.warren’s [suggestion](https://community.tiller.com/t/year-to-date-comparison-sheet-not-populating-ytd-budget-line-items/9942/4) helped, @bazza_g? ---
**Author:** ![bazza\_g](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/bazza_g/32/7427_2.png) [@bazza\_g](https://community.tiller.com/u/bazza_g)\ **Post date:** [October 19, 2021, 6:37pm UTC](https://community.tiller.com/t/year-to-date-comparison-sheet-not-populating-ytd-budget-line-items/9942/6 "2021-10-19T18:37:20Z")
Unfortunately not, as when I did check N15 is was in fact set to 2021 - ---
**Author:** ![mgobluedan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mgobluedan/32/8517_2.png) [@mgobluedan](https://community.tiller.com/u/mgobluedan)\ **Post date:** [June 11, 2022, 8:27pm UTC](https://community.tiller.com/t/year-to-date-comparison-sheet-not-populating-ytd-budget-line-items/9942/7 "2022-06-11T20:27:29Z")
I was able to solve the same problem in my sheet. The issue appeared to be with a “space” value in some of the first row of values that was throwing off the calculations. I opened the hidden fields, then I went to “U2” and did a backspace (to delete all contents in this cell). This got the rest of the “type” column to fill. Then I went to “Y2” row and did a backspace. This got the “Category Row” column to fill, causing a cascade of other columns to work and the sheet to work as planned. Hope this helps some other people!