Report filtering by cell choice
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.
Best Answer
-
Just noting that it works with that adjustment. THANKS!
Answers
-
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:
-
Brilliant! Works like charm. I used "has none of." Thank you!!!
-
@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
-
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.
-
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.
-
@Matt C. Let me know if you or your colleagues can help me think of a strategy for this issue. Thanks a lot!
-
Click on the "And" to change it to "Or" then change the TEE criteria to be unchecked.
-
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"?
-
Just noting that it works with that adjustment. THANKS!
-
That was going to be my next suggestion. Glad you go tit sorted! 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives