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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!