Cell has multiple data?

Options

Hello,

Hoping someone could help with a simple formula from another sheet that has multiple drop downs?

=COUNTIF({DATA COLUMN}, HAS(@cell, "ICM" + "PCM"))

I want to count how many times "ICM" and "PCM" appear together in a drop down cell from another sheet. They could be selected individually which i dont need just when they occur together.

Thank you

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!