Is there a function that counts a cell if it contains a value rather than equals that value?

Is there a function that counts a cell if it contains a value rather than equals that value

if you have cells with

"dog", "cat", "cat dog"

and you want to count "dog" using excel you can use this formula

=COUNTIF(A1:A3,"*dog*")

but the * doesn't seem to work in smartsheet

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!