Join(collect statement

Jared Meyer

I'm looking to join text from several columns with each section of text separated by a carriage return and blank cells skipped. Based on the article below I wrote the following which is unparseable

=JOIN(COLLECT([Join Open-Ended Rating]:[Join Comments7]:[Comments5 Column], ISTEXT(@cell)), CHAR(10))

I can't figure out where it is going wrong - the number of columns or syntax.

Andrée Starå

Hi @Jared Meyer

I hope you're well and safe!

Not sure I follow.

Which columns do you want to JOIN?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Leibel S

@Jared Meyer

In order for your setup to work all the columns would need o be grouped together on your sheet.

Then they syntax would be the below formula.

=JOIN(COLLECT([Join Open-Ended Rating]@row:[Join Comments7]@row,[Join Open-Ended Rating]@row:[Join Comments7]@row,@cell <> ""), CHAR(10))

Replace the bolded text above with your correct group of columns starting with the first column you want to combine, through the last column you want to combine ([first column]@row:[last column]@row)

Jared Meyer

Thank you!

Alex Argumedo

evaluating the formula, is missing the last piece of information, the delimiter, I added the location to your formula that might help you to complete it:

=JOIN(COLLECT([Join Open-Ended Rating]:[Join Comments7]:[Comments5 Column], ISTEXT(@cell)), CHAR(10),[insert delimiter here])

Regards