Countifs with <> Value

i am using this to count the number of the "Brand Content" from that column "CCMS Range 2" also when it is not completed. Getting #UNPArseable msg.

I am new to this, not sure if i am missing any syntax.

=COUNTIFS({CCMS Range 2}, <>"Brands Content",[{Ticket Status},"120 - Completed - Project Closeout")

Thanks

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!