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
-
I'd probably put in a helper column with the formula below and then sum the values in that new column.
=IF(CONTAINS("Day by day", [Column Name]@row), 1, 0)
Hope this helps!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!