I am using the Bill Payment Tracker to try and keep myself, well, on track. But I’ve run into an odd thing. In the Bill Setup Section, once I go below line 40, the monthly checkboxes don’t appear. Is it me? And even if it is, is there a fix? Thank you so much!!
1 Like
Hmm. I have 49 items down to row 72. Not sure what you are running up against.
Can you clarify which column you mean? I don’t use the tracker myself, but it looks like there is some data validation in the sheet that you can check.
Column B has a formula for the drop down - apply to range: ‘Bill Payment Tracker’!B24:B250 and the dropdown range: ‘Bill Payment Tracker’!$AE$2:$AE$22 - this simply refers to where the range information is located.
Columns H-S have checkbox: ‘Bill Payment Tracker’!H24:S250
Is it possible that one of those validations got changed? if not, if you haven’t customized the tracker, you can always redownload the sheet and see if it still doesn’t work. You can make a copy of the sheet with issues, so that if the new sheet doesn’t fix the problem, you still have to original.
Thanks for the helpful suggestions. I downloaded a fresh sheet and all is well! 