Countif status is "In Work" and Multiple choice contains


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!