I have a filter pane in a sheet that is filtering data from a column, depending on what the end user types. The data looks like this:
Object_and_Description
object_1_ red_metal
object_3_black
object_4_cotton_pink
If the end user types in anything after the first word, e.g anything that is after the first '_', then no results are pulled. Is there a way to create a LIKE or an IN function for this pane?
For any field inside filter pane , Try using fuzzy search by typing the ~_ (start typing) or ~'_ ' (start typing), All the values would start appearing in the sorted way of your search and then you can select. (or)
For any field inside filter pane , Try using fuzzy search by typing the ~_ (start typing) or ~'_ ' (start typing), All the values would start appearing in the sorted way of your search and then you can select. (or)
