制造业

= 60 and <=89 then Yellow, if days open is >=90 then Red. I can write the individual formulas to get the red…","categoryID":322,"dateInserted":"2019-08-14T08:24:08+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-12-11T09:41:25+00:00","insertUserID":81011,"insertUser":{"userID":81011,"name":"Melissa Shoumlisky","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Shoumlisky","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HzDXH223gOY!7OjWe6mvRiQ!HMFAGOp6Fm_","dateLastActive":"2022-05-25T20:58:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-03-22T16:46:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":9194,"score":null,"hot":12,"url":"https:\/\/community.smartsheet.com\/discussion\/55101\/formula-if-cell-is-blank-then-if-cell-is-not-blank-then","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/55101\/formula-if-cell-is-blank-then-if-cell-is-not-blank-then","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/3c\/ce\/3cce05ee97d328aec97d94907b7d36a9.JPG","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/3c\/ce\/3cce05ee97d328aec97d94907b7d36a9.JPG","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/3c\/ce\/3cce05ee97d328aec97d94907b7d36a9.JPG","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/3c\/ce\/3cce05ee97d328aec97d94907b7d36a9.JPG","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/3c\/ce\/3cce05ee97d328aec97d94907b7d36a9.JPG","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/3c\/ce\/3cce05ee97d328aec97d94907b7d36a9.JPG"},"alt":"sheet.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"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":29116,"type":"discussion","name":"% Complete based on Todays date, Start and End dates","excerpt":"I'm looking to return a % complete based on the start and end dates and the current date. So if a task starts on the 17\/7 and ends on the 31\/7, and today is the 24\/7 - the % complete would be 53%. - (I want to have this as a separate column so I can keep dependencies on the actual % complete column) =(MIN(TODAY(),*finish…","categoryID":322,"dateInserted":"2018-07-24T09:25:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-12-08T20:27:00+00:00","insertUserID":34581,"insertUser":{"userID":34581,"name":"AGillespie","url":"https:\/\/community.smartsheet.com\/profile\/AGillespie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/66\/ed\/n66ed0fe0efdb8cf4041edada6f29d447.png","dateLastActive":"2018-07-31T06:12:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":142447,"lastUser":{"userID":142447,"name":"AlexK_Emburse","url":"https:\/\/community.smartsheet.com\/profile\/AlexK_Emburse","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-12-08T20:25:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":536,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/29116\/complete-based-on-todays-date-start-and-end-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29116\/complete-based-on-todays-date-start-and-end-dates","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":84940,"type":"question","name":"Reference Codes","excerpt":"Hi, I am looking to have a single reference code or number that is attached to an update request that contains multiple rows. Is there a best way to do this? My first thought is to have a value added to a cell when the reference goes out, is there a way to make this a rolling serial number as each update request is…","categoryID":322,"dateInserted":"2021-11-12T17:46:16+00:00","dateUpdated":null,"dateLastComment":"2021-11-15T18:13:22+00:00","insertUserID":141782,"insertUser":{"userID":141782,"name":"bvannuland","url":"https:\/\/community.smartsheet.com\/profile\/bvannuland","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-19T20:19:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":141782,"lastUser":{"userID":141782,"name":"bvannuland","url":"https:\/\/community.smartsheet.com\/profile\/bvannuland","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-19T20:19:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":104,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/84940\/reference-codes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84940\/reference-codes","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-11-15T17:21:08+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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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":43936,"type":"discussion","name":"Time Tracking - Hours and Minutes","excerpt":"I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put \"00\" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…","categoryID":322,"dateInserted":"2019-03-19T12:45:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-11-02T17:35:29+00:00","insertUserID":58936,"insertUser":{"userID":58936,"name":"Ezra","url":"https:\/\/community.smartsheet.com\/profile\/Ezra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/722\/n8VN7BXAAHKNJ.png","dateLastActive":"2020-07-17T14:29:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-06T16:55:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":2112,"score":1,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/43936\/time-tracking-hours-and-minutes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43936\/time-tracking-hours-and-minutes","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":220,"urlcode":"Hospitality","name":"Hospitality"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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":55341,"type":"discussion","name":"Please add a successor column or function","excerpt":"A way to show successors is needed. It's important for critical path scheduling that every task has a predecessor and a successor. After a couple hundred lines it becomes nearly impossible to eyeball everything to make sure that's true. A successor column allows one to simply filter to find the missing successors. Thanks.…","categoryID":321,"dateInserted":"2019-08-15T19:59:32+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-09-27T17:46:15+00:00","insertUserID":100311,"insertUser":{"userID":100311,"name":"john.delaney100311","url":"https:\/\/community.smartsheet.com\/profile\/john.delaney100311","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-21T19:11:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":138927,"lastUser":{"userID":138927,"name":"AW10101","url":"https:\/\/community.smartsheet.com\/profile\/AW10101","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-10-12T16:51:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":792,"score":2,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/55341\/please-add-a-successor-column-or-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/55341\/please-add-a-successor-column-or-function","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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}">