Filter for Assigned To in multiple columns

In my sheet, I have a few columns of assignments for different tasks. Is there a way to create a filter which will show any row that has a specific person assigned, but also must have a Check Box checked, in a specific column?

I know there is the At Least/All toggle, but I'm looking for something that will offer an option for If column A or B contains Matthew, and the box in column C must be checked.

I don't want to run a report because I want this it to be a quick view so I can continue editing.

Thanks

Find more posts tagged with

Project Management

Accepted answers

Andrée Starå

Hi @Matthew Colchamiro

Unfortunately, as far as I know, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could add a helper column (checkbox) that gets checked if the same criteria and then use that in the filter instead.

Would that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @Matthew Colchamiro

Unfortunately, as far as I know, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could add a helper column (checkbox) that gets checked if the same criteria and then use that in the filter instead.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

Matthew Colchamiro

Thank you. I submitted a request.

Andrée Starå

@Matthew Colchamiro

Excellent!

You're more than welcome!

Would my suggested workaround help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Matthew Colchamiro

Yes thank you - the work around did work.

For anyone else trying/learning, here's the formula, where the test between the [...] are column headers and the text between the "..." is the what you're searching for. Using @row, allows you to copy the formula to any row and the 1 at the end makes the check box be checked.

=IF(OR([INGEST ORDER ASSIGNED TO]@row = "Matthew Colchamiro", [ECC ORDER ASSIGNED TO]@row = "Matthew Colchamiro"), 1)

Andrée Starå

@Matthew Colchamiro

Happy to help!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.