How to count elements that contains part of the string



I'm trying to countif elements in the column that starts with a string "apple".

E.g: I have 30 rows with strings like: "red apple" "yello apple" "green apple".

I uses formula Countif(childern(fruits),CONTAINS("apple",children(fruits))) but it doeas not work.

Thanks for help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!