公式

\"Yes\"), but that gives me 0 ","categoryID":318,"dateInserted":"2016-09-14T10:23:43+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-11-07T15:44:08+00:00","insertUserID":6013,"insertUser":{"userID":6013,"name":"tobrien3","url":"https:\/\/community.smartsheet.com\/profile\/tobrien3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-08-10T13:20:10+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2022-07-30T13:41:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":3428,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/6061\/countif-no-or-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6061\/countif-no-or-blank","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":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":6462,"type":"discussion","name":"parent $1 less than the sum of its whole number children","excerpt":"Does anyone know why a parent would be $1 less than the sum of its whole number children?","categoryID":318,"dateInserted":"2016-11-03T20:59:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-11-07T11:59:09+00:00","insertUserID":6178,"insertUser":{"userID":6178,"name":"ctc","url":"https:\/\/community.smartsheet.com\/profile\/ctc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-17T16:53:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7492,"lastUser":{"userID":7492,"name":"Benjamin Walker","url":"https:\/\/community.smartsheet.com\/profile\/Benjamin%20Walker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/1b\/63\/n1b63b1a090b9e3d83ed5a30ad0e05b54.jpg","dateLastActive":"2020-01-27T20:40:59+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":1,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/6462\/parent-1-less-than-the-sum-of-its-whole-number-children","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6462\/parent-1-less-than-the-sum-of-its-whole-number-children","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":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":6452,"type":"discussion","name":"Descendants vs Children","excerpt":"How can formulas be run against all Descendants of a Parent row, rather than only direct Descendants (Children)? Example: =SUM(DESCENDANTS()) Thank you.","categoryID":318,"dateInserted":"2016-11-03T08:09:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-11-05T07:18:00+00:00","insertUserID":8704,"insertUser":{"userID":8704,"name":"Jason2","url":"https:\/\/community.smartsheet.com\/profile\/Jason2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-19T09:33:31+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":8704,"lastUser":{"userID":8704,"name":"Jason2","url":"https:\/\/community.smartsheet.com\/profile\/Jason2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-19T09:33:31+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":315,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/6452\/descendants-vs-children","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6452\/descendants-vs-children","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":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":6453,"type":"discussion","name":"Multiple dropdown list driven by previous choices","excerpt":"How would you set up a dropdown list that is driven by the selection in a previous list. Example: column one has ten property's to choose from, column two is a list of locations specific to the property that was chosen in column one. Chosing a different property in column one changes the list to choose from in column two.…","categoryID":318,"dateInserted":"2016-11-03T11:25:07+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-11-03T13:21:42+00:00","insertUserID":9009,"insertUser":{"userID":9009,"name":"Joe Costa","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Costa","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!gpVDZ4a3O4Q!YSlC2OLpUDo!kkYq8gXGXgl","dateLastActive":"2021-12-28T19:36:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/6453\/multiple-dropdown-list-driven-by-previous-choices","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6453\/multiple-dropdown-list-driven-by-previous-choices","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":218,"urlcode":"Construction","name":"Construction"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"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":6434,"type":"discussion","name":"countifs with specific data set and dates","excerpt":"I have a column with specific criteria (Sample type) and date column. I have another formula that looks specifically for a \"sample type\" and specific \"factory\". The formula I've used for this is: =COUNTIFS($Program$3:$Program$333, \"Fall Tabletop \/ Decor\", $[Sample Type]$3:$[Sample Type]$333, \"DEVELOPMENT + ARTBOARD\"). This…","categoryID":318,"dateInserted":"2016-11-01T15:07:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-11-02T16:11:43+00:00","insertUserID":8977,"insertUser":{"userID":8977,"name":"Kelli Lenz","url":"https:\/\/community.smartsheet.com\/profile\/Kelli%20Lenz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-07-24T10:47:35+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6434\/countifs-with-specific-data-set-and-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6434\/countifs-with-specific-data-set-and-dates","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":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":276,"urlcode":"Retail","name":"Retail"}],"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":6424,"type":"discussion","name":"RYG Ball Help!","excerpt":"I am driving myself crazy as I know I'm missing something really simple for this RYG formula. I have an actions completed column that could be anywhere from 0 to 100% complete based on 5 tasks that need to be completed. I have setup the RYG column with this formula below and it's not working. Please help me..what am I…","categoryID":318,"dateInserted":"2016-10-31T16:45:20+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-10-31T17:53:19+00:00","insertUserID":7721,"insertUser":{"userID":7721,"name":"Tony Davidson - SmartSheet Certified User 2016","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Davidson%20-%20SmartSheet%20Certified%20User%202016","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-23T15:04:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":7721,"lastUser":{"userID":7721,"name":"Tony Davidson - SmartSheet Certified User 2016","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Davidson%20-%20SmartSheet%20Certified%20User%202016","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-23T15:04:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":1,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/6424\/ryg-ball-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6424\/ryg-ball-help","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":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":6394,"type":"discussion","name":"Calculate % complete based upon start and end dates?","excerpt":"Hello, does anyone know how to calcuate the % complete for a project based upon it start and end date? I have projects where my resources are \"consulting\" and I'd like to have a way to see the % complete of the project when I roll it up in a project overview dashboard. I tried using the traditional \"yearfrac\" formula…","categoryID":318,"dateInserted":"2016-10-27T09:08:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-10-28T13:02:33+00:00","insertUserID":8666,"insertUser":{"userID":8666,"name":"Mike Hadddock","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Hadddock","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-20T14:32:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":118,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6394\/calculate-complete-based-upon-start-and-end-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6394\/calculate-complete-based-upon-start-and-end-dates","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":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"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}">