功能

New committed date then i should get some color & the same way if committed date>actual completion date then i should get color & the same if New committed date…","categoryID":322,"dateInserted":"2020-02-12T04:47:14+00:00","dateUpdated":null,"dateLastComment":"2020-02-12T07:51:32+00:00","insertUserID":110186,"insertUser":{"userID":110186,"name":"Khasim ","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Khasim%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QYHY8H9N1R3Z\/nIZFAF9LQG5HD.jpg","dateLastActive":"2023-06-09T03:25:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":118579,"lastUser":{"userID":118579,"name":"Manuel Macias","url":"https:\/\/community.smartsheet.com\/profile\/Manuel%20Macias","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-12-10T19:33:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":112,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/65946\/comparisons-of-dates-committed-date-new-committed-date-actual-completion-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65946\/comparisons-of-dates-committed-date-new-committed-date-actual-completion-date","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":65947,"type":"question","name":"Jumping to a very distant date","excerpt":"Hi everyone I have a Date column in a sheet, wherein I am unable to select \/ jump to a very old date (e.g. Jan 1, 1980) directly! Need help! Thanks","categoryID":321,"dateInserted":"2020-02-12T06:51:21+00:00","dateUpdated":null,"dateLastComment":"2020-02-12T07:09:32+00:00","insertUserID":101121,"insertUser":{"userID":101121,"name":"Nasir@EBC","url":"https:\/\/community.smartsheet.com\/profile\/Nasir%40EBC","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!BXjVgasCKqQ!c2DUpw9M-nY!rKVmGGpiJ0x","dateLastActive":"2023-03-08T10:45:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":101121,"lastUser":{"userID":101121,"name":"Nasir@EBC","url":"https:\/\/community.smartsheet.com\/profile\/Nasir%40EBC","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!BXjVgasCKqQ!c2DUpw9M-nY!rKVmGGpiJ0x","dateLastActive":"2023-03-08T10:45:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":76,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/65947\/jumping-to-a-very-distant-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65947\/jumping-to-a-very-distant-date","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-12T07:09:11+00:00","dateAnswered":"2020-02-12T07:06: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":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":65819,"type":"question","name":"Dynamic push of data into Excel from a Report","excerpt":"Hey guys, I need some help as I 'm trying to automatically import some data from a specific colum displayed in a Report into an Excel spreadsheet and I don't really know how to do it... Here's the steps I've followed in order to have the data displayed dynamically in my Excel spreadsheet : #1 - I've created a report in…","categoryID":322,"dateInserted":"2020-02-06T22:58:50+00:00","dateUpdated":"2020-02-06T23:08:34+00:00","dateLastComment":"2020-02-11T15:06:37+00:00","insertUserID":96616,"insertUser":{"userID":96616,"name":"Francis Comtois","url":"https:\/\/community.smartsheet.com\/profile\/Francis%20Comtois","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2pPD_70MWzw!!DitW8PHLWhC","dateLastActive":"2020-03-03T21:57:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":96616,"lastUserID":45236,"lastUser":{"userID":45236,"name":"Alejandra","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Alejandra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/8a\/fe\/n8afeceb592ad5845f46c7d931defba07.JPG","dateLastActive":"2020-05-15T18:56:51+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":274,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/65819\/dynamic-push-of-data-into-excel-from-a-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65819\/dynamic-push-of-data-into-excel-from-a-report","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/059\/BQMZOA8WBDCV.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2020-02-06_17-23-36.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}">