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

Find more posts tagged with

Accepted answers

Kelly Moore

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

All comments

Kelly Moore

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

Vineet

Thank you Kelly for answering the Question. Yes, it is working for me. Thank you so much !!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.