Formulae help

Gaurav Chauhan · 05/26/22

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

Genevieve P. · 05/27/22

Hi @Gaurav Chauhan

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

Gaurav Chauhan · 05/26/22

Would it on these lines :

=JOIN(COLLECT({Client Name}, {Status}, HAS([Project Status]@row), ", "))

Genevieve P. · 05/27/22

Hi @Gaurav Chauhan

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

Formulae help

Best Answer

Answers

Help Article Resources

Categories