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?
Comments
-
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
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives