Hi
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.
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