Trouble Displaying List of Names from a Countif Formula
Hi Community,
Please help :)
I have used the Countif formulae to bring back the number of times the value "Red" Appears in smart sheet.
This brings me a value of 4. (So I am displaying the Value 4 in a Dashboard)
I now would like to display the Names of the Client (Located in Column Name 'Client) so I would see the 4 Clients listed?
Is there a formula that could work this out? Have tried HAS Functions, COUNTM, even INDEX and MATCH but to no avail.
Any help would be appreciated :)
Thanks,
Dan
Best Answer
-
Hi,
I was overthinking this problem, and have solved it, by creating a Report, and displaying this on my Dashboard.
Answers
-
Hi ProductDan,
As per the condition, you can try the below formula to get the name of the clients, where the status is "Red".
=JOIN(COLLECT(Client:Client, [Current Status]:[Current Status], [Current Status]@row), ",")
The formula is applied to the first cell of the Formula column. You can also implement it in a sheet summary as well.
I hope it will work!
Thankyou!
Anjanesh Vaidya
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
-
Hi,
I was overthinking this problem, and have solved it, by creating a Report, and displaying this on my Dashboard.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!