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?
Tags:
Answers
-
Try using HAS in place of CONTAINS:
HAS(@cell, "John LoVerde")
HAS will match complete individual values inside a multi-select cell.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!