Can I use a formula to create a new line at the beginning of a field? CHAR(10) doesn't do it
=" " + CHAR(10) + CHAR(10) + "joes" + CHAR(10) + CHAR(10) + "joe"
does this:
="." + CHAR(10) + CHAR(10) + "joes" + CHAR(10) + CHAR(10) + "joe"
does this:
I need to accomplish this second outcome, without the dot.
The reason is that I have some formulas that combine fields with line breaks in between each field, and the formulas are so long that I need to break them up into multiple fields. If I cannot get the line breaks in the cell, the line spacing in the result breaks.
Answers
-
Hey @James Keuning
Try UNICHAR(8204) as the first character. This is part of the UTF8 character sets. It worked on my test sheet - I had the column text wrapped
=UNICHAR(8204) + CHAR(10) + CHAR(10) + "joes" + CHAR(10) + CHAR(10) + "joe"
Kelly
-
That is an interesting solution, and it looks right in Smartsheet, but when I copy the result that character generates question marks. I am not sure if this is a function of my operating system, so I tried it on Windows and Mac and I get the same results.
=UNICHAR(8204) + CHAR(10) + "joe" + UNICHAR(8204) + UNICHAR(8204) + CHAR(10) + "joe"
-
Interesting. Now I know to also test outside of smartsheet. What if smartsheet shows a character that doesn't appear as text outside smartsheet, ie notepad shows it correctly. Would that work?
Kelly
-
If it doesn't matter what shows in smartsheet but how it appears as text outside of smartsheet, then try CHAR(31), which is a file separator.
Although smartsheet shows a rectangle character, notepad shows the blank.
Kelly
Help Article Resources
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
Check out the Formula Handbook template!