Join Collect with collecting data from Multiple cells

Hi,

I have six "issue" columns and six "resolved" columns. I'm trying to collect all the Issue columns into a final column. I'm using the following formula but I'm getting #INCORRECT ARGUMENT SET

=JOIN(COLLECT([Issue I]@row, [Resolved I]@row, 0, [Issue II]@row, [Resolved II]@row, 0, [Issue III]@row, [Resolved III]@row, 0, [Issue IV]@row, [Resolved IV]@row, 0, [Issue V]@row, [Resolved V]@row, 0, [Issue VI]@row, [Resolved VI]@row, 0), CHAR(10))

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Rivky Emert

The COLLECT function will only bring data back from the very first range specified, based on the criteria listed after it.

It looks like you want to bring all the Issue's into one cell, but only if the associated Resolved column is blank (or not checked), is that correct? If so, I would actually use multiple IF statements added together, versus JOIN(COLLECT.

Ex: =IF([Resolved I]@row = 0, [Issue I]@row, "")

Try something like this:

=IF([Resolved I]@row = 0, [Issue I]@row, "") + IF([Resolved II]@row = 0, CHAR(10) + [Issue II]@row, "") + IF([Resolved III]@row = 0, CHAR(10) + [Issue III]@row, "") + IF([Resolved IV]@row = 0, CHAR(10) + [Issue IV]@row) + IF([Resolved V]@row = 0, CHAR(10) + [Issue V]@row, "") + IF([Resolved VI]@row = 0, CHAR(10) + [Issue VI]@row, "")

Let me know if this works for you!

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Rivky Emert

The COLLECT function will only bring data back from the very first range specified, based on the criteria listed after it.

Ex: =IF([Resolved I]@row = 0, [Issue I]@row, "")

Try something like this:

Let me know if this works for you!

Cheers,

Genevieve

Automations 1

Yes, that works! thanks.

Genevieve P.

Great! I'm glad I could help.

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.