Smartsheet Report Builder
When setting conditions to build reports, I have found on multiple occasions in the "What?" parameters, I have needed to specify more than three conditions that need to be treated with different boolean operators...ie. return rows that have "QA/QC" specified in auto assignment OR have "QA/QC" specified in Production Status AND that are in progress.
The report builder in any single parameter does not allow me to mix the boolean operators, the must all be AND or they must all be OR. What can I do with this? Is this a bug unique to smartsheet.gov
Answers
-
Hi @RKLRpp
You are correct; the current Report Builder in the GOV instance of Smartsheet will either need your operators to all be OR or all be AND, you cannot currently mix the two in the "What?" section of the Report builder.
The updated Report builder in the default instance of Smartsheet does allow a combination of operators. Please provide your feedback to the Product team to let them know that this is a feature you need updated in the GOV instance by filling in this form, here. You can also sign up for Release Note alerts for the GOV instance on this page, here.
In the meantime, you could set up a helper column on your sheet(s) with a formula built out to check all of your possible options. Then you can filter the Report based on this helper column instead.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!