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.


Best Answer