Can anyone spot an error in this formula?

JLC
JLC ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi all, I'm having trouble combining <>s in the OR function.

Using the formula below I receive one answer:

=(COUNTIFS({TACTIC actual delivery date}, >=(DATE(2019, 1, 1)), {TACTIC actual delivery date}, <=(TODAY()), @{TACTIC tactic status}, OR(@cell <> "Cancelled", @cell <> "On hold")))

 

While editing the formula to split out the "is nots" into two separate parameters gives me another answer (the correct one, when I manually counted to double check):

=(COUNTIFS({TACTIC actual delivery date}, >=(DATE(2019, 1, 1)), {TACTIC actual delivery date}, <=(TODAY()), {TACTIC tactic status}, <> "Cancelled", {TACTIC tactic status}, <> "On hold")))

Am I using the <>s in OR incorrectly? Or is this a bug? I'm using this in many formulas across a roll up sheet so want to be sure before I go ahead and change each instance to split them out instead of combining using OR.

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!