The Monthly Budget Calendar chokes on 2024 and I can’t figure out how to edit/fix.
@Edward 's ‘help’ topic (https://community.tillerhq.com/t/docs-monthly-budget-calendar-sheets/163250 is closed to comments.
So I are here What’s the best way to get 2024?
Right click on the dropdown cell and add a 2024 to the selection criteria.
If you want, you can also add a column to the far right of the sheet and in that column put in the unique years and then just reference that in the dropdown. But if it’s only a once a year thing, you can just keep adding years to the dropdown.
Thank you, but even your kind explain goes over my head. I see no option in a right click to add /change criteria. I have tired to write in (edit via drop down) 2024 and I get an error.
I tried to reference from a far right cell and I get the same error.
I can’t figure out where J1 is getting the data from or I’d try altering that.
The error is:
There was a problem
The data you entered in cell J1 violates the data validation rules set on this cell. Please enter one of the following values: 2023, 2022, 2021, 2020.
Right click and select “drop down” then add a choice for 2024.
Well, when you say it that way!! Thank you thank you thank you.
2024 in operation now.