Sales

>> =SUMIF(CHILDREN([Sales Stage]30); Status15; CHILDREN([Quotation budget]30)). However for some reason this function wont work passed row 40. Please help. Jesse","categoryID":321,"dateInserted":"2019-02-14T08:39:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-15T09:35:22+00:00","insertUserID":78541,"insertUser":{"userID":78541,"name":"Jesse Zee","url":"https:\/\/community.smartsheet.com\/profile\/Jesse%20Zee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-14T08:32: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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":62,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/41551\/children-function-wont-work-past-a-certain-rownumber","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/41551\/children-function-wont-work-past-a-certain-rownumber","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/1c\/28\/1c28fa7737cd9f56fa20f1f0430a4651.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Doc1-page-001.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"sales","name":"Sales"},{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User Management"}],"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":19001,"type":"discussion","name":"Using OR in a SUMIFS or COUNTIFS Function","excerpt":"Hi Guys, Smartsheet noobie here and I was wondering if it is possible to use a OR in SUMIFS or COUNTIFS function. Basically I want to sum a count values in a particular columns if either one of 2 criterias a met in another column. My basic syntax is along the lines of: Sum all the values in column A, if column B has value…","categoryID":322,"dateInserted":"2018-02-07T00:48:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-13T11:52:46+00:00","insertUserID":37041,"insertUser":{"userID":37041,"name":"Atilla","url":"https:\/\/community.smartsheet.com\/profile\/Atilla","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-07T05:22:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":78406,"lastUser":{"userID":78406,"name":"Manuelf","url":"https:\/\/community.smartsheet.com\/profile\/Manuelf","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5ztbOZXmY3o!pEdZqdWBqTo!qaOxdBBTZ1M","dateLastActive":"2020-06-05T00:44:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":4832,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/19001\/using-or-in-a-sumifs-or-countifs-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/19001\/using-or-in-a-sumifs-or-countifs-function","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":207,"urlcode":"sales","name":"Sales"},{"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":40461,"type":"discussion","name":"NESTED IF FORMULA WITH PARENT\/CHILD ROWS","excerpt":"Hi everyone, I am struggling with a formula to populate a parent row, as either \"On Track\" or \"Off Track\". This is dependent on how the child row compares to the \"Weekly Goal\". The formula I am trying to use is shown below but, Im doing something wrong. (screen shot of sheet also attached) =(IF(CHILDREN([January (Week…","categoryID":322,"dateInserted":"2019-02-01T22:02:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-06T10:06:16+00:00","insertUserID":44871,"insertUser":{"userID":44871,"name":"lisarae723","url":"https:\/\/community.smartsheet.com\/profile\/lisarae723","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-18T19: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":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":194,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/40461\/nested-if-formula-with-parent-child-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40461\/nested-if-formula-with-parent-child-rows","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/b3\/8b\/b38b45efd6daa377836c136d0844657e.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"On Track - Off Track.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":207,"urlcode":"sales","name":"Sales"},{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":40536,"type":"discussion","name":"How can I display a date range based on week\/month numbers?","excerpt":" Here's the situation: I have a bar chart on a dashboard that displays the dollar value of bids submitted by week going back the last five weeks and another for the last five months to help the estimating team track where we are on meeting goals. At the moment the labels under the bars are Last Week, 2 Weeks Ago, etc.…","categoryID":322,"dateInserted":"2019-02-04T11:45:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-05T15:10:17+00:00","insertUserID":50586,"insertUser":{"userID":50586,"name":"Joshua Fargason","url":"https:\/\/community.smartsheet.com\/profile\/Joshua%20Fargason","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-06\/0b\/66\/n0b66755f80fd30b6d29d5dcb88c63397.jpg","dateLastActive":"2020-02-12T16:00:53+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":652,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/40536\/how-can-i-display-a-date-range-based-on-week-month-numbers","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40536\/how-can-i-display-a-date-range-based-on-week-month-numbers","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/ca\/90\/ca902523ea6505329e010dd2c407206d.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Graphs example.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":207,"urlcode":"sales","name":"Sales"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}">