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

Ramsay ZakiRamsay Zaki ✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts
07/29/16 Edited 12/09/19

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

  • Jim HookJim Hook ✭✭✭✭✭

    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. 

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    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."

This discussion has been closed.