Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Possible searching "symbols" (star, flags, etc.) using search bar?

Options

Hi,

 

By using the search bar at the top of Smartsheet I am able to find almost everything in a sheet, but a symbol. 

 

For instance, for column symbols "flag" (on/off) or "start" (on/off"), is there any syntax that would search for all rows containing "stars"? 

 

Thanks,

Carlos

 

 

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    You may have picked the two that don't work.

     

    The Flag and Stars return #Invalid Column Value when trying to return the value using a formula.

    Others (that I checked at random) return the value in text (High/Low/Red/etc...)

     

    Searching (using the search box) for the text returns the symbol row.

    Filters using "one of" work too.

     

    But not for Flag and Stars

     

    Craig

  • Carlos Eduardo
    Options

    Thanks for reply Craig.

    Indeed worked: "High/Low/Red/etc..." in text.

    Also, you mentioned "Filters using 'one of' work too". I don't know hoe this type of filter works in the search. Could you please provide an example?

    Best,

    Carlos

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    Not a search but a filter.

    On the column action menu (the down arrow icon on the lower right of any selected column), there are "Filter ..." and "Show Filter Menu" menu items.

    If the Filter menu is already displayed, it will be under the sheet/report tabs on the upper left.

     

    When building the filter, select a column with your symbols, The second column contains the criteria part of the filter.

     

     

    Filters only work on the sheet you are looking at.

     

    If you want to get more than that, check out Reports.

     

    Craig

    Filter.jpg

This discussion has been closed.