Count the number of projects assigned per person via a multi-contact cell



I have a main sheet which tracks all the different projects going on. One of those columns labelled 'CM' tracks who has been assigned. It is restricted to contact values, sometimes there is 1 contact assigned, and sometimes there is 3.

I want to be able to insert a graph on my dashboard which shows the number of projects assigned to each person, however I am struggling with the formula on my metrics sheet.

When I use the COUNTIF function, it only counts the first contact listed (e.g., if I am listed second in the list on the original sheet, it will not be counted). I have tried a range of different formulas but am unsure how to get it to count all contacts listed?

Any help is greatly appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!