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
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!