Formula to chose 1 value from the range, mentioned in one cell


There is a cell with number of activities, related to accountable people. Plese see screenshot #1 attached. This cell reffers to "Accoutable" column in other SmartSheet table. See screenshot #2. The problem is "Accontable" column in intitial sheet contains more then 1 Accontable person's names. Formula, I used: =COUNTIFS({Accoutable}; @cell = Accontable@row; {Status}; "In progress")

Q: How to chose 1 particular Accountable from the range, mentioned on screenshot #2


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!