公式和函数

\"//www.santa-greenland.com/community/categories/formulas-and-functions/\" Survey Status = \"//www.santa-greenland.com/community/categories/formulas-and-functions/\" Assignment Status = Vendor Assigned Vendor Scheduling Late - requested update This is the current formula I have which is populating a quantity of 0 (Actual count should be 325. =COUNTIFS({Site Survey Stream},…","categoryID":322,"dateInserted":"2020-09-04T14:35:33+00:00","dateUpdated":null,"dateLastComment":"2020-09-09T13:51:43+00:00","insertUserID":117744,"insertUser":{"userID":117744,"name":"Sharon Castiglia","url":"https:\/\/community.smartsheet.com\/profile\/Sharon%20Castiglia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-15T22:08:02+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-02-27T19:39:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":61,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/71095\/countifs-using-cross-sheet-references","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71095\/countifs-using-cross-sheet-references","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-09T10:11:41+00:00","dateAnswered":"2020-09-04T15:43:31+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":71161,"type":"question","name":"Drop Down Menu Calculations","excerpt":"ive got multiple Drop down menu's with a Price im wanting to make it auto calculate it into a box next to it to give me a total price is this possible? https:\/\/gyazo.com\/55f00b79cd03c99eaa1502d7463d1a53","categoryID":322,"dateInserted":"2020-09-09T09:04:29+00:00","dateUpdated":null,"dateLastComment":"2020-09-09T12:47:27+00:00","insertUserID":125854,"insertUser":{"userID":125854,"name":"RHQ Souls","url":"https:\/\/community.smartsheet.com\/profile\/RHQ%20Souls","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiWTXDZUUxQysN5MpFURYZb55aKGomctaT4v05Dvw","dateLastActive":"2020-09-11T21:50:18+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-02-27T19:39:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":51,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/71161\/drop-down-menu-calculations","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71161\/drop-down-menu-calculations","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":71134,"type":"question","name":"HH:MM sum formula in Smartsheet","excerpt":"I have a series of times that our staff spend on a particular activity for a month in format HH:MM as shown below but I'm struggling with how to create a formula in smartsheet that allows me to sum these values are report the result in the format HH:MM too? Can anyone assist?","categoryID":322,"dateInserted":"2020-09-08T07:50:47+00:00","dateUpdated":null,"dateLastComment":"2020-09-09T12:40:37+00:00","insertUserID":124030,"insertUser":{"userID":124030,"name":"Tamara Diver","url":"https:\/\/community.smartsheet.com\/profile\/Tamara%20Diver","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XIvQHzxWDb4!u69XV8dFp3o!tbHG7ICpl_J","dateLastActive":"2021-10-26T01:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":122299,"lastUser":{"userID":122299,"name":"Stefan","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Stefan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nJVa34H1C4Q!HEtZnwWHg7o!c2eUa44FlAn","dateLastActive":"2023-02-27T21:43:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":131,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/71134\/hh-mm-sum-formula-in-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71134\/hh-mm-sum-formula-in-smartsheet","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/GAI7AS63SWAN\/hh-mm-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"HH MM.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"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":71140,"type":"question","name":"Referencing Content within a Cell","excerpt":"Hi there! I'm creating a set of formulas that will reference a sign up form. Since there is a lot of Wordy items to copy, I have created a reference column on my metrics page- is there a way to use my count if formula to reference the content in my Metric Reference Column to the column of the Sign Up Form? I've been trying…","categoryID":322,"dateInserted":"2020-09-08T16:26:50+00:00","dateUpdated":null,"dateLastComment":"2020-09-09T12:30:43+00:00","insertUserID":125148,"insertUser":{"userID":125148,"name":"Sarah_Ko","url":"https:\/\/community.smartsheet.com\/profile\/Sarah_Ko","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!gufBp37zNjw!pWlAaSLvrbo!oXhnxTMNJ3o","dateLastActive":"2021-10-23T00:01:30+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-02-27T19:39:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":121,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/71140\/referencing-content-within-a-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71140\/referencing-content-within-a-cell","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-09T10:04:49+00:00","dateAnswered":"2020-09-08T19:05:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":71053,"type":"question","name":"Date 'is between'?","excerpt":"Hi, I'm wondering what's the best way to capture dates that fall between Start Date and End Date. For instance, I'm using a COUNTIFS calculation which returns all rows with a Start Date of '>= 1\/1\/2021, and an End Date of '<= 31\/1\/2021, but that won't capture rows that start on 10\/12\/2020, and end on 2\/2\/2022; even though…","categoryID":322,"dateInserted":"2020-09-03T11:43:38+00:00","dateUpdated":null,"dateLastComment":"2020-09-09T12:30:10+00:00","insertUserID":102286,"insertUser":{"userID":102286,"name":"LisaB:-)","url":"https:\/\/community.smartsheet.com\/profile\/LisaB%3A-%29","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-09\/d6\/71\/nd67192aa8a486016e6be264cb81e0c20.jpg","dateLastActive":"2022-08-05T14:40: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":"2023-02-27T19:39:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":711,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/71053\/date-is-between","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71053\/date-is-between","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-04T14:00:53+00:00","dateAnswered":"2020-09-04T13:03:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":71154,"type":"question","name":"Formula to find how many requests a contact is assigned to","excerpt":"I have a sheet that tracks requests that come through a form. Each request then has a set of tasks that 3 teams need to complete. Within each request, there is 1-4 tasks that a contact can be assigned to. What formula can I use to show how many requests someone is assigned to? Right now I'm using a COUNTIF formula, but it…","categoryID":322,"dateInserted":"2020-09-08T21:27:38+00:00","dateUpdated":null,"dateLastComment":"2020-09-09T10:38:16+00:00","insertUserID":121348,"insertUser":{"userID":121348,"name":"Taylor Riley","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Taylor%20Riley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/699\/nFGTTYSMFCH0Z.jpg","dateLastActive":"2022-03-04T00:48:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-02-27T17:09:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":41,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/71154\/formula-to-find-how-many-requests-a-contact-is-assigned-to","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71154\/formula-to-find-how-many-requests-a-contact-is-assigned-to","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":71157,"type":"question","name":"How to show next occurrence? (Dates, Recurring meetings)","excerpt":"Hi all, It's early in the morning and I can't get my brain to figure this out. I have a number of different recurring meetings and I would like to generate a report that shows the next upcoming occurrence of each. So let's say data looks like this: I would like to generate a report that shows me something like: Board…","categoryID":322,"dateInserted":"2020-09-08T22:50:05+00:00","dateUpdated":null,"dateLastComment":"2020-09-09T10:28:49+00:00","insertUserID":118928,"insertUser":{"userID":118928,"name":"Liz Lomax","url":"https:\/\/community.smartsheet.com\/profile\/Liz%20Lomax","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-20T21:52:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":115578,"lastUser":{"userID":115578,"name":"David Joyeuse","url":"https:\/\/community.smartsheet.com\/profile\/David%20Joyeuse","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2021-08-19T14:05:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":91,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/71157\/how-to-show-next-occurrence-dates-recurring-meetings","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71157\/how-to-show-next-occurrence-dates-recurring-meetings","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/L4VXPP3915J3\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":69411,"type":"question","name":"Need assistance with collecting and then joining","excerpt":"Hello, I have a test master grid sheet where dates of leave (and different types of leave) are collected through a form. Formula used for collecting dates together is: =IF([End Date]@row <= [Start Date]@row, [Start Date]@row + \"//www.santa-greenland.com/community/categories/formulas-and-functions/\", JOIN([Start Date]@row:[End Date]@row, \" - \")) I have a 2nd sheet from which I want to collect…","categoryID":322,"dateInserted":"2020-06-25T17:09:33+00:00","dateUpdated":null,"dateLastComment":"2020-09-09T09:39:24+00:00","insertUserID":116417,"insertUser":{"userID":116417,"name":"Rebecca Panaccione","url":"https:\/\/community.smartsheet.com\/profile\/Rebecca%20Panaccione","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-27T22:05:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-02-27T17:09:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":161,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/69411\/need-assistance-with-collecting-and-then-joining","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69411\/need-assistance-with-collecting-and-then-joining","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/FC4JBDJ1VMO8\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-01T12:22:28+00:00","dateAnswered":"2020-06-29T06:41:21+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":71106,"type":"question","name":"Using countifs formula","excerpt":"Hello, I have used the COUNTIFS formula successfully in the past when pulling the status and date off a workspace. An example of the formula used is below: =COUNTIFS({Corrigo Work Orders Range 1}, \"Closed\", {Corrigo Work Orders Range 2}, AND(@cell >= DATE(2020, 4, 1), @cell <= DATE(2020, 6, 30))) However, I now need to be…","categoryID":322,"dateInserted":"2020-09-04T17:28:57+00:00","dateUpdated":"2020-09-06T12:28:43+00:00","dateLastComment":"2020-09-09T09:21:25+00:00","insertUserID":116231,"insertUser":{"userID":116231,"name":"Shane Cornwell","url":"https:\/\/community.smartsheet.com\/profile\/Shane%20Cornwell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-18T19:02:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-02-27T17:09:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":51,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/71106\/using-countifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71106\/using-countifs-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-08T18:23:47+00:00","dateAnswered":"2020-09-06T13:42:24+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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