COUNTIF with OR condition
Options
Hello Everyone!!
I'm trying to create a formula that counts all the "Not Started" or "Completed Late" from the same column [Action Plan Status]
I'm Trying this:
=COUNTIF(([Action Plan Status]:[Action Plan Status], "Not started"), OR([Action Plan Status]:[Action Plan Status], "Completed Late"))
But it gives me: #UNPARSEABLE
Best Answer
-
=COUNTIF([Action Plan Status]:[Action Plan Status], OR(@cell = "Not started", @cell = "Completed Late"))
...
Answers
-
=COUNTIF([Action Plan Status]:[Action Plan Status], OR(@cell = "Not started", @cell = "Completed Late"))
...
-
Yes, thank you!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!