COUNTIFS with OR

Hello! Could I please get some help with this COUNTIFS? The intention is to count the rows where 1-Ref is either Complete or Attestation. I tried the below but it's currently returning UNPARSABLE.

=COUNTIFS([1-Ref]:[1-Ref], OR(([1-Ref]:[1-Ref] = "Completed", ([1-Ref]:[1-Ref] = "Attestation"))

Thank you!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!