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.
bassam.khalil2009@gmail.com
☑️ 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.
bassam.khalil2009@gmail.com
☑️ 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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!