公式和函数

0)) For example, one row has…","categoryID":322,"dateInserted":"2019-04-18T11:49:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-07T12:50:23+00:00","insertUserID":84011,"insertUser":{"userID":84011,"name":"pixel_","url":"https:\/\/community.smartsheet.com\/profile\/pixel_","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-03-26T18:41:48+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":"2022-10-06T23:10:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":148,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/46196\/countif-is-double-counting-rows-with-multiple-assigned-contacts","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/46196\/countif-is-double-counting-rows-with-multiple-assigned-contacts","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":228,"urlcode":"Project Management","name":"Project Management"},{"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":54551,"type":"discussion","name":"Need tip for nested formula using IF, AND, and ISBLANK","excerpt":"I have a schedule template with columns for At Risk (red flag on or off), Status (Not Started, In Progress, Complete), and Risk Reason (is it at risk because of Late Start or Late End, or else blank if the flag is off). Here is the Risk Reason we're currently using: =IF(AND([At Risk]@row = 1, Status@row = \"Not Started\"),…","categoryID":322,"dateInserted":"2019-08-07T10:25:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-07T11:27:21+00:00","insertUserID":76406,"insertUser":{"userID":76406,"name":"victoria.anzalone76406","url":"https:\/\/community.smartsheet.com\/profile\/victoria.anzalone76406","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xZ1ZMYGn8sQ!BzfVQf364L4!yNDINO-dis_","dateLastActive":"2022-03-03T21:04:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":76406,"lastUser":{"userID":76406,"name":"victoria.anzalone76406","url":"https:\/\/community.smartsheet.com\/profile\/victoria.anzalone76406","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xZ1ZMYGn8sQ!BzfVQf364L4!yNDINO-dis_","dateLastActive":"2022-03-03T21:04:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":33,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/54551\/need-tip-for-nested-formula-using-if-and-and-isblank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54551\/need-tip-for-nested-formula-using-if-and-and-isblank","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/4f\/71\/4f7176b59d679bd3e336d2359867be56.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Current formula.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":54461,"type":"discussion","name":"Combining 2 Formulas","excerpt":"Hi There! I have 2 formulas that I would like to combine together. They both work independently, but i can't seem to figure out how to combine them. Formula 1: =IF(OR([Phase Health]3 = \"Red\", [Phase Health]3 = \"Yellow\"), \"Yellow\") Formula 2: =IF((((COUNTIFS(CHILDREN(Status@row), OR(@cell = \"Not Started\", @cell = \"In…","categoryID":322,"dateInserted":"2019-08-06T09:39:16+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-07T11:17:21+00:00","insertUserID":89576,"insertUser":{"userID":89576,"name":"chadedwardconway","url":"https:\/\/community.smartsheet.com\/profile\/chadedwardconway","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-11T13:35:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":52131,"lastUser":{"userID":52131,"name":"Lee Joramo","url":"https:\/\/community.smartsheet.com\/profile\/Lee%20Joramo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-03\/84\/d4\/n84d4d5e3d909b0164c8e3ad8f8e5c934.jpg","dateLastActive":"2022-09-30T17:02:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":363,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/54461\/combining-2-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54461\/combining-2-formulas","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":54546,"type":"discussion","name":"SUMIF Formula question","excerpt":"Hello, I am attempting to create a formula that calculates the sum of the Actual Savings column, if the non-applicable column is not checked. The formula I am using is =SUMIF(CHILDREN([Non DH Applicable?]@row), 1 + \"//www.santa-greenland.com/community/categories/formulas-and-functions/\"). Not sure why it isn't calculating correctly. ","categoryID":322,"dateInserted":"2019-08-07T08:57:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-07T10:24:56+00:00","insertUserID":51391,"insertUser":{"userID":51391,"name":"Katye Reed","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Katye%20Reed","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/47\/e4\/n47e417a625675c0c55a8e9a3eb9c663a.jpg","dateLastActive":"2021-10-27T20:01:55+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":"2022-10-06T23:10:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":28,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/54546\/sumif-formula-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54546\/sumif-formula-question","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/77\/83\/778306ca869ee04341fa95365a6e4816.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SUMIF.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":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"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":54376,"type":"discussion","name":"Formula to return data from last row of a sheet of data","excerpt":"I am working on a dashboard and I'm using a intermediate sheet to collect data from other sheets of data. Typically the data is entered in each day so I was able to have the formula for most cells to look at the referenced sheet and return the value for the row of data by date =SUMIFS({Incidents YTD}, {Yesterday}, \"1\").…","categoryID":322,"dateInserted":"2019-08-05T12:37:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-07T09:05:28+00:00","insertUserID":76066,"insertUser":{"userID":76066,"name":"Jed Rusyniak","url":"https:\/\/community.smartsheet.com\/profile\/Jed%20Rusyniak","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-07\/ee\/78\/nee7870baf1e5832258cc68ae70eb674a.JPG","dateLastActive":"2022-08-19T12:30:34+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":"2022-10-06T23:10:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":296,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/54376\/formula-to-return-data-from-last-row-of-a-sheet-of-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54376\/formula-to-return-data-from-last-row-of-a-sheet-of-data","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":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"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":54396,"type":"discussion","name":"Contact List column allows multiple entries - using in formula","excerpt":"I am trying to obtain the number of tasks with a status of \"Red\" by assigned user. The author column only had one individual assigned and the formula =COUNTIFS(Author:Author, =\"Jane Doe\", Status:Status, =\"Red\") returned precisely what I needed. I'm trying to replicate the results for the contributors. However, in many…","categoryID":322,"dateInserted":"2019-08-05T13:47:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-07T09:01:59+00:00","insertUserID":98776,"insertUser":{"userID":98776,"name":"caw98776","url":"https:\/\/community.smartsheet.com\/profile\/caw98776","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-08T18:39:35+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":"2022-10-06T23:10:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":241,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/54396\/contact-list-column-allows-multiple-entries-using-in-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54396\/contact-list-column-allows-multiple-entries-using-in-formula","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":54406,"type":"discussion","name":"Phase of Work Formula","excerpt":"Hello Community- I am looking for help with a formula to tell me what phase of work the project is in. The formula will be looking at 5 checkboxes in columns. If I complete the last checkbox in the first phase, but have not completed the last 2nd phase checkbox, I would like the column \"Project Phase\" to return the 2nd…","categoryID":322,"dateInserted":"2019-08-05T14:16:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-08-07T08:56:50+00:00","insertUserID":32451,"insertUser":{"userID":32451,"name":"Jim Schaffhausen","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20Schaffhausen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/ab\/64\/nab64ad25a69c4c87f61191e3d6dcb601.JPG","dateLastActive":"2020-01-14T17:32:23+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":"2022-10-06T23:10:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":99,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/54406\/phase-of-work-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54406\/phase-of-work-formula","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/32\/d0\/32d060395b4c58662d0828814fbc9bd3.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet Phases.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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"}],"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}">

帮助文章参考资料欧宝体育app官方888