HELP - Contains IF

Caravan ✭✭✭
edited 07/11/23 in Formulas and Functions


Please help. Can't understand why the below not working.

Helper is check box but I'm getting blanks. :-(

Thanks much

Kimbh ✭✭✭


Hi, how do I do a formula that will count keyword or keyword phrase? For example: How do I count have many times in a column the phrase "6.12 applies" was used.

Thank you


  • Staylo95 ✭✭✭✭
  • 06/20/23
  • This should work if you sub out the primary column for the range you want to count: =COUNTIF([Primary Column]:[Primary Column], CONTAINS("6.12 applies", @cell))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!