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
Hi all - i am building a monthly dashboard with separate columns for each month's status, key takeaways, and next steps. I am wanting to build an automation that says for example: 'your {{current month}} status update is due, your last {{last month}} update was {{status color}}. Please be sure to indicate your key…
Hello, I have been using an Index match formula, however it doesn't always pull back the correct match or provides a no match however when validating the data, it is there. Is there a better formula to use? Here is what my current formula is in the cell: =INDEX(reference sheet column),MATCH(@row in sheet,(reference sheet…
I have a summary sheet that the formulas look fine on, and were working well, but, after the first of the year, the fields are showing up as either invalid operation or blocked. What would cause this? Below is what is showing when I try to pull the sheet summary to use for the widget. This is what I am seeing in the actual…
