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
-
Hi @Vlad Koliada
Hope you are fine, try to use CONTAINS function with your formula.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Vlad Koliada
Hope you are fine, try to use CONTAINS function with your formula.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
Check out the Formula Handbook template!