IF(JOIN(COLLECT())) issues

Options

Hello,

I have the below formula working correctly and returning the Rally Status if the User Story field has one User Story in it. Unfortunately, I need it to return all the status separated by a delimiter of ", ". For example, 'US1234567, US1234568, US1234569', I need to return status like, 'In Progress, Closed, Grooming.'

=IF([User Stories]@row = "", "No US#", (JOIN(COLLECT({Rally Status}, {User Stories}, @cell = [User Stories]@row), ", ")))

See the below screenshots:

Sheet where formula is being put (Specifically in the Rally Flow State column:

Sheet where data is being pulled from:


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!