Trying to count multiple people in a cell

BryanHeft
BryanHeft ✭✭
edited 12/09/19 in Formulas and Functions

I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked.  I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard. 

I am using the formula: =COUNTIF({Project List Range 3}, Assigned1)

Where Project List Range 3 is the Column in my master sheet that is the Contact List Field with assigned project members and Assigned1 is the name of an individual.  

If the individual I am searching for is the only name in the field, it gets counted correctly.  If there are multiple people assigned in the field, it does not count any of the names.

«1

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!