Can a filter search for a specific value that shows up in any column?

edited 05/05/22 in Formulas and Functions

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


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    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!


    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!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!