Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Report Builder - Using [or] and [and] within the What group
I am building a report and need to build the following condition in the What filter group:
[Field 1] is not checked
and
[Field 2] is checked
or
[Field 3] is checked
In other words, it will first look for rows where [Field 1] is not checked and then further filter that dataset to only show rows where [Field 2] or [Field 3] is checked. However, it looks like I cannot mix AND and OR functions within the same group.
Any thoughts on how to accomplish this? Moreover, can this be added to the feature request list?
Comments
-
Ramsay,
One way to do something like this is to do the logic in a separate column using IF() functions and then use that column in the report builder to select rows that meet the condition.
-
Ramsay,
I'm pretty sure Jim's solution is the best (and only viable one
Make sure you get your paranthesis correct or use the AND/OR functions
=IF(AND(NOT([Field 1]23),OR([Field 2]23,[Field 3]23)),1,0)
shoudl be faster than a longer set of IF statements.
Craig
-
I would like to see the original post added to the feature request list as I have a similar requirement. Not only to be able to have a combination of "and" and "or" in the report request but to be able to group them appropriately (ie equivalent of being able to parnethesise as needed). I don't want to add extraneous columns into my original sheet as it is used and viewed by many.
-
I just realized that this is an issue too. Should not have to do an IF formula to use "and" and "or" versus "and" and "and" or "or" and "or."
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives