I just helped another user with a similar issue. Have a look at this thread, @delaney.
Another issue we identified is that the dropdowns in column A
populate from a query range in O8:O
. If you have a ton of accounts in the hidden area in O8:O
, it is possible that the available accounts in the dropdown will clip. You can fix this by selecting A8:A
and updating the data validation range.
Hope this helps.