Countif status is "In Work" and Multiple choice contains

Options

Hello All,

I am trying to establish a Countifs formula that first checks status, then looks for a specific multiple choice option. Is this possible?


=COUNTIFS({AD-CVT Disc Status}, "In Work"), ({Above Findings}, (CONTAINS(Primary Column]@row, @cell))


Any help is appreciated! Thank you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!