Transform multiple lines in a single field into separate new lines

Karthik_Karunanithi

Hi, I have a requirement where in multiple lines in a single field has to be transformed to different lines one after the other in the same field.

The below picture would illustrate what is currently and what is expected. Any thoughts that you can share would be much appreciated.

smartsheet possibility.JPG

Kleerfyre

Not that I have ever seen. Its only going to pull in the text the way it is. If you can structure you data to be the way you want it to look in your cell, that may be the only way to do it.

Kleerfyre

You will need to press and hold Alt then hit Enter after each period.

Karthik_Karunanithi

Hi @Kleerfyre , I would like to see if this can be accomplished leveraging any functions in Smartsheet so that I can pull in the expected field in the automated email through the workflow.

Kleerfyre

Not that I have ever seen. Its only going to pull in the text the way it is. If you can structure you data to be the way you want it to look in your cell, that may be the only way to do it.

Karthik_Karunanithi

Thank you, @Kleerfyre .