I can't figure out how to use the OR function in a Countifs formula

Hello,

I have been creating metrics on my data in smartsheet using the different formulas.  I have figured many out (with a lot of head banging and sleepless nights), but cannot figure out how to use the OR function.  

works: =COUNTIFS({Week}, =$[Date Range]$3, {Month}, $[Date Range]$5, {Year}, $[Date Range]$8, {task status}, "PCC Case Submitted")

Does not work: =COUNTIFS({Week}, =$[Date Range]$3, {Month}, $[Date Range]$5, {Year}, $[Date Range]$8, OR({task status}, "PCC Case Submitted", "PCC Case Now Closed"))

What I am doing wrong with the or functionality?

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!