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

  • AnthroTim
    AnthroTim ✭✭✭✭
    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

  • AnthroTim
    AnthroTim ✭✭✭✭
    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