HELP - Contains IF

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

Hi,

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

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

Thanks much


Kimbh ✭✭✭

06/20/23

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

Answers

  • 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))


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!