Does anybody know if this post from 3 years ago has been addressed?
https://community.smartsheet.com/discussion/new-line-alt-enter-formulas
I'm looking to concatenate cells with line breaks. Thanks!
New:- give this one a try
Use CHAR(10) to enter a line break in your formula when joining text (make sure word wrap is enabled).
=JOIN([Address1]1:[City, State, Zip]1, CHAR(10))
Hi Kara,
Thanks!
Excellent news! This function will make it so much easier to create line breaks.
Best,
Andrée
This is great. I'm going to be playing with this to see if I can find some other ways to take advantage of it.
Can't seem to delete this request, so disregard my comments
CTRL+Enter does work. The above formulas and eventually the CHAR(10) function allow it to be used in a formula as a delimiter. If manually entering data though, CTRL+Enter does in fact work.
CRTL+Enter doesn't work for me. I wish it were simple like Excel's Alt+Enter. I don't want to have to fuss with a complicated formula to make a list within a cell. I also don't want to have to type out all the lines and then join them into another cell. That takes way too much time and effort when a couple of key strokes will do.
It should work.
Where are you trying to use it? Which kind of column?
I am trying to do the reverse from what is being discussed here: Substitute line break with something that can be understandable on a query to url process. Can someone help?
Hi @Margarita Takou
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Strange - I can get the substitute portion of the equation to work alone in a column, but I'm getting a syntax error in the following context,
=IF(NOT(ISBLANK([Training Credits to be Issued]@row)), "Training SKU Fulfillment ID: " + [Row ID]@row + SUBSTITUTE(LineBreakHelper$1 , "-", "") + "Opportunity: " + [Opportunity ID]@row, "")
Ah nevermind - I was able to get it to work with the new CHAR(10) option. (just needed to read further down the thread!)
CTRL+ALT and CTRL+ Enter only work for me if the cell is active.
ACTIVE
VS. INACTIVE
Any ideas on how I can get it to persist?
Hi @Heather Hutchens
You’ll have to enable the Wrap feature from the menubar.
Did that work?
Kara,
Thanks for putting this in the thread, you just help future me 2 years ago 😆... I used UNICHAR(10) for windows today.... again, thank you for the knowledge sharing.
Hello! I am working on a similar idea to everyone's post here. Taking multiple cells in a row and joining them together but wanted each cell information to be on a new line. I have completed the formula using the first method of the Helper column (in sheet summary) using this cell idea:
My only hiccup I have is with columns that use Multi-Select Dropdowns, the above method will move my cell data down an additional row. See Metal Type: and Finish Type: - their respected cell data sits below since they are Multi-Select Dropdowns. I switched them to Single Select, and then the cell data moves back up to the top, next to each descriptive words. Does anyone have a potential workaround for Multi-Select Dropdowns in this instants?
I did try using the CHAR(10) method and seems to be similar issue as well.
Thank you for your help,
Michael
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…
Hi. I am working on a (roughly) annual document review system, in partnership with another team in my organization. They have requested that they receive one document to review per week. But there are more documents to review than there are weeks in the year. So I need to figure out a method for ensuring that I don't send…
Hi team i have 2 sheets for material inventory. the first is to record witch equipment is ship out for repair and the other is the total of equipment available. the first is set as follow: equipment type, date out, date return, quantity (negative number) the other one is as follow: each row is for a single date with the…
