JOIN COLLECT IF Statement

Gaurav Chauhan
Gaurav Chauhan ✭✭✭✭✭✭
edited 01/24/24 in Formulas and Functions

Hello Team,

I have the below formuale which works just fine. However, I need to add a condition to this wherein it only picks those 'Program Status' which are 'Active'

How do I add the IF Statement to the current string.

=JOIN(COLLECT({Program Name}, {Project Health}, [Red Status]1), ", ")

Thanks.

Answers

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭

    The below should work just added an additional criteria range and criteria to the collect formula. You will have to create the cross reference for the Program status.

    =JOIN(COLLECT({Program Name}, {Project Health}, [Red Status]1,{Program Status},"Active"), ", ")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!