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
Reporting and Project Manager
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
Reporting and Project Manager
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 :/
-
@holli.nunn What is wrong with this?
-
@Eric Law ... nothing! you solved it. Thanks so much!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives