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

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

  • Gaurav Chauhan
    Gaurav Chauhan ✭✭✭✭✭✭

    Would it on these lines :

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

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!