CountM with multiple conditions

Options

Hello,

I am working on a formula that takes information from another Smartsheet. The column I am taking information from happens to be a multiple drop-down box. I want to be able to take certain text from the drop down box with other criteria. Essentially I would like a Countifs that can account for a multiple drop box column type.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!