Return results from multiple values- JOIN COLLECT HAS

I need to return data from column5 separated by comma if a record appears in column6 which is a drop down list that can have multiple values per cell.

This is the formular that works only when there is one value in the cell..

=JOIN(COLLECT([Column5]:[Column5], [Column6]:[Column6], "2"), ", ")

This formular gives me INCORRCET ARGUMENT SET =JOIN(COLLECT([Column5]:[Column5], [Column6]:[Column6], HAS([Column6]:[Column6], "2"), ","))

I want results to be "Test, this, should, works, truly"

Find more posts tagged with

Accepted answers

Adam Murphy

Hi Ann,

You are very close, give this a try: =JOIN(COLLECT([Column5]:[Column5], [Column6]:[Column6], HAS(@cell, "2" )), ",")

Hope this helps!

All comments

Adam Murphy

Hi Ann,

You are very close, give this a try: =JOIN(COLLECT([Column5]:[Column5], [Column6]:[Column6], HAS(@cell, "2" )), ",")

Hope this helps!

Ann M

Thanks Adam, that works beautifully!

I would like to understand why @cell works rather than the column?

Adam Murphy

Hi Ann, you need the @cell because you are trying to evaluate each individual cell within the column, not the column all at once.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.