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å ✭✭✭✭✭✭
Ok.
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.
This didn't completely solve my problem, however.
线突破仍然发生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
This method does produce separate reports:<\/p>
The Project Plan report will include this filter: \"Sheet Type\" is one of \"Project Plan\" -- this filter will exclude rows coming from the RAID Log (and all other types of sheets) because those other sheets will have a value in their \"Sheet Type\" column that is not \"Project Plan.\" <\/p>
The RAID Log report will include this filter: \"Sheet Type\" is one of \"RAID Log\" -- this filter will exclude rows coming from the Project Plan (and all other types of sheets) because those other sheets will have a value in their \"Sheet Type\" column that is not \"RAID Log.\" <\/p>
Thus, each report will include a filter rule specifying that only rows with its own sheet type can be included.<\/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":265,"urlcode":"Reports","name":"Reports"}]},{"discussionID":108417,"type":"question","name":"How do i set up a conditional format, when i want more than one person in the assigned to column","excerpt":"I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?","snippet":"I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that…","categoryID":321,"dateInserted":"2023-08-02T14:26:40+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T15:27:36+00:00","insertUserID":159629,"insertUser":{"userID":159629,"name":"Genesia","url":"https:\/\/community.smartsheet.com\/profile\/Genesia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T20:20:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":159629,"lastUser":{"userID":159629,"name":"Genesia","url":"https:\/\/community.smartsheet.com\/profile\/Genesia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T20:20:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3381977656,"url":"https:\/\/community.smartsheet.com\/discussion\/108417\/how-do-i-set-up-a-conditional-format-when-i-want-more-than-one-person-in-the-assigned-to-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108417\/how-do-i-set-up-a-conditional-format-when-i-want-more-than-one-person-in-the-assigned-to-column","format":"Rich","tagIDs":[245,254,334,437],"lastPost":{"discussionID":108417,"commentID":388509,"name":"Re: How do i set up a conditional format, when i want more than one person in the assigned to column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388509#Comment_388509","dateInserted":"2023-08-02T15:27:36+00:00","insertUserID":159629,"insertUser":{"userID":159629,"name":"Genesia","url":"https:\/\/community.smartsheet.com\/profile\/Genesia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T20:20:14+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\/9VLKF1G9AO1Q\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-03T09:17:11+00:00","dateAnswered":"2023-08-02T14:42:44+00:00","acceptedAnswers":[{"commentID":388483,"body":"
