0
So I have in google sheets, a drop down list populated using data validation (created via script).
In the drop down cell when you start typing, it will filter the available drop down options based on what you have entered so far.
But it only shows valid options if you enter characters from the beginning of the data.
My question is, is it possible to have it filter the list by substring, rather than starts with string?
For example in the sample data, if I typed in 'ee' I would want it to show me all the list options that have a 'ee' in them (So I would be presented with 'Tree' and 'Weed' in the drop down options).
Is this possible?