Hello and good morning Smartsheet community,
I know you can use the =COUNTIF in order to count the number of times a (SINGLE) name or word appears in a range of cells. My issue is that I am trying to count how many times the word safety is used in a range of cells where the word safety is used in a sentence and not the only word in the cell. Is this possible and if so, I would truly appreciate any help. I hope everyone has a spectacular day!
Help Article Resources
Check out the Formula Handbook template!