Importing and Exporting

Import>Import from Microsoft Excel, I can pull the data in, but when I leave the sheet, everything is gone. When I import the data, I follow all the usual import steps, but the Save option is grayed…","categoryID":321,"dateInserted":"2023-06-30T15:23:02+00:00","dateUpdated":null,"dateLastComment":"2023-07-03T09:00:56+00:00","insertUserID":77921,"insertUser":{"userID":77921,"name":"jmhoward","url":"https:\/\/community.smartsheet.com\/profile\/jmhoward","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xU9A8UKpKHo!cwnNZ9z4_z4!QusToJoSh3T","dateLastActive":"2023-06-30T15:23:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-04T15:53:46+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":20,"score":null,"hot":3376515238,"url":"https:\/\/community.smartsheet.com\/discussion\/107141\/importing-from-excel-works-one-way-but-not-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107141\/importing-from-excel-works-one-way-but-not-another","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-30T15:44:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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}]},{"discussionID":107150,"type":"question","name":"Can you Log a Cell In time?","excerpt":"Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track\/Log this cell as it changes so that I can create a line graph to see our patterns over time?","categoryID":321,"dateInserted":"2023-06-30T19:11:19+00:00","dateUpdated":"2023-06-30T19:34:11+00:00","dateLastComment":"2023-06-30T23:02:11+00:00","insertUserID":163061,"insertUser":{"userID":163061,"name":"Jay T","title":"Development Manager","url":"https:\/\/community.smartsheet.com\/profile\/Jay%20T","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T19:33:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163061,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-04T19:15:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":null,"hot":3376319010,"url":"https:\/\/community.smartsheet.com\/discussion\/107150\/can-you-log-a-cell-in-time","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107150\/can-you-log-a-cell-in-time","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/G0ASTE3DB5VL\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-30T23:02:11+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]},{"discussionID":106911,"type":"question","name":"Importing \/ Adding Many Columns into Multiple Sheets","excerpt":"I have 1 sheet (and an Excel sheet) that has 29 columns that I need to add to multiple sheets (6); those columns are completely blank (at the moment). Any way I can quickly \"import\" them into my existing sheets without creating those columns into each sheet? HELP!","categoryID":321,"dateInserted":"2023-06-26T18:07:10+00:00","dateUpdated":null,"dateLastComment":"2023-06-26T20:06:18+00:00","insertUserID":9250,"insertUser":{"userID":9250,"name":"Susan Swisher","url":"https:\/\/community.smartsheet.com\/profile\/Susan%20Swisher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T17:20:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-04T19:15:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":28,"score":null,"hot":3375614608,"url":"https:\/\/community.smartsheet.com\/discussion\/106911\/importing-adding-many-columns-into-multiple-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106911\/importing-adding-many-columns-into-multiple-sheets","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T08:50:48+00:00","dateAnswered":"2023-06-26T19:50:56+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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}]},{"discussionID":106718,"type":"discussion","name":"Smartsheet Revenue & SAP","excerpt":"Hello Smartsheet Community, We are using Smartsheet to forecast revenue. We export recognized revenue monthly and import into SAP for offical reporting. We'd ideally like to be able to set up a connector to eliminate the manual intermediate steps. Is anyone doing something similar in their solution who would be willing to…","categoryID":346,"dateInserted":"2023-06-21T17:58:50+00:00","dateUpdated":"2023-06-23T16:05:21+00:00","dateLastComment":"2023-06-23T16:05:09+00:00","insertUserID":150041,"insertUser":{"userID":150041,"name":"jessica.smith","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jessica.smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/Y75KF3COBE7Q\/nNRXKUZ0LFQD3.jpg","dateLastActive":"2023-06-30T17:48:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":150041,"lastUser":{"userID":150041,"name":"jessica.smith","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jessica.smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/Y75KF3COBE7Q\/nNRXKUZ0LFQD3.jpg","dateLastActive":"2023-06-30T17:48:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":38,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/106718\/smartsheet-revenue-sap","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106718\/smartsheet-revenue-sap","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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}]},{"discussionID":106767,"type":"idea","name":"File Upload to Resource Management - projects","excerpt":"In RM, I need to be able to upload a PDF or Word document to Projects to track SOWs against the project. It would be helpful to be able to load directly to the project.","categoryID":349,"dateInserted":"2023-06-22T13:45:53+00:00","dateUpdated":"2023-06-22T13:52:26+00:00","dateLastComment":"2023-06-22T13:45:53+00:00","insertUserID":162632,"insertUser":{"userID":162632,"name":"Cjudd_HRC01","title":"Director of Delivery","url":"https:\/\/community.smartsheet.com\/profile\/Cjudd_HRC01","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cxnYpxhA_zw!-2Pad7woHb4!96Ugs2BbqwL","dateLastActive":"2023-06-22T13:53:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162632,"lastUserID":162632,"lastUser":{"userID":162632,"name":"Cjudd_HRC01","title":"Director of Delivery","url":"https:\/\/community.smartsheet.com\/profile\/Cjudd_HRC01","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cxnYpxhA_zw!-2Pad7woHb4!96Ugs2BbqwL","dateLastActive":"2023-06-22T13:53:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":16,"score":1,"hot":1687441853,"url":"https:\/\/community.smartsheet.com\/discussion\/106767\/file-upload-to-resource-management-projects","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106767\/file-upload-to-resource-management-projects","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":21191,"type":"discussion","name":"Creating price tickets","excerpt":"Would be grateful for any guidance please. I'm looking for a way of producing sheets of price labels including a barcode that would be generated from a smartsheet. I can get all the relevant data into one smartsheet however I have been struggling to come up with a way of creating a PDF that would contain the price label…","categoryID":320,"dateInserted":"2018-03-10T05:24:48+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-06-22T09:07:40+00:00","insertUserID":1201,"insertUser":{"userID":1201,"name":"mikelondon","url":"https:\/\/community.smartsheet.com\/profile\/mikelondon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-03-17T11:45:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":117294,"lastUser":{"userID":117294,"name":"SueinSpain","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/SueinSpain","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u7DUl-9NpGY!!6ZDtfnFmfzH","dateLastActive":"2023-06-28T10:19:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":150,"score":null,"hot":3208086148,"url":"https:\/\/community.smartsheet.com\/discussion\/21191\/creating-price-tickets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/21191\/creating-price-tickets","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":250,"urlcode":"Printing","name":"Printing"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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}]},{"discussionID":93222,"type":"idea","name":"Input data into sheet from a document","excerpt":"I love the function of taking data from Smartsheet and generating a pdf. Is there a way to reverse that functionality? For example, this format is easier to work with in a team setting: But I would like it to be uploaded to feed information back to the sheet in Smartsheet: Thank you for consideration.","categoryID":349,"dateInserted":"2022-07-14T15:31:47+00:00","dateUpdated":"2023-06-22T10:24:42+00:00","dateLastComment":"2023-06-21T23:57:56+00:00","insertUserID":137265,"insertUser":{"userID":137265,"name":"Amy Bedard","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Bedard","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-26T20:18:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":154049,"lastUser":{"userID":154049,"name":"Rob W.","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20W.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-03T17:26:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":170,"score":3,"hot":3345244289,"url":"https:\/\/community.smartsheet.com\/discussion\/93222\/input-data-into-sheet-from-a-document","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93222\/input-data-into-sheet-from-a-document","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/25BMS07WUL4J\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":106271,"type":"idea","name":"Print Dynamic View","excerpt":"Print or export the Dynamic View in order to distribute it to students and faculty.","categoryID":349,"dateInserted":"2023-06-09T14:39:25+00:00","dateUpdated":"2023-06-14T12:54:55+00:00","dateLastComment":"2023-06-14T12:29:37+00:00","insertUserID":158793,"insertUser":{"userID":158793,"name":"megarceau","url":"https:\/\/community.smartsheet.com\/profile\/megarceau","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:37:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":136233,"lastUser":{"userID":136233,"name":"Dawn McCallister","url":"https:\/\/community.smartsheet.com\/profile\/Dawn%20McCallister","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtccca_-90U_9MnORlEgzpUBEO8EeqyMzWNSMIPScQ=s96-c","dateLastActive":"2023-06-20T16:17:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":60,"score":5,"hot":3373072760,"url":"https:\/\/community.smartsheet.com\/discussion\/106271\/print-dynamic-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106271\/print-dynamic-view","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":106385,"type":"idea","name":"Allow the Import of Comments","excerpt":"When importing an excel file into Smartsheets, allow the comments tab to be added as well.","categoryID":349,"dateInserted":"2023-06-13T18:08:47+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T18:08:47+00:00","insertUserID":162334,"insertUser":{"userID":162334,"name":"Meighan Martin","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/Meighan%20Martin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!H-lpH9ej_jo!GRPlXi__sfI!h5_mRW7_6eS","dateLastActive":"2023-06-13T18:05:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162334,"lastUser":{"userID":162334,"name":"Meighan Martin","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/Meighan%20Martin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!H-lpH9ej_jo!GRPlXi__sfI!h5_mRW7_6eS","dateLastActive":"2023-06-13T18:05:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":26,"score":3,"hot":1686680627,"url":"https:\/\/community.smartsheet.com\/discussion\/106385\/allow-the-import-of-comments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106385\/allow-the-import-of-comments","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":57051,"type":"discussion","name":"Copy\/ Paste Cells With Multiple Lines Doesn't Work","excerpt":"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…","categoryID":321,"dateInserted":"2019-09-05T12:32:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-06-13T14:10:30+00:00","insertUserID":103046,"insertUser":{"userID":103046,"name":"NikkiAke","url":"https:\/\/community.smartsheet.com\/profile\/NikkiAke","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7QdCO9VHTzw!wuHDv50xufw!OzFIWExeqNX","dateLastActive":"2020-09-14T14:42:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162326,"lastUser":{"userID":162326,"name":"Hila ","url":"https:\/\/community.smartsheet.com\/profile\/Hila%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-25T07:19:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":4429,"score":2,"hot":3254359399,"url":"https:\/\/community.smartsheet.com\/discussion\/57051\/copy-paste-cells-with-multiple-lines-doesnt-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/57051\/copy-paste-cells-with-multiple-lines-doesnt-work","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">