Report filtering by cell choice

Jill Bond

I hope to set up my report so that if a specific choice in a column is selected, the respective row will no longer show up as part of the existing filter. So: if XYZ column contains #3 choice (in dropdown), then that row will disappear from the report (but of course still be in the master sheet).

In this example, once "#3 archive/remove" was selected and the report saved, the whole row 12 would no longer appear in the report:

Can anyone assist? Thanks.

Jill Bond

Just noting that it works with that adjustment. THANKS!

Mike TV

@Jill Bond

Yes. Add to your existing filter a 2nd filter with "is not one of" and choose the #3 result you do not want to be displayed in the report.

I believe you're going to want to use the And connection like so:

Jill Bond

Brilliant! Works like charm. I used "has none of." Thank you!!!

Jill Bond

@Matt C. What if I want a row to disappear from the report only if TWO conditions are met: 1) 2nd filter with "has none of" and the #3 result I do not want to be displayed, AND 2) the column "TEE action done" is checked. In other words, there's a workflow: client lets me know a decision is made in the sheet, then I see that and implement it, check the box and then the row disappears...

Thanks, Jill

Mike TV

@Jill Bond

You'll want to create a 2nd filter group. The connector would need changed to an OR, I believe. For the new group, the connector between the two filter conditions would be AND. I believe that should work for you.

Jill Bond

It pulls in too much data. Here's what I tried:

And then it pulled in ALL "TEE action done" from the master sheet, which does not work.

Jill Bond

@Matt C. Let me know if you or your colleagues can help me think of a strategy for this issue. Thanks a lot!

Paul Newcome

Click on the "And" to change it to "Or" then change the TEE criteria to be unchecked.

Jill Bond

Thanks. I tried your recommendation -- it pulled in a ton of data from the master that should not be there. Here's what I put:

Maybe the outer right "Or" needs to be an "And"?

Jill Bond

Just noting that it works with that adjustment. THANKS!

Paul Newcome

That was going to be my next suggestion. Glad you go tit sorted! 👍️