❓️ob欧宝娱乐app手机下载产品的问题
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-06T18:44:22+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-06-23T04:36:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":150538,"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-07T13:18:00+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":132,"score":null,"hot":3351111611,"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","lastPost":{"discussionID":95065,"commentID":384009,"name":"Re: Date with Time uploading in Data Shuttle comes only with Date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384009#Comment_384009","dateInserted":"2023-07-06T18:44:22+00:00","insertUserID":91566,"insertUser":{"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-07T13:18:00+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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":[]},{"discussionID":91824,"type":"question","name":"Dynamic View - Dropdown Lists","excerpt":"I have certain single and multiple select list columns that do not have the \"restrict to dropdown values only\" checked on the source sheet but in Dynamic View we are unable to add in our own values if they don't exist in the dropdown. This has been extremely frustrating especially when trying to capture new values and…","snippet":"I have certain single and multiple select list columns that do not have the \"restrict to dropdown values only\" checked on the source sheet but in Dynamic View we are unable to add…","categoryID":343,"dateInserted":"2022-06-06T17:24:20+00:00","dateUpdated":"2022-06-14T14:39:36+00:00","dateLastComment":"2023-07-06T09:57:16+00:00","insertUserID":113932,"insertUser":{"userID":113932,"name":"Emmy Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Emmy%20Anderson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jplUI_CI3bw!8o9VN1d3-no!6TkM7ozjpN6","dateLastActive":"2023-05-04T14:55:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":163174,"lastUser":{"userID":163174,"name":"Gokhula Krishnan","url":"https:\/\/community.smartsheet.com\/profile\/Gokhula%20Krishnan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-06T12:09:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":396,"score":null,"hot":3343176696,"url":"https:\/\/community.smartsheet.com\/discussion\/91824\/dynamic-view-dropdown-lists","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91824\/dynamic-view-dropdown-lists","format":"Rich","tagIDs":[319],"lastPost":{"discussionID":91824,"commentID":383868,"name":"Re: Dynamic View - Dropdown Lists","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383868#Comment_383868","dateInserted":"2023-07-06T09:57:16+00:00","insertUserID":163174,"insertUser":{"userID":163174,"name":"Gokhula Krishnan","url":"https:\/\/community.smartsheet.com\/profile\/Gokhula%20Krishnan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-06T12:09:34+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-06-08T12:36:40+00:00","dateAnswered":"2022-06-06T18:38:56+00:00","acceptedAnswers":[{"commentID":332119,"body":"

Hi @Emmy Anderson<\/a> <\/p>

You are not missing anything. This is how DV works with dropdowns unfortunately. My work around in the past is to create an other option in the drop down, user chooses save. Then have logic built for a text field that appears so the user can input the values not present in dropdown. <\/p>

Hope this helps<\/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":319,"urlcode":"functionality","name":"functionality"}]}],"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":615,"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

  • Dynamic View - Dropdown Lists

    I have certain single and multiple select list columns that do not have the "restrict to dropdown values only" checked on the source sheet but in Dynamic View we are unable to add in our own values if they don't exist in the dropdown. This has been extremely frustrating especially when trying to capture new values and…

Enter to Win a FREE Conference Pass to ENGAGE 2023

 Learn more