Formulas

TODAY() + 7, \"Future Task\", IF(AND([End Date]56 < TODAY() + 7, [End Date]56 > TODAY(), [% Complete]56 < 1), \"On Schedule\", IF(AND([End Date]56 < TODAY(), [% Complete]56 < 1), \"Late\", \"Complete\"))) The formula works to identify Future and Late tasks. How do I update the…","categoryID":322,"dateInserted":"2019-01-14T18:06:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-15T08:27:58+00:00","insertUserID":75066,"insertUser":{"userID":75066,"name":"PDS","url":"https:\/\/community.smartsheet.com\/profile\/PDS","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-14T17:46:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":75066,"lastUser":{"userID":75066,"name":"PDS","url":"https:\/\/community.smartsheet.com\/profile\/PDS","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-14T17:46:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":172,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/39001\/i-need-help-creating-a-formula-for-identifying-task-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39001\/i-need-help-creating-a-formula-for-identifying-task-status","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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}],"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":38956,"type":"discussion","name":"Collect Criteria not being filtered","excerpt":"My nested COLLECT function's Criteria does not appear to be working because the formula runs into errors when a duplicate date is found before the actual date that should be being pulled. =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task Complete Actual]128, [Milestone Type…","categoryID":322,"dateInserted":"2019-01-14T13:04:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-15T07:54:40+00:00","insertUserID":74936,"insertUser":{"userID":74936,"name":"RMRGSA","url":"https:\/\/community.smartsheet.com\/profile\/RMRGSA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-18T11:39:38+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":53,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/38956\/collect-criteria-not-being-filtered","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38956\/collect-criteria-not-being-filtered","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-01\/22\/7a\/227a3e5f348a599d246a8fce1141ec50.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Schedule Smartsheet.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":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"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}]},{"discussionID":14106,"type":"discussion","name":"Count Month from Date Value field","excerpt":"Hello. I have setup a JIRA extract to provide raw data on which to develop an operational dashboard. I need to be able to count 'closed this month' on the dashboard. I am getting a closed date for each row from JIRA and, since this is an automated extract feeding a live dashboard, creating another column to extract the…","categoryID":319,"dateInserted":"2017-09-27T18:51:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-14T15:13:36+00:00","insertUserID":10066,"insertUser":{"userID":10066,"name":"Sue Marmion","url":"https:\/\/community.smartsheet.com\/profile\/Sue%20Marmion","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-10-26T15:22:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":75041,"lastUser":{"userID":75041,"name":"Rgioff","url":"https:\/\/community.smartsheet.com\/profile\/Rgioff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-31T16:14:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":404,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/14106\/count-month-from-date-value-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14106\/count-month-from-date-value-field","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"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}]},{"discussionID":38791,"type":"discussion","name":"Helper Column Parents and Tasks with 0 Children","excerpt":"I am using this formula in a helper column to identify which of my rows are \"parents\" however I would also like to Identify Rows that are Projects or also \"Parents\", but have 0 children \" so that I can tag in conditional formatting along with my Parent Rows that have children. Can you help me create a formula that can do…","categoryID":322,"dateInserted":"2019-01-10T17:17:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-14T13:05:09+00:00","insertUserID":74816,"insertUser":{"userID":74816,"name":"dblasco","url":"https:\/\/community.smartsheet.com\/profile\/dblasco","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/8b\/db\/n8bdb300783c32dc5ae4f0fff329d15fb.jpg","dateLastActive":"2021-05-13T19:20: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":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":1115,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/38791\/helper-column-parents-and-tasks-with-0-children","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38791\/helper-column-parents-and-tasks-with-0-children","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-01\/43\/e6\/43e64f7b10f09990c5b0b847c1a63f82.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Example Parent 0 children.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":249,"urlcode":"education","name":"Education"},{"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":38461,"type":"discussion","name":"Find Value in List in Cell","excerpt":"I have two sheets---one with a list of program that includes rows with a cell that has a list of course prefixes. EXAMPLE: ROW 1--->Doe, John | doej@xx.com | BUS,CUL,MGT ROW 2--->Smith, Elle | smithe@xx.com | HOS,SUS Each row has three columns: name, e-mail address, and course code prefixes. On the second sheet, I want to…","categoryID":322,"dateInserted":"2019-01-06T21:02:47+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-14T11:35:52+00:00","insertUserID":74206,"insertUser":{"userID":74206,"name":"Art Schneiderheinze","url":"https:\/\/community.smartsheet.com\/profile\/Art%20Schneiderheinze","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/PI7JNYDF7Q80\/nTL55D89VG7YK.png","dateLastActive":"2022-03-03T01:36:25+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":15,"countViews":1170,"score":null,"hot":15,"url":"https:\/\/community.smartsheet.com\/discussion\/38461\/find-value-in-list-in-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38461\/find-value-in-list-in-cell","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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"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}]},{"discussionID":38736,"type":"discussion","name":"Creating formula in smartsheet","excerpt":"Hello, I have a requirement to calculate the remaining shelf life of products at the time of receiving in percentage. My formula is: (Production date + Expiry date) \/ (Expiry date - Delivery date). The end result should be a percentage. Can anyone help me to achieve this? Regards, Jasmine ","categoryID":322,"dateInserted":"2019-01-10T06:59:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-14T07:47:13+00:00","insertUserID":74326,"insertUser":{"userID":74326,"name":"Jasmine Hassan","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jasmine%20Hassan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/3c\/1a\/n3c1a132578a1de4409585de687ee2c25.jpg","dateLastActive":"2021-12-19T03:22:19+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":6,"countViews":62,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/38736\/creating-formula-in-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38736\/creating-formula-in-smartsheet","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":220,"urlcode":"hospitality","name":"Hospitality"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"}],"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":38921,"type":"discussion","name":"Time","excerpt":"Hi all Is anyone aware of any time functions is recent updates, I what to be about to calculate how minutes\/secs(don't mind either) from a system column also is there an hour or minute function in Smartsheet? thanks in advance ","categoryID":322,"dateInserted":"2019-01-14T05:58:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-14T06:05:23+00:00","insertUserID":9263,"insertUser":{"userID":9263,"name":"Andrew Henderson","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Henderson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-19T14:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"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-26T14:46:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":62,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/38921\/time","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38921\/time","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":254,"urlcode":"formulas","name":"Formulas"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"}],"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":14651,"type":"discussion","name":"Parent row based on children status and due date formula","excerpt":"Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that event. I have a column for Status with the options for Complete, Not Started, and In Progress. I want to create a new column…","categoryID":319,"dateInserted":"2017-10-10T11:44:11+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-11T15:29:29+00:00","insertUserID":25691,"insertUser":{"userID":25691,"name":"lhumphrey","url":"https:\/\/community.smartsheet.com\/profile\/lhumphrey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5_DB-Y7fHnQ!5HdAeVbvYrw!Xq-VVop8MvA","dateLastActive":"2020-05-05T16:09:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":74276,"lastUser":{"userID":74276,"name":"emily.pfeifer74276","url":"https:\/\/community.smartsheet.com\/profile\/emily.pfeifer74276","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-14T11:23:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":263,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/14651\/parent-row-based-on-children-status-and-due-date-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14651\/parent-row-based-on-children-status-and-due-date-formula","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":216,"urlcode":"non-profit","name":"Non-profit"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":279,"urlcode":"marketing","name":"Marketing"}],"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":38681,"type":"discussion","name":"Sumif if question","excerpt":"Hey folks, Working on a sheet to sum up if checkboxes are selected and running into an issue. The formula I have now is- =SUMIF(PRD50, 1) + IF(Stories50, 1) + IF(Assets50, 1) + IF(Wires50, 1) + IF(Comps50, 1) Each one of those are checkboxes and I want to tally them all up. Ideally, I'd like it to equal 100 since that…","categoryID":322,"dateInserted":"2019-01-09T16:02:55+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-11T08:02:50+00:00","insertUserID":56836,"insertUser":{"userID":56836,"name":"Steve Mount","url":"https:\/\/community.smartsheet.com\/profile\/Steve%20Mount","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-08\/d6\/2a\/nd62a237d86e1f1392ab5902deae39994.JPG","dateLastActive":"2019-04-10T19:34:40+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":9,"countViews":51,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/38681\/sumif-if-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38681\/sumif-if-question","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":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}">