CHAR(10) not adding internal break

Hi,

There's probably a simple answer but when I use CHAR(10) in a cell formula in a form, it results in a space (probably a non printable character) instead of a break.

The formula I am using is:

=JOIN(COLLECT(Column1:Column1, Column2:Column2, "Responsible"), CHAR(10))

Even if I use:

="Apples" + CHAR(10) + "Oranges"

I just get "Apples Oranges" with no line return.

I'm using a Mac and Chrome.

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @stockdam

I hope you're well and safe!

Ensure that you've activated the Wrap feature.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bruno Menezes

Hi Andrée, I'm having the same issue as @stockdam even with the wrap feature activated on the column.

It was working properly just a few days ago, but now it's not breaking the line within the cell anymore. ☹️

I'm using this formula (similar in the Vessel ETA column):

=JOIN(COLLECT({Logistics Tracker | Vessel ETD}, {Logistics Tracker | PO Line ID}, [PO Line ID - Assembly BOM]@row)) + CHAR(10) + JOIN(COLLECT({Logistics Tracker | Vessel ETD}, {Logistics Tracker | PO Line ID}, [PO Line ID - O&M BOM]@row)) + CHAR(10) + JOIN(COLLECT({Logistics Tracker | Vessel ETD}, {Logistics Tracker | PO Line ID}, [PO Line ID - Deployment BOM]@row)) + CHAR(10)

And this is how it's showing in the cell.

IPC

Dear @Andrée Starå ,

Good evening. I'm having the same problem and I saw this discussion. However, i can see in the discussion that the formula didn't resolve their issue. Same thing for me.

Here's the formula: =JOIN(COLLECT(Names:Names, RACI:RACI, "Responsible"), CHAR(10))

And below is the result:

WRAP option is enabled:

Here's how it looks like when WRAP is not enabled:

Please advise.

Thanks in advance.

IPC

KLZolali

@IPC Don't forget to put a + in front of your CHAR(10), and it looks like you also need to add a delimiter to tell Smartsheet how to separate your data - try something like this:

=JOIN(COLLECT(Names:Names, RACI:RACI, "Responsible"), ", " + CHAR(10))

KLZolali

@Bruno Menezes It looks like you might be having a similar issue to IPC. Make sure you put a delimiter in for your Join/Collect and also include your + CHAR(10) inside of the parenthesis:

=JOIN(COLLECT({Logistics Tracker | Vessel ETD}, {Logistics Tracker | PO Line ID}, [PO Line ID - Assembly BOM]@row), ", " + CHAR(10)) + JOIN(COLLECT({Logistics Tracker | Vessel ETD}, {Logistics Tracker | PO Line ID}, [PO Line ID - O&M BOM]@row), ", " + CHAR(10)) + JOIN(COLLECT({Logistics Tracker | Vessel ETD}, {Logistics Tracker | PO Line ID}, [PO Line ID - Deployment BOM]@row),", " + CHAR(10))

IPC

Yes @Bruno Menezes. @KLZolali advise worked on my sheet. Thanks to you @KLZolali

Andrée Starå

@IPC

I missed you tagging me.

I saw that it had been answered already!

Let me know if I can help with anything else!

Best,

Andrée

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

IPC

No worries @Andrée Starå I got it working through @KLZolali. Thanks a lot

CAS the CSA

I'm still having a similar but different issue…

char(10) is adding two returns and " " is adding a char(10) instead of a space

this used to work when we started using SS, now it's losing functionality.

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.