@Terry Lewis<\/a> <\/p>Since Smartsheet does not have a Time function or column type, you would want to map this data to a Text\/Number column. In testing on my end, mapping this type of value to a Text\/Number column brought through the entire cell contents. <\/p>
If you're only seeing the Date come through when mapping to a Text\/Number column, would you be able to upload a copy of the file with dummy data that I could test with?<\/p>
Thanks!<\/p>
Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":75870,"type":"question","name":"Printing Grouped Reports","excerpt":"I have a report that i have used the new grouping function on and i'm wanting to print it with the group headings but each time i print as pdf or export it only shows the standard cells, without the group headings, is this correct or is there something i'm missing?","categoryID":321,"dateInserted":"2021-02-07T19:56:46+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T15:02:05+00:00","insertUserID":131710,"insertUser":{"userID":131710,"name":"J.H.W.","url":"https:\/\/community.smartsheet.com\/profile\/J.H.W.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-18T12:47:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":155325,"lastUser":{"userID":155325,"name":"amanda.wright","url":"https:\/\/community.smartsheet.com\/profile\/amanda.wright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-25T14:58:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":52,"countViews":2815,"score":8,"hot":3282149931,"url":"https:\/\/community.smartsheet.com\/discussion\/75870\/printing-grouped-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75870\/printing-grouped-reports","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":75870,"commentID":352281,"name":"Re: Printing Grouped Reports","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352281#Comment_352281","dateInserted":"2022-11-25T15:02:05+00:00","insertUserID":155325,"insertUser":{"userID":155325,"name":"amanda.wright","url":"https:\/\/community.smartsheet.com\/profile\/amanda.wright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-25T14:58:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-08T04:55:16+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-07-11 14:49:05","updateUser":{"userID":149942,"name":"Gerardo Saenz","url":"https:\/\/community.smartsheet.com\/profile\/Gerardo%20Saenz","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucrwCNWznlII9OSel_5xsT2_ViTunqzNLEE-h5st=s96-c","dateLastActive":"2022-08-03T20:18:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":8},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"}]},{"discussionID":98013,"type":"question","name":"Setting an entire Project Sheet to On Hold","excerpt":"Hi all, I'm sure someone has encountered this but I'm curious if anyone has done anything with setting an entire project \"On Hold\" so that it reflects in the rollup sheets\/dashboards. For reference, we are using the PMO template to base our projects off of. What we would like to be able to do is put a new row in at the…","categoryID":321,"dateInserted":"2022-11-21T19:51:29+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T13:33:39+00:00","insertUserID":146258,"insertUser":{"userID":146258,"name":"dhall","url":"https:\/\/community.smartsheet.com\/profile\/dhall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-21T19:51:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":146258,"lastUser":{"userID":146258,"name":"dhall","url":"https:\/\/community.smartsheet.com\/profile\/dhall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-21T19:51:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":32,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/98013\/setting-an-entire-project-sheet-to-on-hold","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98013\/setting-an-entire-project-sheet-to-on-hold","format":"Rich","tagIDs":[215,254,334],"lastPost":{"discussionID":98013,"name":"Setting an entire Project Sheet to On Hold","url":"https:\/\/community.smartsheet.com\/discussion\/98013\/setting-an-entire-project-sheet-to-on-hold","dateInserted":"2022-11-25T13:33:39+00:00","insertUserID":146258,"insertUser":{"userID":146258,"name":"dhall","url":"https:\/\/community.smartsheet.com\/profile\/dhall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-21T19:51:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":215,"urlcode":"Templates","name":"Templates"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":98060,"type":"question","name":"Approval Requests summary from HOME tab","excerpt":"Hi Did smartsheet remove the approval requests summary from the HOME tab? This feature provided tracking of all the requests sent by the sheet owner and a list of all pending requests that need to be approved by the current user. Would you know whether Smartheet removed this feature or moved it somewhere else? I appreciate…","categoryID":321,"dateInserted":"2022-11-22T22:59:22+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T13:18:21+00:00","insertUserID":126193,"insertUser":{"userID":126193,"name":"Rahul Patel","url":"https:\/\/community.smartsheet.com\/profile\/Rahul%20Patel","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!koFV_7dOevo!k0tVvxdye7o!RKuOltBclF4","dateLastActive":"2022-11-24T23:24:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-11-25T18:11:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":38,"score":null,"hot":3338542063,"url":"https:\/\/community.smartsheet.com\/discussion\/98060\/approval-requests-summary-from-home-tab","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98060\/approval-requests-summary-from-home-tab","format":"Rich","tagIDs":[451],"lastPost":{"discussionID":98060,"commentID":352277,"name":"Re: Approval Requests summary from HOME tab","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352277#Comment_352277","dateInserted":"2022-11-25T13:18:21+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-11-25T18:11:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-24T12:16:38+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-24 12:16:38","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-11-25T18:11:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":451,"urlcode":"home-and-navigation","name":"Home and Navigation"}]}],"title":"Recent Discussions","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">