Copy/ Paste Cells With Multiple Lines Doesn't Work
I've been digging through community for resolution to this issue, but I'm coming up empty.
I need to be able to copy/ paste multiple rows of data that have "multi-row (alt+enter)" information from Excel (and Smartsheet). Currently, when I try to copy and paste these "multi-row" cells, they spill into separate cells instead of staying together. It DOES work if I do them one at a time, but I have hundreds of rows of data - it's not a feasible solution to do it one at a time.
Is there a trick to being able to copy multiple rows and not have all of the information spill onto another separate row instead of the same cell? I've been using VLOOKUPs between Smartsheets to perform this task, but it is pretty painful.
Anyone have any tips??
Comments
-
Andrée Starå ✭✭✭✭✭✭Hi NikkiAke,
I'd recommend trying to import the excel sheet and then moving/copying the rows to the sheet instead.
Would that work?
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
NikkiAke ✭
Thanks for the suggestion. I have tried this and it is very hit or miss.
-
Andrée Starå ✭✭✭✭✭✭
What's not working?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
NikkiAke ✭
It spills over the text into multiple cells instead of keeping it in one.
-
Andrée Starå ✭✭✭✭✭✭
好的。
This is probably why.
TIP: If you've copied a multi-line cell in Excel or other program, double-click on the cell in Smartsheet before pasting it in to prevent the lines from spilling over into the cells below.
More info:https://help.smartsheet.com/articles/518318-tips-for-using-copy-and-paste
Hope that helps!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
I have this same issue, although this solution works for copying single cells, it is not sustainable for copying multiple excel columns.
-
I have the same issues than above and for some reason it was not happening before and suddenly it started. In my case I first export from a Smart-sheet into excel format in order to format the data to my liking, then i paste it into a smart sheet template or data source linked to multiple other sheets/graphs/metrics and reports which are actually feeding several different Smart-sheet Dashboards. This data source i update it manually by copy pasting the information in . Problem is that I have one column with Comments (it is the last one to the very right), which is a multi line cell. When before pasting the updated data source was fine, even though it has always been multi line, now all of the sudden data from comments column cell is split into multiple lines invading the rows below. I have multiple links to that data source smart sheet therefore it is a problem. Also trying different workaround, if I individually copy that column in, Comments remain in the same cell, but when copied as a full sheet it does not...I am getting very frustrated with smartsheet as I think something as simple as copy pasting information should be much simpler...
-
@David Sanchez CapdevilaDid you find a workaround?
I found that uploading from Excel back into smartsheet, instead of copying from Excel and pasting into smartsheet, allowed the multi-line cells to come into Smartsheet with cell content intact, without invading the rows below.
howev,这并没有完全解决我的问题er.
线突破仍然发生ed when copying from the temporary upload sheet to the sheet where I need it.
To get these new verbose cells where I wanted, I had to do a vlookup, which then makes that cell uneditable in the destination sheet, and complicates things a bit.
I may play around with using linked cells, I just wanted to see if you came up with a workaround. Let me know what you know!
-
My upload sheet was not copy-pasting properly either so I was able to make it work this way:
-Upload new data from excel in the same format as master sheet
-In the master sheet, under your existing data, right click and choose "Link from cell in other sheet" and select the whole column in the upload sheet. All of the cells in the column will now be linked over into new rows on the master sheet.
-Do the same for each column in the upload sheet (*you can select multiple columns but the max number of links you can create at one time is 500 so I had to do this column by column*)
-Once all linked and looking good, select all and right click, and choose "remove link". The links convert to plain text.
-
HBL ✭I have found a work around after looking for some time to this issue.
When Pasting into smartsheets it will take Cells in Excel that have line breaks where a cell has multiple lines split it to the cell underneath in smartsheets.
In excel before copying you need to replace all the linebreaks doing Control+H and in the find input press "Control+J" and replace with either " , " (Comma) or a " " (Blank Space).
Then when you paste the whole dataset into Smartsheets, it will not split the cell from Excel into two cells.
Smartsheet Technicians, please resolve this so we do not need to remember a work around please....
-
Hila ✭Additional solution using Excel formulas:
- Find the line brake using the Excel formula:
=FIND(CHAR(10),A2)
- Replace the line brake character with comma using the Excel formula:
=SUBSTITUTE(A2,CHAR(10),",")
Then when you paste the whole text into Smartsheet, it will not split the cell from Excel into two cell.
Categories
Hi,<\/p>
I hope you're well and safe!<\/p>
Unfortunately, as far as I know, it's not possible now (if you mean that the Query should be included in the URL to Dashboard, it's only possible in the URL to the form), but it's an excellent idea!<\/p>
Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p> How would you like to use it? What's the use case?<\/p> I hope that helps!<\/p> Be safe, and have a fantastic weekend!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":530,"urlcode":"url","name":"URL"}]},{"discussionID":108886,"type":"question","name":"Why does a user show an email address?","excerpt":"When I'm adding users to Assigned, it usually shows the First Name Last Name, but sometimes it just shows the email address. How do I fix this? See screenshot example.","snippet":"When I'm adding users to Assigned, it usually shows the First Name Last Name, but sometimes it just shows the email address. How do I fix this? See screenshot example.","categoryID":321,"dateInserted":"2023-08-12T18:59:03+00:00","dateUpdated":null,"dateLastComment":"2023-08-12T20:33:33+00:00","insertUserID":128842,"insertUser":{"userID":128842,"name":"Karen Bruer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Bruer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5MPAuTrWZX4!elHDp9qhGX4!HMSKFvshvfI","dateLastActive":"2023-08-13T15:19:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":161632,"lastUser":{"userID":161632,"name":"SteyJ","title":"Jacob Stey","url":"https:\/\/community.smartsheet.com\/profile\/SteyJ","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5Zjq-V_rc4o!zmkrczO71bo!6kwXWfi9FUH","dateLastActive":"2023-08-13T22:08:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3383739756,"url":"https:\/\/community.smartsheet.com\/discussion\/108886\/why-does-a-user-show-an-email-address","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108886\/why-does-a-user-show-an-email-address","format":"Rich","lastPost":{"discussionID":108886,"commentID":390375,"name":"Re: Why does a user show an email address?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390375#Comment_390375","dateInserted":"2023-08-12T20:33:33+00:00","insertUserID":161632,"insertUser":{"userID":161632,"name":"SteyJ","title":"Jacob Stey","url":"https:\/\/community.smartsheet.com\/profile\/SteyJ","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5Zjq-V_rc4o!zmkrczO71bo!6kwXWfi9FUH","dateLastActive":"2023-08-13T22:08:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/I85D28MOQEGC\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-13T15:20:11+00:00","dateAnswered":"2023-08-12T20:33:33+00:00","acceptedAnswers":[{"commentID":390375,"body":"
