Is it possible to add a new line in a Formula?

BarneeL

I found this discussion from 3 years ago:

https://community.smartsheet.com/discussion/adding-carriage-returnline-feed-calculated-text

 

It got a response from the community manager, so I would like to assume 3 years later it was implemented at some point 

 

Is there a way I can do this?

Andrée Starå

Hi Barnee,

Yes, it is! I'll get back to the post with a link to another post.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Here's one post.

https://community.smartsheet.com/comment/140236?utm_source=comm-notification&utm_medium=email#comment-140236

Hope that helps!

Best,

Andrée

BarneeL

Brilliant - a bit overkill - but it works so no complaints here!! Thank you

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée

PeggyLang

@Andrée Starå adding carriage return?

Exactly what I need, but not working for me. If I understand this correctly I create a column and in the first row I enter "- (Enter) -"

When I actually press the 'Enter' key I am taken down to the next line.

Clearly I'm doing something wrong?