Concatenate including a "return/entder"
Answers
-
Hi Baris,
Try this.
Add a helper (text/number) column named JoinName or similar with the formula below:
=JOIN([Column1]@row:[Column2]@row; " ")
The same version but with the below changes for your and others convenience.
=JOIN([Column1]@row:[Column2]@row, " ")
Add another helper (text/number) column called Enter/Return or similar and add the following to the first cell in the column. Add a hyphen, carriage return (CMD+Enter on Mac) and a hyphen
Should look something like - - and like below if you have Wrap active.
-
-
Add the below formula to the cell where you want the text to be displayed:
=JOIN(JoinName@row:[Column3]@row; SUBSTITUTE([Enter/Return]$1; "-"; ""))
The same version but with the below changes for your and others convenience.
=JOIN(JoinName@row:[Column3]@row, SUBSTITUTE([Enter/Return]$1, "-", ""))
The result should be something like:
John Smith
35
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andrée,
Thanks you very much, so simple but efficient
Much appreciated,
Baris
-
I'm always happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This is a great solution.
Another one:
You can use CHAR(10) add a line break within a formula.
="Apples" + CHAR(10) + "Oranges"
However, neither solution works with update requests. We add an opening paragraph outlining the reason for the update request, and reference columns in the Smartsheet. (This is good, as it can't be edited by the recipient) However, the lack of word wrap in these emails makes them look atrocious. WORK AROUND: We add a new column for each paragraph in the opening letter, and include all columns. Not pretty, but it works.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives