# Savings Budget dropdown not offering new month **URL:** \ **Category:** Ask Anything\ **Created:** [August 11, 2023, 4:42am UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085 "2023-08-11T04:42:22Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 11, 2023, 4:42am UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/1 "2023-08-11T04:42:22Z")
I have been enjoying the new Savings Budget . I have a problem that the month of August will not drop down on my Savings Budget . The monthly Budget dropdown worked fine. I have searched the community, but didn’t find anything about this. Does anyone know how I can get this corrected? Please give directions in simple terms because I don’t know my way around Tiller that much. Thanks. ---
**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:** [August 14, 2023, 3:59pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/2 "2023-08-14T15:59:10Z")
I’m not sure what you mean by it “will not drop down”… is August not listed in the dropdown? Or is the dropdown not functional? Can you see the arrow next to the dropdown control? ---
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 14, 2023, 6:37pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/3 "2023-08-14T18:37:24Z")
August is not listed in the drop down menu on my Savings budget sheet… But on the monthly budget I have all the months on the dropdown. Now the dropdown is not even working and it has a red triangle in the right top corner and says invalid, but I have not tried to put any thing in that cell. I don’t see an arrow , but there is an edit button usually on the bottom on the drop down . I deleted " July " in the box and now everything is blank and I have no months available. It also has erased the sort by box “Savings”. Yikes- it’s getting worse. ---
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 14, 2023, 6:43pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/4 "2023-08-14T18:43:24Z")
Now my whole Savings budget is missing. ---
**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:** [August 15, 2023, 12:31am UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/5 "2023-08-15T00:31:48Z")
If you haven’t done much categorizing in the interim, I’d recommend restoring you spreadsheet back to when it was in a good place. You can make changes again from there. ---
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 16, 2023, 2:11pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/6 "2023-08-16T14:11:33Z")
I was away yesterday so I was not able to try anything. I now have no dropdown and my data has all disappeared. I don’t know how to go back and restore my spreadsheet since I have no months showing?? Are you saying I have to go back and start another Savings Budget? Then I will lose all my budget journal notes and have to start from scratch again. I’m sure my data is somewhere. I just don’t know enough to get it restored. ---
**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:** [August 16, 2023, 2:50pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/7 "2023-08-16T14:50:05Z")
If you haven’t categorized a lot of data since the challenges began, you can go to `File/Version History/See Version History` and return your spreadsheet to the state before it broke. ---
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 17, 2023, 8:03pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/8 "2023-08-17T20:03:44Z")
Thank you , Randy! I now have restored my Savings budget sheet back to July 11 and I have only 23 transactions to categorize, BUT my problem remains–the dropdown does not offer August so I cannot go forward. In the past the month shows up on the dropdown menu when it becomes that month. ( but on the monthly budget sheet- which I don’t use much- the dropdown offers every month of the year.) How can I get August to show on my Savings budget sheet? ---
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 23, 2023, 1:13am UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/10 "2023-08-23T01:13:23Z")
5 days ago I wrote to Randy stating I still have my original problem that I have no option of the month of August when I do the dropdown. Only January through July are available. I cannot go forward with my Savings budget without it. Do I have to start all over with another savings budget? It must have something to do with the formulas for the dropdown. The funny thing is that the monthly budget has all the months on the dropdown! I don’t see anyone replying to my question in the Tiller community , except Randy. Any more suggestions? I have been stalled for over a month. This Savings budget is the main reason I use Tiller, with the rollover feature. ---
**Author:** ![richl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richl/32/888_2.png) [@richl](https://community.tiller.com/u/richl)\ **Post date:** [August 23, 2023, 1:43am UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/11 "2023-08-23T01:43:25Z")
I am sorry you’re not getting the answers. Why don’t you download the template again and copy the date dropdown from the template and paste into the dropdown cell on your sheet. I am assuming this is only issue with the current sheet But give it a shot and report back. ---
**Author:** ![richl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richl/32/888_2.png) [@richl](https://community.tiller.com/u/richl)\ **Post date:** [August 23, 2023, 3:08am UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/12 "2023-08-23T03:08:47Z")
If that does not work, Go look at Cells BE50: BE61 to ensure the months are actually listed there. ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/8/809e66736ef931e8d62f909f3a464b56bb844a5d.png) ---
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 23, 2023, 4:30am UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/13 "2023-08-23T04:30:09Z")
I pushed the edit mark at the bottom of the dropdown Data validation rules popped up on the right of my screen. Under Criteria it said dropdown ( from a range). Under that was =‘Savings Budget’!$BE$50:$BE$61 Under that only January through July were listed. How can I add the rest of the month ? ---
**Author:** ![richl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richl/32/888_2.png) [@richl](https://community.tiller.com/u/richl)\ **Post date:** [August 23, 2023, 1:25pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/14 "2023-08-23T13:25:20Z")
Look at the reply right above your last one. You will need to go to the cells ( unhide them) and make sure the e cells have the correct months listed ---
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 23, 2023, 5:58pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/15 "2023-08-23T17:58:42Z")
I’m sorry , but how do you find the cells? “e cells”? (If you haven’t guessed by now, I am not all that acquainted with Tiller or computers in general. Once I have something set up and working I don’t explore.) ---
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 23, 2023, 6:19pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/16 "2023-08-23T18:19:45Z")
I did find the cell that you pictured and it only shows January through July for the month dropdowns. How can I add the rest of the months? ---
**Author:** ![richl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richl/32/888_2.png) [@richl](https://community.tiller.com/u/richl)\ **Post date:** [August 23, 2023, 6:33pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/17 "2023-08-23T18:33:09Z")
I assume the other cells are empty? You can just type them in ---
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 23, 2023, 6:40pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/18 "2023-08-23T18:40:30Z")
Rich, I tried to change the selected active period from 7/1/2023 to 12/1/2023 in the References. But it didn’t add the months in the dropdown right below that in the Period dropdown. Do i have to save or confirm the change to have it take effect? ---
**Author:** ![richl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richl/32/888_2.png) [@richl](https://community.tiller.com/u/richl)\ **Post date:** [August 23, 2023, 6:44pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/19 "2023-08-23T18:44:35Z")
No, in cell BE 50 through BE61 it needs to looks like this ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/2/20f5b1153ddf4dbcf85c6a3446c28538e1575773.png) ---
**Author:** ![richl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richl/32/888_2.png) [@richl](https://community.tiller.com/u/richl)\ **Post date:** [August 23, 2023, 6:56pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/20 "2023-08-23T18:56:39Z")
Actually scrap that. The formula is looking pretty complicated. It is reading your Categories Sheet for Dates. Do you have an August 2023 Date listed in you CAtegories Sheet on the first Row ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/6/6d6785909bacdc2091d54b104e55268091b42290.png) ---
**Author:** ![macata75](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/macata75/32/1902_2.png) [@macata75](https://community.tiller.com/u/macata75)\ **Post date:** [August 23, 2023, 6:59pm UTC](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085/21 "2023-08-23T18:59:43Z")
Thank you for answering my simple questions. I see what it should look like. January is listed at the bottom and July is at the top on mine. When I put my cursor over July I think it erases July and I don’t want that. How do I get it to insert more months? And what should the selected active period be? As I said before, when I changed it from 7/1/2023 to 12/1/2023 it made some changes so I had to go back and restore my data like Randy said to. [Next page](https://community.tiller.com/t/savings-budget-dropdown-not-offering-new-month/19085.md?page=2)