Report Filter Conundrum
I want to filter out these parameters - A project has 'New Store Unchecked' and 'Survey Scope Unchecked'
The problem is that when a project has New Store Checked it will always have Survey Scope unchecked so I cant filter by 'Survey Scope Checked' as 'or' in the filter because I need to see those New Stores.
Is there anyway to get this to work?? Here's what my filters look like
Best Answer
-
Hey @holli.nunn ,
Have you considred having 2 groups of filters, similar to the one you did, with an OR on all of them?
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
Answers
-
Hey @holli.nunn ,
Have you considred having 2 groups of filters, similar to the one you did, with an OR on all of them?
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Hi @Itai, yes I set up the same group but with 'New Store Unchecked' and 'Survey Scope checked' as an 'or' but it still pulled the information in because the first group is telling it to :/
-
-
@Eric Law ... nothing! you solved it. Thanks so much!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- I thought combining the four different sheets into one report would eliminate the need to share all four separately. However, I was just informed that they're unable to see the context of the report, …
- Hello, I created a smartsheet with a form, and when I saved this smartsheet as a new file so I could keep the template, I can't get the form to show on the left hand side of the screen for easy access…
- I am trying to make a widget for a dynamic dashboard that shows how many child level 2s and if the "Closed?" box is checked or not. I would like to make it a pie chart if possible. The level column is…
