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
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives