Category missing from dropdown


I am trying to add new categories to an existing spreadsheet - and delete old ones. It was working well but then suddenly, any category i enter in the categories sheet is not appearing as a dropdown in my transactions sheet.

Hi @joek can you take a look at this help article and let me know if it helps.

in the data validation box, cell range is Transactions!D2:D5933
and categories is Categories!$A$2:$A$156

If i try to shorten the categories to Categories!A2:A all of my categories go to error

it seems that the problem is when i add new categories to the bottom of the categories sheet

I think i figured out how to fix it. I am not sure why it wasnt working but now my data validation looks like it does in the example