Data Shuttle

Import File>Export Within the “Connections” menu, users shared…","categoryID":335,"dateInserted":"2023-07-26T14:47:07+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T16:37:55+00:00","insertUserID":152988,"insertUser":{"userID":152988,"name":"Danielle Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Danielle%20Wilson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZZDXWctIdZQ!BrDQwSiqPOQ!J3oBfQ3Wq2i","dateLastActive":"2023-08-23T12:42:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":137019,"lastUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-08-25T18:19:58+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"pinned":true,"pinLocation":"category","closed":false,"sink":false,"countComments":1,"countViews":146,"score":3,"hot":3381378602,"url":"https:\/\/community.smartsheet.com\/discussion\/108097\/new-ways-to-access-data-shuttle-from-within-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108097\/new-ways-to-access-data-shuttle-from-within-sheets","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/59VNAPRHLNIG\/frame-2368811-281-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Frame 2368811 (1).png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","allowedDiscussionTypes":[]},"tags":[{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}],"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":108060,"type":"discussion","name":"Add & Edit Sheet Columns within Data Shuttle","excerpt":"Hi Community, We’re excited to announce improvements to the mapping step in Data Shuttle! Now when creating an Upload Workflow, you will have the ability to create and rename sheet columns from within the Data Shuttle workflow builder. Previously, if your target sheet was not set up correctly before starting the mapping…","categoryID":335,"dateInserted":"2023-07-25T19:40:20+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T16:34:48+00:00","insertUserID":152988,"insertUser":{"userID":152988,"name":"Danielle Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Danielle%20Wilson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZZDXWctIdZQ!BrDQwSiqPOQ!J3oBfQ3Wq2i","dateLastActive":"2023-08-23T12:42:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":137019,"lastUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-08-25T18:19:58+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"pinned":true,"pinLocation":"category","closed":false,"sink":false,"countComments":1,"countViews":126,"score":5,"hot":3381310208,"url":"https:\/\/community.smartsheet.com\/discussion\/108060\/add-edit-sheet-columns-within-data-shuttle","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108060\/add-edit-sheet-columns-within-data-shuttle","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/5RQ6UDC88PU6\/ds-dt-1-mapping-281-29-282-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"DS-DT_1 - Mapping (1) (2).png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","allowedDiscussionTypes":[]},"tags":[{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}],"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":108269,"type":"question","name":"Dashboard Metric Breaks on Update of DataShuttle","excerpt":"I am sure there is something I am missing. But I try to set a Dashboard Matrix on a field that is refreshed by Data Shuttle. But when the Grid refreshes it breaks the Metric and says Data missing even though there is data in the field. Is there anyway around this or does Data Shuttle always break a Metric Cell?","categoryID":321,"dateInserted":"2023-07-28T17:52:38+00:00","dateUpdated":null,"dateLastComment":"2023-07-31T12:51:51+00:00","insertUserID":164293,"insertUser":{"userID":164293,"name":"Joshua Jones","title":"IT Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Joshua%20Jones","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-21T16:49:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":73,"score":null,"hot":3381376469,"url":"https:\/\/community.smartsheet.com\/discussion\/108269\/dashboard-metric-breaks-on-update-of-datashuttle","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108269\/dashboard-metric-breaks-on-update-of-datashuttle","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-28T22:21:14+00:00","dateAnswered":"2023-07-28T20:45:34+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":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}],"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":107770,"type":"question","name":"Data Shuttle Filters","excerpt":"Hello, Is it possible for have a filter for an upload workflow in Data Shuttle be based on a date. I am trying to only pull in data from an Excel file where the value in the column is on or after 5\/31\/2023. Thank you","categoryID":343,"dateInserted":"2023-07-18T22:34:01+00:00","dateUpdated":null,"dateLastComment":"2023-07-19T01:31:40+00:00","insertUserID":148401,"insertUser":{"userID":148401,"name":"Nick Sor","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Sor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-23T22:10:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-08-26T03:07:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":128,"score":null,"hot":3379450541,"url":"https:\/\/community.smartsheet.com\/discussion\/107770\/data-shuttle-filters","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107770\/data-shuttle-filters","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-19T01:31:40+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}],"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":95065,"type":"question","name":"Date with Time uploading in Data Shuttle comes only with Date","excerpt":"Hi Everyone, I'm uploading Input excel having column value \"6\/1\/2022 1:22:23 AM\". But after uploading into SmartSheet, it comes only date \"2022-06-01\". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P","categoryID":343,"dateInserted":"2022-09-06T04:45:49+00:00","dateUpdated":"2022-09-19T13:55:39+00:00","dateLastComment":"2023-07-17T05:45:57+00:00","insertUserID":140679,"insertUser":{"userID":140679,"name":"Sandhiya07","url":"https:\/\/community.smartsheet.com\/profile\/Sandhiya07","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-19T10:31:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":150538,"lastUserID":160587,"lastUser":{"userID":160587,"name":"jchalig","url":"https:\/\/community.smartsheet.com\/profile\/jchalig","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYoEMnTBzhn1aYHnoptj2Qx2vDwz2e68_hYghUB=s96-c","dateLastActive":"2023-07-17T07:20:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":304,"score":null,"hot":3352018306,"url":"https:\/\/community.smartsheet.com\/discussion\/95065\/date-with-time-uploading-in-data-shuttle-comes-only-with-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95065\/date-with-time-uploading-in-data-shuttle-comes-only-with-date","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-19T12:13:48+00:00","dateAnswered":"2022-09-09T10:19:47+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}],"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":107269,"type":"discussion","name":"Streamlining Production Planning: How Smartsheet Integration Saves Time and Boosts Efficiency","excerpt":"One of our clients faced the challenge of their planning team constantly needing to check a shared Google sheet throughout the day. The process of reviewing the data multiple times and manually updating the schedule was time-consuming and prone to errors. Missing any crucial information could potentially disrupt their…","categoryID":346,"dateInserted":"2023-07-06T10:18:03+00:00","dateUpdated":null,"dateLastComment":"2023-07-16T18:39:06+00:00","insertUserID":134589,"insertUser":{"userID":134589,"name":"Kaveri Vipat","url":"https:\/\/community.smartsheet.com\/profile\/Kaveri%20Vipat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NQKN3CYKP7WS\/nPGXBF6SL3KW8.jpg","dateLastActive":"2023-08-25T13:18:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":152988,"lastUser":{"userID":152988,"name":"Danielle Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Danielle%20Wilson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZZDXWctIdZQ!BrDQwSiqPOQ!J3oBfQ3Wq2i","dateLastActive":"2023-08-23T12:42:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":140,"score":null,"hot":3378172029,"url":"https:\/\/community.smartsheet.com\/discussion\/107269\/streamlining-production-planning-how-smartsheet-integration-saves-time-and-boosts-efficiency","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107269\/streamlining-production-planning-how-smartsheet-integration-saves-time-and-boosts-efficiency","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":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}],"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}">