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

Dax67

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å

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!

Dax67

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