Cell with leading whitespace

Options
Joe Varghese
Joe Varghese ✭✭✭
edited 12/09/19 in Smartsheet Basics

An unorthodox question but posting as I'm sure our company is not the only one who sometimes uses Excel as a Word document ...

We have an Excel document that we are importing to Smartsheet, and Excel allows the use of leading white-spaces in the cell so that overall the document reads better e.g.,

Row 1: Title 1

Row 2:      - Text under Title 1 (with leading spaces) 

Row 3:      - Text under Title 1 (with leading spaces)

Row 4: Title 2

Row 5:      - Text under Title 2 (with leading spaces)

Row 6:      - Text under Title 2 (with leading spaces)

 

I cannot find any way to mimic this in Smartsheet .. tried indenting, but that only changes the indent of the text in the primary column

Comments

  • bdchapin
    Options

    I see what you are saying, Smartsheet seems to strip off the leading whitespace. 



    I assume that you are NOT talking about making sub-tasks, as that is as simple as clicking the 'indent' button.



    If you want to visually indent without making a sub-task, then you'll probably have to put another character in there to force SS to keep the whitespace. For example you could use a period.



    Task 1

    .      Task 2

    .      Task 3

    Task 4

    .     Task 5

    However, i just tested it, and even with that it only keeps a couple of spaces.