公式

= 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-16T17:26:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":139,"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-16T17:27:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":57,"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}]},{"discussionID":412,"type":"discussion","name":"Can we create a formula using a cell that has an IF statement in it?","excerpt":"I have a pretty long IF statement in a cell and want to use the results from that cell in a formula for another cell. The formula I am trying to create is VERY simple; 2 cells multiplied together. But I keep getting #INVALID. The only thing I can come up with is that it's not allowed to use the information that is…","categoryID":317,"dateInserted":"2015-05-29T13:45:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-13T15:52:30+00:00","insertUserID":1791,"insertUser":{"userID":1791,"name":"Bobko","url":"https:\/\/community.smartsheet.com\/profile\/Bobko","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-28T12:35:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":9959,"lastUser":{"userID":9959,"name":"PageDNA","url":"https:\/\/community.smartsheet.com\/profile\/PageDNA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-13T15:47:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":10,"countViews":282,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/412\/can-we-create-a-formula-using-a-cell-that-has-an-if-statement-in-it","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/412\/can-we-create-a-formula-using-a-cell-that-has-an-if-statement-in-it","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/ab\/a4\/aba48492b3ebf2802ce4aeb543582437.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SS Question Screen Shot.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"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":40936,"type":"discussion","name":"RYB Formula Help","excerpt":"I am having issues with developing a formula for an overall status. What I'm trying to do is based on multiple cell-status(RYB setup column) they will dictate what the overall status column of the project status is. Both columns have gray, red, yellow, and green balls. This is my current formula please help if you can.…","categoryID":322,"dateInserted":"2019-02-07T12:32:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-13T13:09:31+00:00","insertUserID":77701,"insertUser":{"userID":77701,"name":"joe.quinones","url":"https:\/\/community.smartsheet.com\/profile\/joe.quinones","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-08T14:01:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T21:50:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":77,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/40936\/ryb-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40936\/ryb-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":218,"urlcode":"Construction","name":"Construction"},{"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":19001,"type":"discussion","name":"Using OR in a SUMIFS or COUNTIFS Function","excerpt":"Hi Guys, Smartsheet noobie here and I was wondering if it is possible to use a OR in SUMIFS or COUNTIFS function. Basically I want to sum a count values in a particular columns if either one of 2 criterias a met in another column. My basic syntax is along the lines of: Sum all the values in column A, if column B has value…","categoryID":322,"dateInserted":"2018-02-07T00:48:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-13T11:52:46+00:00","insertUserID":37041,"insertUser":{"userID":37041,"name":"Atilla","url":"https:\/\/community.smartsheet.com\/profile\/Atilla","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-07T05:22:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":78406,"lastUser":{"userID":78406,"name":"Manuelf","url":"https:\/\/community.smartsheet.com\/profile\/Manuelf","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5ztbOZXmY3o!pEdZqdWBqTo!qaOxdBBTZ1M","dateLastActive":"2020-06-05T00:44:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":4545,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/19001\/using-or-in-a-sumifs-or-countifs-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/19001\/using-or-in-a-sumifs-or-countifs-function","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":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":41251,"type":"discussion","name":"Count Unique SME names","excerpt":"Hi. I have two columns SME #1 (Name) and SME #2 (Name) with names of subject-matter experts from rows 5 to 155. In many cases, one SME is assigned to more than one course (one course=1 row). I'd like to count the number of unique names in both columns. SME #1 (Name) | SME #2 (Name) Course 1 | Donald Duck | Course 2 |…","categoryID":322,"dateInserted":"2019-02-11T14:25:16+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-13T10:48:35+00:00","insertUserID":74206,"insertUser":{"userID":74206,"name":"Art Schneiderheinze","url":"https:\/\/community.smartsheet.com\/profile\/Art%20Schneiderheinze","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/PI7JNYDF7Q80\/nTL55D89VG7YK.png","dateLastActive":"2022-03-03T01:36:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T21:50:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":57,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/41251\/count-unique-sme-names","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/41251\/count-unique-sme-names","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":219,"urlcode":"Sheets","name":"Sheets"},{"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":41401,"type":"discussion","name":"Count number of checked in a sheet","excerpt":"Hi Could tou please help me to count the nuber og checked rows in a sheets without making parent, children rows?","categoryID":322,"dateInserted":"2019-02-13T08:38:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-13T09:10:34+00:00","insertUserID":78381,"insertUser":{"userID":78381,"name":"SmartStian","url":"https:\/\/community.smartsheet.com\/profile\/SmartStian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/d5\/9e\/nd59e40afbcbf4029d3d83ad12e26b36a.jpg","dateLastActive":"2019-02-13T08:46:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":78381,"lastUser":{"userID":78381,"name":"SmartStian","url":"https:\/\/community.smartsheet.com\/profile\/SmartStian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/d5\/9e\/nd59e40afbcbf4029d3d83ad12e26b36a.jpg","dateLastActive":"2019-02-13T08:46:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":148,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/41401\/count-number-of-checked-in-a-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/41401\/count-number-of-checked-in-a-sheet","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/08\/e2\/08e2a810042126e6ac9629388958e495.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheets - Count checked.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":218,"urlcode":"Construction","name":"Construction"},{"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":40781,"type":"discussion","name":"RYG Status based on Variance","excerpt":"Greetings, Does anyone know if there is a formula to automate RYG based on Variance? I am trying to track budget (not dates). I would like to show Red balls when a task is over budget. Any ideas on the formula? Thank you!","categoryID":322,"dateInserted":"2019-02-06T14:18:29+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-12T19:00:34+00:00","insertUserID":33226,"insertUser":{"userID":33226,"name":"ChristineD","url":"https:\/\/community.smartsheet.com\/profile\/ChristineD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!YeNPmAS0Tno!XBtPn2CaBvQ!PXeTkfkCl7U","dateLastActive":"2023-05-17T19:11:55+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-16T17:26:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":82,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/40781\/ryg-status-based-on-variance","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40781\/ryg-status-based-on-variance","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":238,"urlcode":"Finance","name":"Finance"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">