Formulas and Functions

=DATE(2020, 4, 1)) to calculate the number of projects closed every month. When I compare the number that is calculated to the number of rows in the sheet that it is referenced, it doesn't match because everything that was closed after…","categoryID":322,"dateInserted":"2020-07-30T21:16:09+00:00","dateUpdated":"2020-07-30T21:20:45+00:00","dateLastComment":"2020-08-03T17:14:49+00:00","insertUserID":124713,"insertUser":{"userID":124713,"name":"Avery Rueckheim","url":"https:\/\/community.smartsheet.com\/profile\/Avery%20Rueckheim","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZQDAGe2tbuQ!7MNCO-VGRXQ!DFfKLNHcDHz","dateLastActive":"2020-11-20T19:14:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":124713,"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-07-12T21:24:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":103,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/70260\/does-anyone-know-why-the-countifs-function-used-with-a-date-range-stops-counting-things-done-at-7pm","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70260\/does-anyone-know-why-the-countifs-function-used-with-a-date-range-stops-counting-things-done-at-7pm","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-03T17:26:52+00:00","dateAnswered":"2020-07-31T12:32: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":70313,"type":"question","name":"SUM(IFERROR(INDEX(COLLECT(MATCH))))","excerpt":"I may have just the brackets wrong or overthinking this but I need to return the SUM of column 'eOEM' when the 'Date of report' column is in the next 7 days AND the 'transaction status' column is \"New\". The formula I have is =SUM(IFERROR(INDEX(eOEM:eOEM, COLLECT(MATCH(\"New\", [Transaction Status]:[Transaction Status],…","categoryID":322,"dateInserted":"2020-08-03T14:54:35+00:00","dateUpdated":"2020-08-03T15:47:28+00:00","dateLastComment":"2020-08-03T17:10:21+00:00","insertUserID":124774,"insertUser":{"userID":124774,"name":"Lara Homewood","url":"https:\/\/community.smartsheet.com\/profile\/Lara%20Homewood","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xHXf18-3_4!geHUoB9UDn4!o1g1OjX-nPp","dateLastActive":"2020-10-23T07:34:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":124774,"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-07-12T21:24:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":163,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70313\/sum-iferror-index-collect-match","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70313\/sum-iferror-index-collect-match","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-03T16:15:43+00:00","dateAnswered":"2020-08-03T16:01:33+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":70253,"type":"question","name":"What is wrong with my COUNTIF formula?","excerpt":"I am not sure what is wrong with my very simple formula... =COUNTIF(Quarter:Quarter, \"Q1\") I have a list of 700 line items and am trying to add formula to total up a count of programs 'by quarter' in sheet summary and keep getting #imparseable or #invalid data type (if I add \"quotes\" outside Q1) I am creating a new field…","categoryID":322,"dateInserted":"2020-07-30T16:58:38+00:00","dateUpdated":null,"dateLastComment":"2020-08-03T16:33:32+00:00","insertUserID":121314,"insertUser":{"userID":121314,"name":"Jo-Ann Turning","url":"https:\/\/community.smartsheet.com\/profile\/Jo-Ann%20Turning","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-10-18T16:34:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":121314,"lastUser":{"userID":121314,"name":"Jo-Ann Turning","url":"https:\/\/community.smartsheet.com\/profile\/Jo-Ann%20Turning","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-10-18T16:34:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":64,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/70253\/what-is-wrong-with-my-countif-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70253\/what-is-wrong-with-my-countif-formula","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/FW2X9I9UL9NP\/ss-q-capture-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SS Q capture.JPG"},"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":70314,"type":"question","name":"SUM and DIVISION","excerpt":"Can you check my formula for getting the % for the month It should be add 121-365 Days and Greater than 365 Days DIVIDED by Grand Total","categoryID":322,"dateInserted":"2020-08-03T14:57:40+00:00","dateUpdated":null,"dateLastComment":"2020-08-03T15:21:29+00:00","insertUserID":103391,"insertUser":{"userID":103391,"name":"Marilen.Navarro103391","url":"https:\/\/community.smartsheet.com\/profile\/Marilen.Navarro103391","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-09\/60\/88\/n6088a8f5166f388fd95cfcb413bcbd0e.jpg","dateLastActive":"2023-07-03T11:26:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":89971,"lastUser":{"userID":89971,"name":"MCorbin","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MCorbin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/80PUK21NFANO\/nKJOX5CKCTKS0.jpeg","dateLastActive":"2023-07-12T14:38:00+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers Alumni"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1185,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70314\/sum-and-division","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70314\/sum-and-division","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/YE7WEM8HKZ4I\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-06-09T09:15:12+00:00","dateAnswered":"2020-08-03T15:21:29+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":70300,"type":"question","name":"Multi Select Dropdown Witih Criteria pulled from Another Smartsheet","excerpt":"Hello! I am attempting to create a Smartsheet form. When a user completes the form they need to identify every account that will be impacted by the project associated with that form. How can we include a multi-select filed in the form, with which all accounts to select from are included in a separate smartsheet list? is it…","categoryID":322,"dateInserted":"2020-08-02T17:40:10+00:00","dateUpdated":null,"dateLastComment":"2020-08-03T14:40:37+00:00","insertUserID":119072,"insertUser":{"userID":119072,"name":"John Crick","url":"https:\/\/community.smartsheet.com\/profile\/John%20Crick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-27T19:17:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":119072,"lastUser":{"userID":119072,"name":"John Crick","url":"https:\/\/community.smartsheet.com\/profile\/John%20Crick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-27T19:17:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":72,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/70300\/multi-select-dropdown-witih-criteria-pulled-from-another-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70300\/multi-select-dropdown-witih-criteria-pulled-from-another-smartsheet","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":[{"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":70180,"type":"question","name":"Trigger Move Automation","excerpt":"I have a automation that is not being triggered, here's the setup: formula to number the time a value appears (1, 2, 3, 4, 5, etc) in the Duplicate column Move Row automation triggered when there are any add\/changes and Condition a. Duplicate is one of 2, 3, 4, 5 b. Duplicate is not 1 c. Duplicate is equal to or greater…","categoryID":322,"dateInserted":"2020-07-28T12:50:03+00:00","dateUpdated":null,"dateLastComment":"2020-08-03T12:58:54+00:00","insertUserID":13761,"insertUser":{"userID":13761,"name":"Gladys Liley","url":"https:\/\/community.smartsheet.com\/profile\/Gladys%20Liley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-26T20:37:07+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-07-12T21:24:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":92,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/70180\/trigger-move-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70180\/trigger-move-automation","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-03T12:48:16+00:00","dateAnswered":"2020-07-28T13:59:13+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":334,"urlcode":"automations","name":"Automations"}],"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":70303,"type":"question","name":"Creating a COUNTIFS formula to record number of quotes provided by a salesperson in a calendar month","excerpt":"Hello! When using COUNTIF formula in a summary sheet (referencing another sheet) to show number of jobs quoted per salesperson, as follows: =COUNTIF({ASSIGNED TO}, [Primary Column]6) ..... where Primary Column shows the name of the salesperson How would you write a COUNTIFS formula to read the Date Quoted column as well to…","categoryID":322,"dateInserted":"2020-08-03T01:36:25+00:00","dateUpdated":null,"dateLastComment":"2020-08-03T12:33:31+00:00","insertUserID":124766,"insertUser":{"userID":124766,"name":"Dale Caves","url":"https:\/\/community.smartsheet.com\/profile\/Dale%20Caves","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gjp3KBx3EQHSBbWghY0EQ0vRAGw_nQYP1s0gcPCfA","dateLastActive":"2020-08-19T08:45:12+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-07-12T21:24:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70303\/creating-a-countifs-formula-to-record-number-of-quotes-provided-by-a-salesperson-in-a-calendar-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70303\/creating-a-countifs-formula-to-record-number-of-quotes-provided-by-a-salesperson-in-a-calendar-month","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":70298,"type":"question","name":"Formula to cross reference data and compile into one sheet","excerpt":"Hello, I am needing to take data from one sheet and create a simplified version of it in another sheet. I have tried using MATCH & INDEX and VLookup formulas but none have seemed to work. Details on what I am specifically trying to do are below. Sheet number 1 has raw data in it extracted from a survey, this raw data is…","categoryID":322,"dateInserted":"2020-08-02T05:30:08+00:00","dateUpdated":"2020-08-03T08:39:31+00:00","dateLastComment":"2020-08-03T11:41:51+00:00","insertUserID":124743,"insertUser":{"userID":124743,"name":"Learning Team Group Alias","url":"https:\/\/community.smartsheet.com\/profile\/Learning%20Team%20Group%20Alias","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-31T19:24:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-07-12T20:38:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":61,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/70298\/formula-to-cross-reference-data-and-compile-into-one-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70298\/formula-to-cross-reference-data-and-compile-into-one-sheet","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":59591,"type":"discussion","name":"Count children rows by status","excerpt":"Hi - I have a sheet with parent rows and children rows. Each child row is associated with a status (Not Started, In Progress, and Complete). For each parent row, I'd like to count the number of child rows that are in each status. I need to present this information in a dashboard . Ideally I would create a separate summary…","categoryID":322,"dateInserted":"2019-10-07T18:12:55+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-08-03T08:39:13+00:00","insertUserID":106676,"insertUser":{"userID":106676,"name":"christy.thompson106676","url":"https:\/\/community.smartsheet.com\/profile\/christy.thompson106676","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5DdDudE3aLo!wxjCPwlBvzY!EfbfsMs4Qjn","dateLastActive":"2022-07-20T18:33:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112016,"lastUser":{"userID":112016,"name":"Phil Wightman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Phil%20Wightman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/35\/2e\/n352e0e53bf6c86b6f26b8d2be7cf0153.JPG","dateLastActive":"2023-07-04T02:38:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":1611,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/59591\/count-children-rows-by-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59591\/count-children-rows-by-status","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-10\/4c\/ff\/4cff2ccaf049ece5437f7e421f75c45c.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen shot.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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources