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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives