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-07-17T16:56:56+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-17T18:37:35+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":46,"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":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-13T19:26:35+00:00","dateAnswered":"2023-07-03T09:00: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":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-07-17T13:22: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-17T19:25:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":36,"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-07-10T18:38:54+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-17T19:25:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":45,"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-07-13T12:29:55+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-07-13T12:29:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":63,"score":1,"hot":3374906951,"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-07-17T15:54:33+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-07-17T15:54:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":36,"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">