JOIN COLLECT IF Statement

Gaurav Chauhan

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.

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"), ", ")