Using COUNTIFS to find a partial text match in 1 cell + other conditions


Hi Smartsheet Community,

I'm having trouble with a COUNTIFS formula and hoping you can help. I'm trying to count all rows that are assigned to a specific person. Because it's possible to have multiple assignees for a task on my sheet, I need to do a partial match for the assignee name.

Here is the formula I've created:

=COUNTIFS({Range}, CONTAINS("Doug", @cell))

For some reason this formula is returning 0 instead of the correct value. Can someone please let me know what I'm doing wrong?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!