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
[Field 2] is checked
[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?