Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

New Line (Alt + Enter) in Formulas

Tomasz Giba1

Tomasz Giba1 ✭✭

05/13/16 edited 12/09/19 in Archived 2016 Posts

Hi

I have Formula for text rows:

=Coulmn1 + " " + Column2 + " " + Column3 + ...

Can I set up a space char as a new line (Alt + Enter)?

So every cell will appear in a new line. I need this for Google Docs.

Thanks!

Tags:

Formulas

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

05/13/16

Tomasz,

No

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

It still has my vote for useful enhancement.

Craig

0 · Share on Facebook Share on Twitter
tylermh ✭✭✭✭✭

05/10/19

Any good news on this request 3 years later?

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Formula Help - if cell = X then show network days
I hope my explanation makes sense. I currently have a basic formula that shows "networkdays" between 2 dates, however it obviously shows "invalid date type" when the "end date" has not been entered =NETWORKDAYS([Date Open]@row, [Actual Closure Date]@row) . So we want the cell to show "duration to close" when status is…
Count Duplicates Only if the Field is NOT Blank
I am struggling to get the formula right to solve this problem. My formula can count if there are duplicates in this field, but it also counts it if the field is blank (because many rows won't have a value in this field). Can anyone help me add the "if it is not blank" piece so i only get a 1 if there is a value in the…
auto-resend update (or approval) request after 30 days
I have some automations set up where the work is intensive (or people forget) and update (or approval) requests sit for more than 30 days. The notification center wipes these requests out after 30 days and although they sit in email, people seem more likely to completely forget about these completely. Does anyone know a…