Return a list of cell values if one criteria is met

KarineMul22_TPg

Hello,

I would like to return a list of Project IDs (four digits) that meet the same criteria , so I went for :

=JOIN(COLLECT({Project Summary MASTER Range Project}, {Project Summary MASTER Range Time}, "Yellow"))

Unfortunately, it comes back as an 8/16/20 etc digit long without any separation - is there either

1) an other function I could use

2) An additional function to separate the joined data in another cell?

Thank you

Find more posts tagged with

Accepted answers

Paul Newcome

Yes. You would use the second portion of the JOIN function.

=JOIN(COLLECT(..........), "delimiter of choice")

All comments

Paul Newcome

Yes. You would use the second portion of the JOIN function.

=JOIN(COLLECT(..........), "delimiter of choice")

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.