# New categories not populating in Transactions tab

**URL:** <https://community.tiller.com/t/new-categories-not-populating-in-transactions-tab/31939>\
**Category:** Ask Anything\
**Created:** [May 5, 2025, 12:52am UTC](https://community.tiller.com/t/new-categories-not-populating-in-transactions-tab/31939 "2025-05-05T00:52:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![hectorlmunoz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/hectorlmunoz/32/16458_2.png) [@hectorlmunoz](https://community.tiller.com/u/hectorlmunoz)\
**Post date:** [May 5, 2025, 12:52am UTC](https://community.tiller.com/t/new-categories-not-populating-in-transactions-tab/31939/1 "2025-05-05T00:52:46Z")

</div>

I added a few categories in the categories tab, but theu don’t show up in the drop down options in the Transaction tab. What can I do?

---

<div class="post-metadata">

**Author:** ![ramerkw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ramerkw/32/14276_2.png) [@ramerkw](https://community.tiller.com/u/ramerkw)\
**Post date:** [May 6, 2025, 11:47pm UTC](https://community.tiller.com/t/new-categories-not-populating-in-transactions-tab/31939/2 "2025-05-06T23:47:39Z")

</div>

Hi,  
There are validations that may be constrained by its defined range which may now be lacking. Let’s see if I can demonstrate…

1. Go to your Transactions sheet

2. Click on the top row above the Category column to select the whole column  

3. From the **Data** menu, choose **Data Validation**. A pane will open on the right. Look for the rule that mentions the Category column letter (D in my case)  

4. Click on the rule, then look for the ‘Categories!’ range  

5. Yours may have something like Categories!$A$2:$A$XX (XX is some small number ) for the range. You can make the part after the colon, match the number of the last row in your Categories sheet e.g. Categories!$A$2:$A$33 _or_ just make the range Categories!$A2:$A

6. Click the **Done** button

This is Google sheets targeted.

Hope this Helps

---

<div class="post-metadata">

**Author:** ![hectorlmunoz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/hectorlmunoz/32/16458_2.png) [@hectorlmunoz](https://community.tiller.com/u/hectorlmunoz)\
**Post date:** [May 7, 2025, 1:38am UTC](https://community.tiller.com/t/new-categories-not-populating-in-transactions-tab/31939/3 "2025-05-07T01:38:00Z")

</div>

What an amazing reply! You win the prize. This fixed it. Thanks

---

<div class="post-metadata">

**Author:** ![Caroleen](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/caroleen/32/7859_2.png) [@Caroleen](https://community.tiller.com/u/Caroleen)\
**Post date:** [May 8, 2025, 8:37pm UTC](https://community.tiller.com/t/new-categories-not-populating-in-transactions-tab/31939/4 "2025-05-08T20:37:24Z")

</div>

This often happens if you add categories to the end of your list on the Categories tab. To avoid having to take the steps above to readjust the range in the future, I recommend inserting rows inside your category list so that you don’t add to either the top or the bottom, and then you’ll hopefully avoid this issue!