制造业

[Adj End Date]5,TRUE,FALSE) I then want to do conditional…","categoryID":318,"dateInserted":"2016-10-26T13:04:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-10-26T14:17:55+00:00","insertUserID":8853,"insertUser":{"userID":8853,"name":"Cindi Rella","url":"https:\/\/community.smartsheet.com\/profile\/Cindi%20Rella","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-26T13:02:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8853,"lastUser":{"userID":8853,"name":"Cindi Rella","url":"https:\/\/community.smartsheet.com\/profile\/Cindi%20Rella","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-26T13:02:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/6385\/due-date-is-past-due-checkbox","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6385\/due-date-is-past-due-checkbox","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"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}]},{"discussionID":6389,"type":"discussion","name":"LOOKUP & MATCH together","excerpt":"Hi everyone, I use a VLOOKUP and MATCH function in Excel to find the intersection of vertical and horizontal values (intersection of a matrix \/ table). I can't seem to get this working in Smartsheet and need some help. For example if I have Likelyhood = Likely and Impact = Moderate then I want the Criticality to return the…","categoryID":318,"dateInserted":"2016-10-26T20:52:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-10-27T18:30:15+00:00","insertUserID":8887,"insertUser":{"userID":8887,"name":"Brendon McHugh","url":"https:\/\/community.smartsheet.com\/profile\/Brendon%20McHugh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/1b\/9f\/n1b9f3f59bd8eb46f8df04a3bc60573c5.jpg","dateLastActive":"2019-08-14T21:16:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8887,"lastUser":{"userID":8887,"name":"Brendon McHugh","url":"https:\/\/community.smartsheet.com\/profile\/Brendon%20McHugh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/1b\/9f\/n1b9f3f59bd8eb46f8df04a3bc60573c5.jpg","dateLastActive":"2019-08-14T21:16:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":647,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/6389\/lookup-match-together","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6389\/lookup-match-together","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/5b\/a5\/5ba51ab3f42746c2b70a34ed22ecc0e0.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2016-10-27 at 13.49.59.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">