Importing and Exporting

Sheet B. Sheet A contains several columns that Sheet B does not. Currently, moving the row results in Smartsheet automatically creating the ommited columns in Sheet B and dumping them at the end. Is it possible using the API, to select only the columns I want to move? Or to somehow…","categoryID":318,"dateInserted":"2016-11-07T16:55:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-11-08T14:47:24+00:00","insertUserID":9054,"insertUser":{"userID":9054,"name":"Paul Mather","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Mather","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-11-07T16:49:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":603,"lastUser":{"userID":603,"name":"dAVE Inden","url":"https:\/\/community.smartsheet.com\/profile\/dAVE%20Inden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/2f\/a6\/n2fa68b66b9aff39a6e105069eb3e7cfc.jpg","dateLastActive":"2019-07-15T14:06:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":536,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/6486\/api-copying-only-specific-columns-within-a-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6486\/api-copying-only-specific-columns-within-a-row","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","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":6446,"type":"discussion","name":"Business Resumption Plan","excerpt":"Does anyone currently us Smartsheet in their Business Resumption planning?","categoryID":318,"dateInserted":"2016-11-02T15:19:47+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-11-03T10:43:47+00:00","insertUserID":8996,"insertUser":{"userID":8996,"name":"Kelly Wray","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Wray","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-11-02T15:13:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8989,"lastUser":{"userID":8989,"name":"Aashish Malhotra","url":"https:\/\/community.smartsheet.com\/profile\/Aashish%20Malhotra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-11-02T10:08:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6446\/business-resumption-plan","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6446\/business-resumption-plan","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":223,"urlcode":"publish","name":"Publish"},{"tagID":246,"urlcode":"mobile","name":"Mobile"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":273,"urlcode":"security","name":"Security"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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":6343,"type":"discussion","name":"Saving Smart Sheets in storage","excerpt":"I hate having all of these smart sheet tabs. Is there a way to export them to a smart sheet format in another directory? I dont want to save to excel or any other format. I just want to hide my smart sheets off my tabs. Thanx!","categoryID":318,"dateInserted":"2016-10-20T11:33:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-10-20T12:21:23+00:00","insertUserID":8770,"insertUser":{"userID":8770,"name":"Doug Carter","url":"https:\/\/community.smartsheet.com\/profile\/Doug%20Carter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-20T11:26:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8770,"lastUser":{"userID":8770,"name":"Doug Carter","url":"https:\/\/community.smartsheet.com\/profile\/Doug%20Carter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-20T11:26:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":5,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/6343\/saving-smart-sheets-in-storage","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6343\/saving-smart-sheets-in-storage","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"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":6214,"type":"discussion","name":"Spreadsheet data source","excerpt":"I have a spreadsheet that automatically pulls in data on projects that my global team is handling. I have not been able to figure out if I can link this spreadsheet to SmartSheet. The reason I would like to do this is that this spreadsheet automatically pulls in new project requests down from SharePoint. Please let me know…","categoryID":318,"dateInserted":"2016-10-02T09:00:20+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-10-03T13:32:10+00:00","insertUserID":7721,"insertUser":{"userID":7721,"name":"Tony Davidson - SmartSheet Certified User 2016","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Davidson%20-%20SmartSheet%20Certified%20User%202016","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-23T15:04:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":7721,"lastUser":{"userID":7721,"name":"Tony Davidson - SmartSheet Certified User 2016","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Davidson%20-%20SmartSheet%20Certified%20User%202016","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-23T15:04:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":4,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/6214\/spreadsheet-data-source","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6214\/spreadsheet-data-source","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":268,"urlcode":"attachments","name":"Attachments"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"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}]},{"discussionID":6078,"type":"discussion","name":"IMPORT first CSV column as TEXT instead of NUMBER","excerpt":"I don't see a way to force my first CSV column to be treated as TEXT during an IMPORT, even when that column sometimes contains data that looks like a number. A simple example of this would be a list that has 2 digit hex values from 00 to FF. The lines with A-F get treated as text, but other lines are subjected to leading…","categoryID":318,"dateInserted":"2016-09-15T20:12:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-09-16T06:39:41+00:00","insertUserID":8293,"insertUser":{"userID":8293,"name":"Per Martin","url":"https:\/\/community.smartsheet.com\/profile\/Per%20Martin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-09-13T09:20:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":245,"lastUser":{"userID":245,"name":"JamesR","title":"","url":"https:\/\/community.smartsheet.com\/profile\/JamesR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/87\/15\/n8715b9481d6c0836c04cd6097804bec6.jpg","dateLastActive":"2019-07-19T03:25:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/6078\/import-first-csv-column-as-text-instead-of-number","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6078\/import-first-csv-column-as-text-instead-of-number","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","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":6056,"type":"discussion","name":"Export feature got worse since SS upgrade","excerpt":"One of the nice features of SS was the option of including the comments when exporting say to Excel. The exported file has all the comments in a seperate Excel tab. But it still referenced the \"Primary\" so you can match each row in your SS (1st tab in the Excel export) with the comments. A few weeks ago, there was an…","categoryID":318,"dateInserted":"2016-09-13T16:14:07+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-09-14T17:46:52+00:00","insertUserID":6043,"insertUser":{"userID":6043,"name":"Mario K M","url":"https:\/\/community.smartsheet.com\/profile\/Mario%20K%20M","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-19T16:44:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":279,"lastUser":{"userID":279,"name":"Kara Lumley","url":"https:\/\/community.smartsheet.com\/profile\/Kara%20Lumley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/95\/4e\/n954e10e9b436e9acd6f195bdf2312f07.jpg","dateLastActive":"2020-11-10T15:44:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":3,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/6056\/export-feature-got-worse-since-ss-upgrade","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6056\/export-feature-got-worse-since-ss-upgrade","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":250,"urlcode":"printing","name":"Printing"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"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":6052,"type":"discussion","name":"Does 365 \/ One Drive help the attachment process within Smartsheet?","excerpt":"Hi, Our Company has just installed Office 365 to all laptops. We did this for various reason: 1. We didn't want anyone saving work to their C drive and losing it if a virus struck (so everything that isn't saved to Smartsheet is saved to One Drive. 2. We wanted to ensure that all documents can be accessed from any laptop\/…","categoryID":318,"dateInserted":"2016-09-13T06:40:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-09-13T07:02:01+00:00","insertUserID":1928,"insertUser":{"userID":1928,"name":"Irene Plant","url":"https:\/\/community.smartsheet.com\/profile\/Irene%20Plant","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-19T09:06:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":237,"lastUser":{"userID":237,"name":"Richard Rymill SBP","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Rymill%20SBP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/56\/cc\/n56cc5e719e36b8b84e97c4c58049f914.jpg","dateLastActive":"2023-08-07T12:19:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":15,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6052\/does-365-one-drive-help-the-attachment-process-within-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6052\/does-365-one-drive-help-the-attachment-process-within-smartsheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":268,"urlcode":"attachments","name":"Attachments"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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}">