Sign in to join the conversation:
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
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
