Hello – For some peculiar reason when I’m typing in the Category field on the transactions sheet auto complete is not working from. Looking at older transactions I have a drop down in the category field that got lost at some point and I no longer have the drop down in the category field. Appreciate any suggestions.
For some reason new transactions are missing the validation rule in the category field. Adding the validation manually fixes the problem but unclear why this is happening to begin with.
Make sure you re-add the data validation for the entire column (except the header), @jasonabeckett. When new rows are added, they clone formatting from nearby rows so if your bottom-most row doesn’t have the data validation, there is a good chance that new rows won’t have it either.
Here is a good article that describes in detail how to update your data validation