How to find an embedded string in a filter pane

[pnvenkat]

Hi,

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?

[vikramv · Accepted solution]

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)

The other way is to use Smart Search .

Thanks

Vikky.

[pnvenkat]

thank you! it worked!

[vikramv]

Welcome !!