Good morning all,
Does anyone know if there is a way to make the data validation lists searchable? I have items in my list that are similar so it would be more efficient if, when I started typing in a search bar, the results would be filtered by my letters.
I understand that you can make a search bar with ranking formulas but I have about 7 data validation lists and would rather not do that process 7 times. Is there an easier way to do this? Thanks!
Does anyone know if there is a way to make the data validation lists searchable? I have items in my list that are similar so it would be more efficient if, when I started typing in a search bar, the results would be filtered by my letters.
I understand that you can make a search bar with ranking formulas but I have about 7 data validation lists and would rather not do that process 7 times. Is there an easier way to do this? Thanks!