Counting multi select column that is also contact list


I have Contact list - multiple resources can be assigned task

I want to count the number of times a particular resource has been assigned a task.

I've tried these both:

=COUNTIF({Staff Actions Range 4}, HAS("Joe X", {Staff Actions Range 4}))

=COUNTIF({Staff Actions Range 4}, CONTAINS("Joe X", {Staff Actions Range 4}))

Both return 0 which is not correct

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!