公式

=1, return “Red” * If count of “Yellow”=1, return “Yellow” * If count of “Green”=8 (or all), return “Green”…","categoryID":322,"dateInserted":"2018-07-25T16:04:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-06T12:59:37+00:00","insertUserID":55691,"insertUser":{"userID":55691,"name":"jparada55691","url":"https:\/\/community.smartsheet.com\/profile\/jparada55691","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-06T12:58:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":55691,"lastUser":{"userID":55691,"name":"jparada55691","url":"https:\/\/community.smartsheet.com\/profile\/jparada55691","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-06T12:58:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":11077,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/29251\/nested-if-with-countif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29251\/nested-if-with-countif","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"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"}],"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":17026,"type":"discussion","name":"Best way to calculate stats on a sheet tracking form submissions","excerpt":"I have a SmartSheet that logs \"installation issues\" as they are submitted via web form. The sheet tracks the \"locations\" id number, address, owner, manager, issue, issue type, and who is working on the issue. Its a tracker you could say. I want to be able to calculate how many of \"issue type\" A or B have been submitted via…","categoryID":319,"dateInserted":"2017-12-20T10:11:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-06T10:57:58+00:00","insertUserID":33026,"insertUser":{"userID":33026,"name":"AAhumada","url":"https:\/\/community.smartsheet.com\/profile\/AAhumada","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-24T20:47:51+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-09T13:19:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":276,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/17026\/best-way-to-calculate-stats-on-a-sheet-tracking-form-submissions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/17026\/best-way-to-calculate-stats-on-a-sheet-tracking-form-submissions","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"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":29981,"type":"discussion","name":"Undo question","excerpt":"Hello, I was editing a formula and somehow the whole sheet appeared with the error #INVALID OPERATION. I was trying to undo the last change to reverse it, but the button wouldn't appear enable and the sheet was saved! I invested a lot of time ==(. Is there anyway to recover the previous version of my sheet? Thank you.","categoryID":322,"dateInserted":"2018-08-03T15:51:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-06T10:47:24+00:00","insertUserID":52036,"insertUser":{"userID":52036,"name":"Silvia C Rodriguez","url":"https:\/\/community.smartsheet.com\/profile\/Silvia%20C%20Rodriguez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-06\/75\/07\/n75074fa8c8313ee51a7894c722ba86a4.jpg","dateLastActive":"2022-03-06T15:45:55+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-09T13:19:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":1214,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/29981\/undo-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29981\/undo-question","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-08\/3d\/9d\/3d9df3c63cbb08ea3a0e0c97001978a3.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"undo.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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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}">