Trying to count number of high priority when other column has not certain content


Hi all,

trying to get a count for all 3-High priority for any row that has NOT the status of Resolved or Cancelled.

See screenshot below

Thanks for any help!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!