Join(collect statement

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å
    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, [email protected])

    I hope that helps!

    Be safe and have a fantastic week!


    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!


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

    W: | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Leibel S
    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)

  • Alex Argumedo
    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])


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!