Use Enter/Return and Concatenate for joining fields
Dear Smartsheet Community,
Do you know how to add a "Enter/Return" into the concatenate formula?
=[Column1]1 +"[return/enter]"+ [Column2]2 + ": "+ "[return/enter]" + [Column3]3 + ": "+ [Column4]4
= "Hi Team," + "[return/enter]" + "Below is the status for the task" + ": "+ "[return/enter]" + "Name of the person"+": "+ "Vineet"
to display
Hi Team,
Below is the status for the task:
Name of the Person: Vineet
Best Answer
-
Hey @Vineet
I think you are referring to a line break. The code CHAR(10) corresponds to a line break. When using these codes in a formula, they are not enclosed in quotes. Find more characters at this link here
Using your example -
=[Column1]1 +CHAR(10)+ [Column2]2 + ": "+ CHAR(10) + [Column3]3 + ": "+ [Column4]4+ " I inserted this just to demonstrate you can mix column fields, codes, and text strings"
Will this work for you?
Kelly
Answers
-
Hey @Vineet
I think you are referring to a line break. The code CHAR(10) corresponds to a line break. When using these codes in a formula, they are not enclosed in quotes. Find more characters at this link here
Using your example -
=[Column1]1 +CHAR(10)+ [Column2]2 + ": "+ CHAR(10) + [Column3]3 + ": "+ [Column4]4+ " I inserted this just to demonstrate you can mix column fields, codes, and text strings"
Will this work for you?
Kelly
-
Thank you Kelly for answering the Question. Yes, it is working for me. Thank you so much !!!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives