Formulas and Functions

TODAY(-31)) \/ COUNTIFS(Name1:Name14, \"Happy\", Date1:Date14, >TODAY(-31)) Basically the following critera: *…","categoryID":322,"dateInserted":"2019-05-31T15:04:10+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-31T15:59:43+00:00","insertUserID":65666,"insertUser":{"userID":65666,"name":"Nick Burrus","title":"BPO Manager at Ubeo","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Burrus","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-06\/96\/c3\/n96c3f5b3cc2da8516071bbb72fe405b6.JPG","dateLastActive":"2023-08-25T21:31:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+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\/49546\/problem-with-sumifs-second-critera-based-upon-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49546\/problem-with-sumifs-second-critera-based-upon-date","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}]},{"discussionID":49391,"type":"discussion","name":"Sumif Formula","excerpt":"Hi, I'm having problem with my formula below. If I update the column 2 to reference \"Amount Invoiced\", it automatically change the formula in Column 1 to \"AmountInvoiced\". I need Column 1 to only reference PO Amount and not Amount Invoiced. See below sample formula that I input on the sheet. Column 1 =SUMIF({FY19 MASTER PO…","categoryID":322,"dateInserted":"2019-05-30T10:23:25+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-31T08:15:34+00:00","insertUserID":84246,"insertUser":{"userID":84246,"name":"kkeung84246","url":"https:\/\/community.smartsheet.com\/profile\/kkeung84246","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-05-30T12:43:44+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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":63,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/49391\/sumif-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49391\/sumif-formula","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-05\/9f\/ad\/9fad0bc36cad58d06207aec9f69b6f98.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Sumif Formula capture.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"},{"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":49431,"type":"discussion","name":"How to put together two formulas to account for blanks","excerpt":"Hello, I have this formula to add 10 days to a date: =[Date1]@row + 10 Then I have this formula to leave blank if there is no date: =IF(ISBLANK([Date1]@row), \"//www.santa-greenland.com/community/categories/formulas-and-functions/\") I need to put them together so if there is a blank the cell stays blank but if not then it needs to add 10 days to the date in [Date1]@row. Thank you! ","categoryID":322,"dateInserted":"2019-05-30T13:30:25+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-30T16:27:59+00:00","insertUserID":40981,"insertUser":{"userID":40981,"name":"Lisi","url":"https:\/\/community.smartsheet.com\/profile\/Lisi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-07T11:34:42+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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/49431\/how-to-put-together-two-formulas-to-account-for-blanks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49431\/how-to-put-together-two-formulas-to-account-for-blanks","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":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":49286,"type":"discussion","name":"How to tell if Multiple Invoices have all been processed","excerpt":"I've created a sheet that we use to track our projects. For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks are sent out to our partners there is a column that indicates the date the invoice processing is complete. I've created a…","categoryID":322,"dateInserted":"2019-05-29T12:02:34+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-30T15:18:50+00:00","insertUserID":90331,"insertUser":{"userID":90331,"name":"adamacantwell","url":"https:\/\/community.smartsheet.com\/profile\/adamacantwell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-05-29T11:47: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":"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":107,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/49286\/how-to-tell-if-multiple-invoices-have-all-been-processed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49286\/how-to-tell-if-multiple-invoices-have-all-been-processed","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-05\/4e\/b6\/4eb6eadd10d7f3e3b382d1e6acba7963.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SmartSheet Columns.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":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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":49371,"type":"discussion","name":"Return value if one condition is met","excerpt":"Good Morning, I am trying this formula within my sheet in a brand new column: =IF([Planned Start Date]@row - 21 <= TODAY(), [Estimated Hours Number]@row, \"//www.santa-greenland.com/community/categories/formulas-and-functions/\") For this column, if someone put a date that falls between today and three weeks from today, to return the job site hours that is found in the column Estimated Hours…","categoryID":322,"dateInserted":"2019-05-30T08:53:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-30T15:04:02+00:00","insertUserID":75361,"insertUser":{"userID":75361,"name":"Veronica J","url":"https:\/\/community.smartsheet.com\/profile\/Veronica%20J","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/5c\/cf\/n5ccffce1bb936d05740c1fcc057d5383.jpg","dateLastActive":"2019-08-15T10:51:18+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":1356,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/49371\/return-value-if-one-condition-is-met","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49371\/return-value-if-one-condition-is-met","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}]},{"discussionID":49401,"type":"discussion","name":"Counting for a Blank Cell","excerpt":"Hello! I have this formula that works great: =DATE(YEAR([Completion Date]3), (MONTH([Completion Date]3) + 3), (DAY([Completion Date]3))) But if my date in \"[Completion Date]3\" is blank it throws off my whole formula. What can I add so it stays blank if I have no date in \"[Completion Date]3\". THANK YOU!","categoryID":322,"dateInserted":"2019-05-30T11:02:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-30T13:47:21+00:00","insertUserID":40981,"insertUser":{"userID":40981,"name":"Lisi","url":"https:\/\/community.smartsheet.com\/profile\/Lisi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-07T11:34: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":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":94,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/49401\/counting-for-a-blank-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49401\/counting-for-a-blank-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":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":49396,"type":"discussion","name":"Formula help","excerpt":"Hi, I am working hard to get my head around formulas and have managed to get the correct return with the below formula, if greater than 14 days then return \"Yes\", if less than 14 days then return no. Where i am struggling is i also want to return \"Yes\" if the cell is blank. current formula: =IF([Days since last clean]1 <=…","categoryID":322,"dateInserted":"2019-05-30T10:51:30+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-30T13:02:18+00:00","insertUserID":56751,"insertUser":{"userID":56751,"name":"dave.mcpherson56751","url":"https:\/\/community.smartsheet.com\/profile\/dave.mcpherson56751","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-04T08:00:38+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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":56,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/49396\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49396\/formula-help","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}]},{"discussionID":49336,"type":"discussion","name":"variance","excerpt":"I have two numbers or dates Baseline budget 100,000 Current budget 35,000 Variance is 65,000 If I do a % calculation (variance\/baseline) then its 65% I have a health indicator that says if the variance is > 10% then red, more than 5% and < 9% then yellow, lower then green. However, we are WAY under budget in this example…","categoryID":322,"dateInserted":"2019-05-29T17:15:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-30T12:46:19+00:00","insertUserID":90386,"insertUser":{"userID":90386,"name":"matthew.hird90386","url":"https:\/\/community.smartsheet.com\/profile\/matthew.hird90386","photoUrl":"https:\/\/lh6.googleusercontent.com\/-VNVTjDocz9U\/AAAAAAAAAAI\/AAAAAAAAAAA\/ACHi3rdXKN3VolXKsXVcxblqRtTdd2-OkQ\/photo.jpg","dateLastActive":"2020-07-03T17:54:09+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":384,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/49336\/variance","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49336\/variance","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}]},{"discussionID":47741,"type":"discussion","name":"SUMIFS of a value that falls between a rolling date range","excerpt":"Good Morning, I am struggling with the SUMIFS function. I have a sheet that contains job orders. The job orders have a planned start date. The jobs are also categorized by Job Type. I have the following columns: Job Type Planned Start JSH *job site hours* What I need is to calculate the sum of total JSH if the job falls…","categoryID":322,"dateInserted":"2019-05-09T10:20:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-30T09:41:19+00:00","insertUserID":75361,"insertUser":{"userID":75361,"name":"Veronica J","url":"https:\/\/community.smartsheet.com\/profile\/Veronica%20J","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/5c\/cf\/n5ccffce1bb936d05740c1fcc057d5383.jpg","dateLastActive":"2019-08-15T10:51:18+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":18,"countViews":768,"score":null,"hot":18,"url":"https:\/\/community.smartsheet.com\/discussion\/47741\/sumifs-of-a-value-that-falls-between-a-rolling-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/47741\/sumifs-of-a-value-that-falls-between-a-rolling-date-range","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":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}">

Help Article Resources