公式

= 0.9, \"Green\", IF([Proj. Blended Average]4 >= 0.76, \"Yellow\", IF([Proj. Blended Average]4 <= 0.75, \"Red\"))) However, I am struggling to find a…","categoryID":322,"dateInserted":"2019-02-13T17:56:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-14T15:11:33+00:00","insertUserID":78486,"insertUser":{"userID":78486,"name":"kglessner","url":"https:\/\/community.smartsheet.com\/profile\/kglessner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-13T17:36:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-06-13T17:24:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":138,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/41501\/nested-if-formula-with-blank-cell-condition","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/41501\/nested-if-formula-with-blank-cell-condition","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/da\/7a\/da7a94d51b87e4392f85d60b731f2911.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2019-02-13 at 5.48.39 PM.png"},"attributes":{},"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":41571,"type":"discussion","name":"Formula help","excerpt":"Hello everyone I hope you are doing great. I need help with creating a formula for the following. I have a drop-down list, with two items, Zakat and Tax. I want to able to if I choose Zakat from the column A, column B prints today's date plus 90, and if I choose Tax it prints today's date plus 60 Thanks for your help ","categoryID":322,"dateInserted":"2019-02-14T11:34:16+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-14T13:11:38+00:00","insertUserID":33181,"insertUser":{"userID":33181,"name":"oakhayat","url":"https:\/\/community.smartsheet.com\/profile\/oakhayat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-14T11:28:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","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-06-15T15:29:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":56,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/41571\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/41571\/formula-help","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":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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">