Join Connect

Karrie Davis

Hi,

I have a Join/Connect formula that works however I would like each name to be separated by a line break is there a way to do that.

=JOIN(COLLECT({COVID-19 Time Timekeeper}, {COVID-19 Time Timekeeper Matter Number}, @cell = [Client Matters]1), ",")

Andrée Starå

Hi Kari,

Yes, there is. You can replace the delimiter with the CHAR(10) function.

https://help.smartsheet.com/function/char

Did that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Kari,

Yes, there is. You can replace the delimiter with the CHAR(10) function.

https://help.smartsheet.com/function/char

Did that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Karrie Davis

That worked,

Thank you Andree

Andrée Starå

Excellent!

Happy to help!