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

Vlad Koliada

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

Screenshot 1.png

Screenshot 2.png

?

Bassam Khalil

Hi @Vlad Koliada

Hope you are fine, try to use CONTAINS function with your formula.

Bassam Khalil

Hi @Vlad Koliada

Hope you are fine, try to use CONTAINS function with your formula.