Autofill not formatting category dropdown

[asparagus_plant303]

Hi - I have been using the sheet for a few years, but in the last few months, autofill from my credit cards has not been picking up the category dropdown formatting. However, the manual transaction import is properly picking up the category.

You can see in this example, the whole foods transaction is from a credit card autofill and the Philz coffee is from my debit card via a manual import.

Any tips how to fix this?

[Mark.S]

Check out the bottom of your Transactions sheet and see if the Category with no dropdown exists there. Fill adds transactions to the bottom of the sheet and the formatting there would get duplicated.

Also note that the date formats are different in your screenshot.