Formulae help
Hi Team,
Can you please suggest on how do I write a formulae that can capture the All Client names separated by "," which are against Red status.
The caveat is that the status can get updated periodically and hence today there may be only 2 client against red and tmrw there may be more or less.
Can you help
Best Answer
-
Yes! The formula would be similar to what you have above. However it looks like the Status column is single select, so you can simply reference the "status" column as your criteria instead of using HAS.
For example:
=JOIN(COLLECT({Client Name}, {Status}, [Project Status]@row), ", ")
Let me know if this works for you or if you would like to see screen captures.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Would it on these lines :
=JOIN(COLLECT({Client Name}, {Status}, HAS([Project Status]@row), ", "))
-
Yes! The formula would be similar to what you have above. However it looks like the Status column is single select, so you can simply reference the "status" column as your criteria instead of using HAS.
For example:
=JOIN(COLLECT({Client Name}, {Status}, [Project Status]@row), ", ")
Let me know if this works for you or if you would like to see screen captures.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!