制造业

= 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\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-02T16:41:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":7587,"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":"","300":"","800":"","1200":"","1600":""},"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":422,"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":228,"urlcode":"Project Management","name":"Project Management"},{"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":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":24,"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":206,"urlcode":"Update Requests","name":"Update Requests"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"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":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":"2022-09-02T13:36:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":1765,"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":206,"urlcode":"Update Requests","name":"Update Requests"},{"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":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":236,"urlcode":"Metals & Mining","name":"Metals & Mining"},{"tagID":237,"urlcode":"Transportation","name":"Transportation"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":242,"urlcode":"Resource Views","name":"Resource Views"},{"tagID":244,"urlcode":"Product Development","name":"Product Development"},{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":262,"urlcode":"Agriculture","name":"Agriculture"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":264,"urlcode":"Financial Services","name":"Financial Services"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":267,"urlcode":"Energy & Utilities","name":"Energy & Utilities"},{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"tagID":276,"urlcode":"Retail","name":"Retail"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"}],"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}">