Issue on Multi-Line Form

JLE

Hello,

When I define a multi-line field on a form, it works fine on the grid with Characters

a

b

c

d

 

But when I enter numbers, they stay on 1 line

1

2

3

=> 123

Did you notice this point on your sheets ?

Andrée Starå

Hi,

It will work if you write it as below with a punctuation.

1.

2.

3.

Would that work for you?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

JLE

Hi , yes I've seen that but il's not the way I want tu use it

Thank you

 

Andrée Starå

Happy to help!

Would it work if you have separate fields for 1,2,3 and then combine the information in the sheet to show it as you want?

Best,

Andrée

J. Craig Williams

This is a bug. Please report it to support@smartsheet.com

It is a bug because 

1

2

3

are entered as 123 (ie adding 1 will be 124)

 

Here's another possible work-around

Instead of entering the numbers 

1

2

3

First enter text

a

1

2

3

This will preserve the numbers as unique. Basically what you are doing is forcing Smartsheet to acknowledge you are entering text and not numbers.

The benefit is that Find & Replace the "a" will keep the list nature of 

1

2

3

If there are LOTS of these, I'd suggest have a special character or key word <>, replace-me, work-around, whatever, that won't have false positives when doing the find a replace on the whole sheet or column.

I hope this helps

Craig

JLE

Hello

Thank you for the answers

I've just open a ticket because sure it's probablly a bug ! 

Regards

Andrée Starå

Happy to help!