Government

=startdate))>1 I know that Smartsheet doesn't support SUMPRODUCT.…","categoryID":319,"dateInserted":"2017-09-29T16:38:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-10-29T14:03:04+00:00","insertUserID":18606,"insertUser":{"userID":18606,"name":"Dartwohl","url":"https:\/\/community.smartsheet.com\/profile\/Dartwohl","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-07\/be\/4d\/nbe4ddee0bfa69bdb716a187dc0880927.jpg","dateLastActive":"2019-05-20T15:43:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":643,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/14171\/need-help-with-date-range-overlap-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14171\/need-help-with-date-range-overlap-formula","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2017-09\/59\/9e\/599ee4ce502867e8d04527023ca0d545.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"9-29-2017 3-27-20 PM.jpg"},"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"},{"tagID":263,"urlcode":"Government","name":"Government"},{"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":14786,"type":"discussion","name":"Duration Calculation not accurate on my sheet","excerpt":"Duration column on my project includes Hours and Days depending on the task. However, the duration count is inaccurate. ","categoryID":319,"dateInserted":"2017-10-12T12:02:16+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-10-13T15:33:59+00:00","insertUserID":12172,"insertUser":{"userID":12172,"name":"Blessing Ugbo","url":"https:\/\/community.smartsheet.com\/profile\/Blessing%20Ugbo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-06T13:45:34+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-06-08T15:18:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":7,"countViews":697,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/14786\/duration-calculation-not-accurate-on-my-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14786\/duration-calculation-not-accurate-on-my-sheet","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":263,"urlcode":"Government","name":"Government"},{"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":14846,"type":"discussion","name":"Project end date - Metric","excerpt":"Hi I am trying to create a metric for a Sight sheet to show countdown in days and another in weeks until a project starts can anyone help ? Cheers Neil","categoryID":319,"dateInserted":"2017-10-13T10:43:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-10-13T12:49:56+00:00","insertUserID":26026,"insertUser":{"userID":26026,"name":"Neil Huddart","url":"https:\/\/community.smartsheet.com\/profile\/Neil%20Huddart","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-10-13T10:40:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/14846\/project-end-date-metric","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14846\/project-end-date-metric","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":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}],"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":14446,"type":"discussion","name":"Smart Sheet Expert User","excerpt":"Seeking a smart sheet expert user able to to offer consultancy services. Wishing to use the software as a database to read and report on a number of sheets.","categoryID":319,"dateInserted":"2017-10-06T07:19:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-10-06T10:14:44+00:00","insertUserID":25371,"insertUser":{"userID":25371,"name":"Johnie-2017","url":"https:\/\/community.smartsheet.com\/profile\/Johnie-2017","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-10-30T14:21:28+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-06-09T13:59:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/14446\/smart-sheet-expert-user","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14446\/smart-sheet-expert-user","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":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":291,"urlcode":"Webinars","name":"Webinars"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"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":13661,"type":"discussion","name":"Predecessor Content Change in Report?","excerpt":"Recently I have noticed that what is displayed in the predecessor column when running a report has changed from showing the specific line dependencies to now just showing the number of predecessors ( i.e., 1 Predecessor, or 2 Predecessors). This isn't really of value when looking at a report. Is there a way to show the…","categoryID":319,"dateInserted":"2017-09-18T12:08:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-09-18T15:18:40+00:00","insertUserID":10180,"insertUser":{"userID":10180,"name":"Stacey Grey-Gardner","url":"https:\/\/community.smartsheet.com\/profile\/Stacey%20Grey-Gardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-09-18T12:02:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":228,"lastUser":{"userID":228,"name":"Robin Sherwood","url":"https:\/\/community.smartsheet.com\/profile\/Robin%20Sherwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/98\/09\/n9809c7ca712c02d9d71ea1aaaf414a9e.jpg","dateLastActive":"2022-05-11T19:02:46+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":386,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/13661\/predecessor-content-change-in-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/13661\/predecessor-content-change-in-report","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":220,"urlcode":"Hospitality","name":"Hospitality"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"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}">