公式与函数

TODAY()), \"Red\", IF(AND([% Complete]25 < \"1\", [End Date]25 = TODAY()), \"Yellow\"), IF(AND([% Complete]25 = \"1\", [End Date]25 = TODAY()), \"Green\")) Essentially I want to…","categoryID":322,"dateInserted":"2020-02-26T14:15:48+00:00","dateUpdated":null,"dateLastComment":"2020-02-26T18:53:59+00:00","insertUserID":118988,"insertUser":{"userID":118988,"name":"Sy Gibbs","url":"https:\/\/community.smartsheet.com\/profile\/Sy%20Gibbs","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-03-04T16:26:56+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-12-09T19:26:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":101,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/66299\/need-some-assistance-on-using-if-and-logic-im-trying-to-render-a-red-yellow-or-green","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66299\/need-some-assistance-on-using-if-and-logic-im-trying-to-render-a-red-yellow-or-green","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-26T19:00:00+00:00","dateAnswered":"2020-02-26T18:53:59+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":66255,"type":"question","name":"How do you write a SUMIFS forumula with 3 criteria?","excerpt":"Below is my formula, but I am not getting it right: =SUMIFS({2020 OE Revenue Actual & Projected Range 1}, {2020 OE Revenue Actual & Projected Range 2}, \"New Business\", [({2020 OE Revenue Actual & Projected Range 3}, >12\/31\/19), ({2020 OE Revenue Actual & Projected Range 3}, < 02\/01\/20)])","categoryID":322,"dateInserted":"2020-02-25T09:41:34+00:00","dateUpdated":null,"dateLastComment":"2020-02-26T18:06:07+00:00","insertUserID":118511,"insertUser":{"userID":118511,"name":"Lisa Burgess","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Burgess","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nZlbn7ApE7w!DPlbA2Qyxjo!00txfvabet5","dateLastActive":"2020-02-26T17:15:49+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-12-09T19:26:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":36,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/66255\/how-do-you-write-a-sumifs-forumula-with-3-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66255\/how-do-you-write-a-sumifs-forumula-with-3-criteria","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-26T17:37:43+00:00","dateAnswered":"2020-02-25T18:58:58+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":66249,"type":"question","name":"New Help on If\/AND to amortize contract revenue","excerpt":"Below are my cells and formula which keeps returning INVALID:","categoryID":322,"dateInserted":"2020-02-25T08:52:51+00:00","dateUpdated":null,"dateLastComment":"2020-02-26T18:05:44+00:00","insertUserID":118511,"insertUser":{"userID":118511,"name":"Lisa Burgess","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Burgess","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nZlbn7ApE7w!DPlbA2Qyxjo!00txfvabet5","dateLastActive":"2020-02-26T17:15:49+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-12-09T19:26:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/66249\/new-help-on-if-and-to-amortize-contract-revenue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66249\/new-help-on-if-and-to-amortize-contract-revenue","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/005\/P93KDRXB6I0I.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":62966,"type":"question","name":"changing email address in contact list (web formular)","excerpt":"Hi everybody, I use a contact list in a web formular. Unfortunately, it is not possible to write a new email address into the drop down list which is not yet included in the list. It simply disappears after writing it + Enter. Is there a way to do so? greetings Joerg ","categoryID":322,"dateInserted":"2019-11-15T02:41:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-02-26T16:10:33+00:00","insertUserID":107466,"insertUser":{"userID":107466,"name":"Joerg Schmidt","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Joerg%20Schmidt","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZFNXGZNkaTw!pKDXaa84r-Y!9WSWmAUhJKN","dateLastActive":"2022-11-28T12:15:48+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\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-09T16:26:03+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":38,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/62966\/changing-email-address-in-contact-list-web-formular","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62966\/changing-email-address-in-contact-list-web-formular","format":"Html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-03T13:58:13+00:00","dateAnswered":"2019-11-18T09:18:04+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":[{"tagID":220,"urlcode":"Hospitality","name":"Hospitality"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"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":66246,"type":"question","name":"how to count the total of a checkbox field?","excerpt":"I need to count the total no. of check marked cells in a column","categoryID":322,"dateInserted":"2020-02-25T00:01:26+00:00","dateUpdated":null,"dateLastComment":"2020-02-26T14:51:32+00:00","insertUserID":118932,"insertUser":{"userID":118932,"name":"Megha Natani","url":"https:\/\/community.smartsheet.com\/profile\/Megha%20Natani","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-25T23:42:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":86866,"lastUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2022-12-01T21:07:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":45,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/66246\/how-to-count-the-total-of-a-checkbox-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66246\/how-to-count-the-total-of-a-checkbox-field","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":66235,"type":"question","name":"Getting Oldest Date based on another field","excerpt":"I have created a Metrics Sheet to roll up the oldest date based on another field. I am trying to have it return the oldest date in the \"Date Sent to CSOS\" column if the Date approved by CSOS column is blank. I can also use the if CSOS Review column is Submitted but I can't get either one to work properly. Does anyone have…","categoryID":322,"dateInserted":"2020-02-24T18:27:45+00:00","dateUpdated":null,"dateLastComment":"2020-02-26T14:09:42+00:00","insertUserID":115851,"insertUser":{"userID":115851,"name":"Kristie Diersen","url":"https:\/\/community.smartsheet.com\/profile\/Kristie%20Diersen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T16:55:42+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-12-09T19:26:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":407,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/66235\/getting-oldest-date-based-on-another-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66235\/getting-oldest-date-based-on-another-field","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/034\/QTN1TX7I3XEB.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-26T13:57:21+00:00","dateAnswered":"2020-02-26T13:31:03+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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":66239,"type":"question","name":"COUNTIF and AND formulas","excerpt":"Need to count a number of times a date is less than or equal to a specific date and equal to a value in another column For example, I have a column \"Schedule Status\" that is a drop down with either \"Completed\" or \"Scheduled\" as choices. I also have a column for start date. I want to calculate how many dates are less than…","categoryID":322,"dateInserted":"2020-02-24T19:50:24+00:00","dateUpdated":null,"dateLastComment":"2020-02-26T14:04:56+00:00","insertUserID":118916,"insertUser":{"userID":118916,"name":"Shawnob1","url":"https:\/\/community.smartsheet.com\/profile\/Shawnob1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-06-26T10:55:14+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-12-09T19:26:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":45,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/66239\/countif-and-and-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66239\/countif-and-and-formulas","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-26T14:07:40+00:00","dateAnswered":"2020-02-26T13:07:45+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":66283,"type":"question","name":"Filter children excluding top summary rows","excerpt":"Is there a way to filter children rows using the green, red and blue balls, excluding the summary rows using above the parent row using the filter feature? Every time I use the filter feature in the Sheet it filters all rows even if I lock the top summary rows.","categoryID":322,"dateInserted":"2020-02-25T22:41:27+00:00","dateUpdated":null,"dateLastComment":"2020-02-26T14:01:28+00:00","insertUserID":118831,"insertUser":{"userID":118831,"name":"Noelle Nordstrom","url":"https:\/\/community.smartsheet.com\/profile\/Noelle%20Nordstrom","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nmvCHzk9lL4!!_GBXVDrWwY9","dateLastActive":"2021-05-06T17:50:57+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-12-09T19:26:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":71,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/66283\/filter-children-excluding-top-summary-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66283\/filter-children-excluding-top-summary-rows","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-03-15T14:15:27+00:00","dateAnswered":"2020-02-26T14:01:28+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":65979,"type":"question","name":"Rollup summary of data","excerpt":"This is probably a very simple formula required but I am struggling with it. Can somebody please assist? We have a number of clients on one sheet where we track different trades budget vs. actual for each client. e.g. Plumbing, Electrical, Carpentry etc. We want to count up all the budgets for the Plumbing for all clients…","categoryID":322,"dateInserted":"2020-02-13T06:35:53+00:00","dateUpdated":null,"dateLastComment":"2020-02-26T13:52:27+00:00","insertUserID":50121,"insertUser":{"userID":50121,"name":"TeeM","url":"https:\/\/community.smartsheet.com\/profile\/TeeM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uvjAJ2oCliY!!vo_hC89_e4s","dateLastActive":"2022-10-27T04:39:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-12-11T19:26:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":287,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/65979\/rollup-summary-of-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65979\/rollup-summary-of-data","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-13T22:51:57+00:00","dateAnswered":"2020-02-13T07:03:30+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":[{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":320,"urlcode":"department","name":"department"}],"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