how to formula contain in a cell

Hi, i am trying to formulate countif and contain in a formula but can't seem to do it right. i want to countif the cell in this column contains certain words because some columns would have two answers so the direct countif , value = xyz doesn't do the trick.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!