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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!