Search for specific words within texts

Hello community,

I would like to know if within the smartsheet there is any way to search cells through specific words, using a count formula for example.

Within Excel we use * to search for a word that is together with others. Example:


=COUNT.SES($C$31:$C$67;"Day by day*";$D$31:$D$67;E280)


This formula brings the count of cells that contain Day by day regardless of what comes after.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!