How can you count someone assigned to a cell if there are multiple people assigned in the same cell


Im using a metrics sheet to show home many people have RYGB symbols. However, there are some rows that have more that one person assigned to the task and it will not count their symbol if this is the case. Is there a formula that can count even if there is more than one person in the "ball in court" column?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!