Automating Line Breaks In A Column
Hello,
I currently have a list of Material Numbers that get auto-populated every morning from another application. The problem is, when they populate, they look like this:
When I need them to look like this:
I know you can create line breaks manually, but with the sheer size of the information we get each day, it isn't practical (that, and any manual line breaks revert back to a single line with each new auto-populate).
Is there any way to automate this particular column so that each morning when the Smartsheet auto-updates, the numbers in that column look like my second screenshot?
Best Answer
-
Hi,
The best solution is for the importing app to add the line breaks ;-)
However, you could solve this by using two columns. The first column would contain the 'raw' imported data (and could be hidden). The second would contain the formatted data.
In the second column (formatted) you'd have a formula like this:
=SUBSTITUTE([RawDataColumn]@row, " ", CHAR(10))
This replaces the spaces with line breaks and so displays as you wish.
Tim
Answers
-
Hi,
The best solution is for the importing app to add the line breaks ;-)
However, you could solve this by using two columns. The first column would contain the 'raw' imported data (and could be hidden). The second would contain the formatted data.
In the second column (formatted) you'd have a formula like this:
=SUBSTITUTE([RawDataColumn]@row, " ", CHAR(10))
This replaces the spaces with line breaks and so displays as you wish.
Tim
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives