❓️Product questions
Sign in andask it here!The community's got your back.

Wondering if there’s a problem?
Check out theStatus Pageand subscribe for notifications.

Check what Support you have access to based on your Plan
Overview of Smartsheet support hours and resources

Share your knowledge!
Help others byanswering questions.

Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

Discussion List

Categories

Popular Tags

Hi Tye,<\/p>

If I'm not misstaken, @JeremiahHorstick<\/a> has done this previously. <\/p>

I hope that helps!<\/p>

Have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/p>

Workflow Consultant \/ CEO @ WORK BOLD<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":[]},{"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","snippet":"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…","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-15T05:36:35+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":193,"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","tagIDs":[474],"lastPost":{"discussionID":95065,"commentID":385501,"name":"Re: Date with Time uploading in Data Shuttle comes only with Date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385501#Comment_385501","dateInserted":"2023-07-17T05:45:57+00:00","insertUserID":160587,"insertUser":{"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":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"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":[{"commentID":342967,"body":"

Hi @Sandhiya07<\/a> <\/p>

Smartsheet Date columns can only house Dates, there currently isn't a Time function in Smartsheet. (System Columns can include timestamps, however these cannot be updated by Data Shuttle). <\/p>

If you need to see the time, make sure to map this column to a Text\/Number<\/strong> column in Smartsheet so that all of the text will appear. <\/p>

Let me know if that works for you!<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":107651,"type":"question","name":"With Control Center, is the Global Update feature also able update automated workflows?","excerpt":"I used automated workflows... a lot. We're looking to purchase Control Center, but it is not clear to me if I will be able to update my automated workflows across multiple sheets in the event I have a common change or update to make.","snippet":"I used automated workflows... a lot. We're looking to purchase Control Center, but it is not clear to me if I will be able to update my automated workflows across multiple sheets…","categoryID":343,"dateInserted":"2023-07-16T00:18:56+00:00","dateUpdated":null,"dateLastComment":"2023-07-16T16:19:53+00:00","insertUserID":162134,"insertUser":{"userID":162134,"name":"CamSME","title":"Process Developer","url":"https:\/\/community.smartsheet.com\/profile\/CamSME","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/77LU8YZ28C58\/nJEEKOCCX2CP5.png","dateLastActive":"2023-07-16T17:07:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":122388,"lastUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-07-18T01:54:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3378992929,"url":"https:\/\/community.smartsheet.com\/discussion\/107651\/with-control-center-is-the-global-update-feature-also-able-update-automated-workflows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107651\/with-control-center-is-the-global-update-feature-also-able-update-automated-workflows","format":"Rich","tagIDs":[466],"lastPost":{"discussionID":107651,"commentID":385483,"name":"Re: With Control Center, is the Global Update feature also able update automated workflows?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385483#Comment_385483","dateInserted":"2023-07-16T16:19:53+00:00","insertUserID":122388,"insertUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-07-18T01:54:26+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-16T15:01:29+00:00","dateAnswered":"2023-07-16T14:48:33+00:00","acceptedAnswers":[{"commentID":385480,"body":"

Hi @CamSME<\/a> <\/p>

Unfortunately updating automated workflows is not a feature in Global Updates. If you can get around that though, Control Center can be really great.<\/p>

I hope that helps.<\/p>

Matt<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":466,"urlcode":"control-center","name":"Control Center"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":623,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Live Data Connector to SAGE accounting

    I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has anyone ever linked an accounting systems to Smartsheet? I am assuming it is possible, but I want to gather other's experiences if they have. Thanks!

  • Date with Time uploading in Data Shuttle comes only with Date

    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

  • With Control Center, is the Global Update feature also able update automated workflows?

    I used automated workflows... a lot. We're looking to purchase Control Center, but it is not clear to me if I will be able to update my automated workflows across multiple sheets in the event I have a common change or update to make.

Enter to Win a FREE Conference Pass to ENGAGE 2023

 Learn more