functionality

[Due Date]43, \"1\", \"0\") There are two children rows; the formula above creates a 1 and a 0 respectively, however, my =SUM(CHILDREN()) formula…","categoryID":322,"dateInserted":"2020-03-11T16:26:59+00:00","dateUpdated":"2020-03-11T16:44:33+00:00","dateLastComment":"2020-03-11T18:40:18+00:00","insertUserID":7105,"insertUser":{"userID":7105,"name":"Laurie Bearden","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laurie%20Bearden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/001\/nT12MT79U1BCE.jpg","dateLastActive":"2023-05-04T17:46:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":7105,"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-08-23T01:18:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":203,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/66632\/sum-children-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66632\/sum-children-formula","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-11T18:38:37+00:00","dateAnswered":"2020-03-11T18:01:23+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":66624,"type":"question","name":"Email recipients from automation","excerpt":"Is there a way to view the recipients of automation email when you have Editor access to a sheet?","categoryID":321,"dateInserted":"2020-03-11T14:25:22+00:00","dateUpdated":null,"dateLastComment":"2020-03-11T15:51:10+00:00","insertUserID":115011,"insertUser":{"userID":115011,"name":"Dale Heincelman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Dale%20Heincelman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-14T17:53:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":115011,"lastUser":{"userID":115011,"name":"Dale Heincelman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Dale%20Heincelman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-14T17:53:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":83,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/66624\/email-recipients-from-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66624\/email-recipients-from-automation","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-11T15:51:12+00:00","dateAnswered":"2020-03-11T15:49:04+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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":66623,"type":"question","name":"Advice: Looking to create a Global Onboarding SmartSheet","excerpt":"Currently our organization uses 3 separate sheets (one for each region) to track the status of onboarding our new hires. We capture things like: New Hire's Name, Start Date, who the offer letter was assigned to, when the OL was created, Drug Screen information, Background check information, etc. I would like to combine all…","categoryID":343,"dateInserted":"2020-03-11T14:12:10+00:00","dateUpdated":"2022-06-14T14:36:50+00:00","dateLastComment":"2020-03-11T14:20:13+00:00","insertUserID":119027,"insertUser":{"userID":119027,"name":"Stephanie Bauder","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Bauder","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-02-16T17:27:58+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-08-22T19:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":83,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/66623\/advice-looking-to-create-a-global-onboarding-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66623\/advice-looking-to-create-a-global-onboarding-smartsheet","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[{"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":66330,"type":"question","name":"sort in report","excerpt":"i have a repotr based on sheet with ~1500 rows (parents and children). as i know there is no way to show the parent and children in repost so that i mark in color the parent and sort the report to show the parent and children. but, now i want to sort with another level: i want to show in report the parents row and…","categoryID":321,"dateInserted":"2020-02-27T10:37:46+00:00","dateUpdated":"2020-02-27T10:40:06+00:00","dateLastComment":"2020-03-11T13:33:24+00:00","insertUserID":109836,"insertUser":{"userID":109836,"name":"Netanel yosef","url":"https:\/\/community.smartsheet.com\/profile\/Netanel%20yosef","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T10:54:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":109836,"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-08-23T01:18:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":148,"score":null,"hot":12,"url":"https:\/\/community.smartsheet.com\/discussion\/66330\/sort-in-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66330\/sort-in-report","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/375\/GAHUD9BF0U1Y.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Annotation 2020-02-27 123938.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-03T13:25:43+00:00","dateAnswered":"2020-03-03T13:21:10+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"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":66606,"type":"question","name":"Counting open tickets based on company name and ticket status","excerpt":"Hi, I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far: =IF({Maintenance tracking Sheet Range 2} = [Company Name]@row, COUNTIF({Maintenance tracking Sheet Range 3}, {Maintenance tracking Sheet Range 3} = \"Open\")) But I'm getting an…","categoryID":322,"dateInserted":"2020-03-10T21:19:21+00:00","dateUpdated":null,"dateLastComment":"2020-03-11T12:02:08+00:00","insertUserID":118367,"insertUser":{"userID":118367,"name":"Nick Winkley","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Winkley","photoUrl":"https:\/\/lh6.googleusercontent.com\/-5yVzAyCaegQ\/AAAAAAAAAAI\/AAAAAAAAAAA\/ACHi3rd1PsWOZnTUxwjhgD-7sy3evMWeVA\/photo.jpg","dateLastActive":"2020-05-30T01:43:06+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-08-23T01:18:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":129,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/66606\/counting-open-tickets-based-on-company-name-and-ticket-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66606\/counting-open-tickets-based-on-company-name-and-ticket-status","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-16T17:04:46+00:00","dateAnswered":"2020-03-11T12:02:08+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"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}">