CrystalJ_Medtronic

讨论

    [Target End Date]@row, \"Completed Late\",…","categoryID":322,"dateInserted":"2022-12-08T23:11:07+00:00","dateUpdated":null,"dateLastComment":"2022-12-12T15:43:58+00:00","insertUserID":147955,"insertUser":{"userID":147955,"name":"CrystalJ_Medtronic","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CrystalJ_Medtronic","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xYjWMc8TNVY!u9HVZ58KpX4!CoQXqzqnKu_","dateLastActive":"2023-02-06T16:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147955,"lastUser":{"userID":147955,"name":"CrystalJ_Medtronic","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CrystalJ_Medtronic","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xYjWMc8TNVY!u9HVZ58KpX4!CoQXqzqnKu_","dateLastActive":"2023-02-06T16:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":190,"score":null,"hot":3341405105,"url":"https:\/\/community.smartsheet.com\/discussion\/98593\/need-help-with-formula-status-based-on-target-end-date-actual-end-date-and-at-risk-flag","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98593\/need-help-with-formula-status-based-on-target-end-date-actual-end-date-and-at-risk-flag","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-12-09T17:44:27+00:00","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"}],"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":97305,"type":"question","name":"Status Formula is not calculating correctly for parent tasks","excerpt":"I was trying to align my Health and Status columns, but the status formula is acting wonky.. (there's a technical term for ya! 😂) First a HUGE disclaimer. I'm not not new to Smartsheet, but I am new to this particular sheet. I inherited it, and the person who created this formula is out on leave until February. Here's my…","categoryID":322,"dateInserted":"2022-11-03T06:13:35+00:00","dateUpdated":null,"dateLastComment":"2022-11-09T16:46:34+00:00","insertUserID":147955,"insertUser":{"userID":147955,"name":"CrystalJ_Medtronic","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CrystalJ_Medtronic","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xYjWMc8TNVY!u9HVZ58KpX4!CoQXqzqnKu_","dateLastActive":"2023-02-06T16:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147955,"lastUser":{"userID":147955,"name":"CrystalJ_Medtronic","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CrystalJ_Medtronic","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xYjWMc8TNVY!u9HVZ58KpX4!CoQXqzqnKu_","dateLastActive":"2023-02-06T16:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":144,"score":null,"hot":3335471409,"url":"https:\/\/community.smartsheet.com\/discussion\/97305\/status-formula-is-not-calculating-correctly-for-parent-tasks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97305\/status-formula-is-not-calculating-correctly-for-parent-tasks","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/6QDOEUWUOM3V\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-03T15:31:57+00:00","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"}],"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":97532,"type":"question","name":"NEED HELP WITH FORMULA: Status Based on Target End Date and Actual End Date","excerpt":"I have a status column that I would like to automatically update based on the dates in the Target End Date and Actual End Date columns. The parameters are as follows: If the Actual End Date is less than or equal to the Target End Date = Completed On Time If the Actual End Date is greater than than the Target End Date =…","categoryID":322,"dateInserted":"2022-11-09T06:45:08+00:00","dateUpdated":"2022-11-09T08:24:11+00:00","dateLastComment":"2022-11-09T16:32:05+00:00","insertUserID":147955,"insertUser":{"userID":147955,"name":"CrystalJ_Medtronic","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CrystalJ_Medtronic","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xYjWMc8TNVY!u9HVZ58KpX4!CoQXqzqnKu_","dateLastActive":"2023-02-06T16:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":147955,"lastUserID":147955,"lastUser":{"userID":147955,"name":"CrystalJ_Medtronic","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CrystalJ_Medtronic","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xYjWMc8TNVY!u9HVZ58KpX4!CoQXqzqnKu_","dateLastActive":"2023-02-06T16:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":229,"score":null,"hot":3335990233,"url":"https:\/\/community.smartsheet.com\/discussion\/97532\/need-help-with-formula-status-based-on-target-end-date-and-actual-end-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97532\/need-help-with-formula-status-based-on-target-end-date-and-actual-end-date","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-09T16:28:49+00:00","dateAnswered":"2022-11-09T16:14:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":91058,"type":"question","name":"How can I create a similar risk report\/dashboard","excerpt":"I have a report that I need to generate once a month. I currently generate this in a PowerPoint table, but would love to use Smartsheet to generate this. To be clear, it's the red\/yellow\/green chart in particular that I would like to re-create in Smartsheet. Any suggestions would be welcome.","categoryID":321,"dateInserted":"2022-05-12T15:37:55+00:00","dateUpdated":"2022-05-12T15:40:25+00:00","dateLastComment":"2022-05-17T13:47:13+00:00","insertUserID":147955,"insertUser":{"userID":147955,"name":"CrystalJ_Medtronic","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CrystalJ_Medtronic","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xYjWMc8TNVY!u9HVZ58KpX4!CoQXqzqnKu_","dateLastActive":"2023-02-06T16:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":147955,"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-06-09T16:55:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":197,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/91058\/how-can-i-create-a-similar-risk-report-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91058\/how-can-i-create-a-similar-risk-report-dashboard","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BUCKIQU8G43W\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-05-17T10:11:16+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[],"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":false,"noCheckboxes":true}">
《阿凡达》