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
Hello! I am attempting to create a dashboard widget that shows me how much budget we are spending in each segment, and in what category. The source sheet contains these columns… "Budget" - text/number column "Category" - dropdown list (restricted to list values only) "Segment" - dropdown list (allows multiple values per…
How can I change the value in one row based off of information in that row and information in a predicessor row
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
