Can a filter search for a specific value that shows up in any column?
I have multiple columns that of type contact list. It is possible that "John Doe" may exist in any of these columns (and possibly even in more than one of these columns in the same row). Is there a way to create a filter that will filter all the rows that contain John Doe?
Or is there a way to create a single column that contains the user of multiple columns combined, so that this single column could then be searched for a name?
Thanks in advance
Answers
-
Hi @Dax67
I hope you're well and safe!
- You could add all the columns in one filter rule, or
- depending on your sheet structure, you could add a so-called helper column with the JOIN function to collect all values together and then reference that in the filter.
Would any of those options work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andree-
Thank you for the guidance. I will give it a shot. A question, would this solution allow the filter to work with "Current User"?
Thanks again
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!