Using COUNTIF to return fields that contain certain test data

Devin C.

Hi Smartsheet Community,

I am trying to create a Sheet Summary field. I want to count how many times my primary column has "D:" in the task name. When I use COUNTIF it returns fields that only contains D: in the field. (See my attached pic).

Is there something that I am missing or should I use another formula?

Count within a text thread.jpg

Rachel Beck

You'll want to add the CONTAINS function into your formula -

=COUNTIF([Task Name]:[Task Name], CONTAINS("D:", @cell))

Rachel Beck

You'll want to add the CONTAINS function into your formula -

=COUNTIF([Task Name]:[Task Name], CONTAINS("D:", @cell))

Devin C.

BRILLIANT!!

Thank you very much Rachel this work great!

Question: Why does the @cell make it work? I thought it would be [Task Name]:[Task Name] but when I try that it returns a value of 0