IF(JOIN(COLLECT())) issues

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:

Find more posts tagged with

Formulas

Accepted answers

All comments

James Keuning

Are you only ever going to have four user stories in the User Stories field? I would parse those into four helper columns, evaluate each column, and then combine the Status for each.

Dakota Haeffner

@James Keuning That's Honestly a great idea but we have upwards of 20 sometimes. I could totally use that as a last resort.

Any suggestions on how I could go about formulating those helper columns?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.