Formula - Line Breaks
Comments
-
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
-
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
-
UNICHAR(10) works (Line feed character).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!