Search for specific words within texts

Luiz Silva · 05/29/23

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.

Kelly P. · 05/29/23

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!

Formulas and Functions