counting from a multi select cell


I do not have clue where to start with this formula

I working on a behavior observation and i want to count the number of behaviors observed.

Problem is countif({column 1}, "PPE")

won't work if it is not first in the cell on a multi selected drop down cell.

any help is welcome

I will also need to be able to count the behavior and a department as well for another formula

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!