Formula - Line Breaks

Genevieve P.

Hi @Michael Halvey

Multi-select values inherently have a CHAR(10) applied to each of them, which is how that column type identifies when one value ends and when another, separate value starts.

You can use SUBSTITUTE again to replace the CHAR(10) in the multi-select with "" (blank) so that it will appear on the same row. Ex:

"Finish Type: " + SUBSTITUTE([Finish Type]@row, CHAR(10), "") + SUBSTITUTE(Helper#, "-", "")... etc

Let me know if this makes sense and works for you.

Cheers,

Genevieve

Smyles

I noticed this thread addressing similar issue: https://community.smartsheet.com/discussion/comment/341478

Using the CHAR(10) I bypassed helper column and created line breaks for the multiple row cells combined. No JOIN formula needed either.

Example:

="insert label here: " + [Cell1]@row + CHAR(10) + "insert label: " + [Cell2]@row + CHAR(10) + "insert label: " + [Cell3]@row

Sebastian Mindling

https://community.smartsheet.com/discussion/comment/168771#Comment_168771

UNICHAR(10) works (Line feed character).