Project Management

=(DATE(2018, 7, 1), {Editing List-3-2018 Range 5}, =\"Name\"), Date:Date, <=(DATE(2018,6,30), [Assigned to: Editor]:[Assigned to: Editor],=\"Name\")","categoryID":322,"dateInserted":"2019-02-18T17:17:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-05-17T13:06:58+00:00","insertUserID":78956,"insertUser":{"userID":78956,"name":"Mark Case","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Case","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-21T12:09:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-26T16:24:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":1216,"score":null,"hot":3234844442,"url":"https:\/\/community.smartsheet.com\/discussion\/41821\/using-countifs-with-multiple-references-to-other-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/41821\/using-countifs-with-multiple-references-to-other-sheets","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":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":105272,"type":"question","name":"Pre-Approved Changes Pulled From Approved Standard Changes","excerpt":"Hello! I'm attempting to create a change management system wherein the pre-approved changes can reference previously submitted (and approved by our CAB) standard changes. Pre-Approved Changes - need it to be a drop-down list of pre-populated requests that are Standard change requests that have been approved to become…","categoryID":321,"dateInserted":"2023-05-16T01:50:59+00:00","dateUpdated":null,"dateLastComment":"2023-05-16T12:09:20+00:00","insertUserID":161478,"insertUser":{"userID":161478,"name":"Alia.Anees","title":"IT Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Alia.Anees","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-22T18:54:14+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-27T06:21:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":38,"score":null,"hot":3368441419,"url":"https:\/\/community.smartsheet.com\/discussion\/105272\/pre-approved-changes-pulled-from-approved-standard-changes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105272\/pre-approved-changes-pulled-from-approved-standard-changes","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-16T12:09:20+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":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":105183,"type":"question","name":"Progress Bar Automation between 2 Different Sheets","excerpt":"Hi to all you brilliant Smartsheet Wizards! 🧙‍♂️🧙‍♀️ I saw a question on here regarding how to \"automate a progress bar\" and I thought that is perfect for my tracking: Automate the Progress Bar — Smartsheet Community My problem: I want the progress bar in Sheet A under \"milestones\". But I want it to source the data from…","categoryID":322,"dateInserted":"2023-05-12T16:03:10+00:00","dateUpdated":null,"dateLastComment":"2023-05-15T17:33:05+00:00","insertUserID":161412,"insertUser":{"userID":161412,"name":"crokicki","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/crokicki","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/RBJ9MW410PF6\/nZRE4PSVB3R0B.jpg","dateLastActive":"2023-06-20T13:47:27+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-06-26T20:54:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":47,"score":null,"hot":3368081775,"url":"https:\/\/community.smartsheet.com\/discussion\/105183\/progress-bar-automation-between-2-different-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105183\/progress-bar-automation-between-2-different-sheets","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NH04S7K4ID6R\/smartsheet-1-milestone-progress-bar.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet 1 - Milestone Progress Bar.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-13T14:22: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":281,"urlcode":"Support","name":"Support"},{"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":104663,"type":"question","name":"How can I update Jira comments via Smartsheet (and vice versa)","excerpt":"I use Smartsheet with the Jira Connector (I am on Jira Data Center) for project management. I make frequent updates to the “latest comments” column in Smartsheets to provide commentary on certain Jira cards. The issue with this is that comments about cards are either in Smartsheet, or in Jira, but not both. Here’s an…","categoryID":343,"dateInserted":"2023-05-01T15:21:42+00:00","dateUpdated":null,"dateLastComment":"2023-05-15T04:06:55+00:00","insertUserID":161020,"insertUser":{"userID":161020,"name":"JennaDobs","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/JennaDobs","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-18T19:49:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161444,"lastUser":{"userID":161444,"name":"Ward.Hively","title":"👨President and 📈Chief Consultant | 💼Smartsheet Partner💼 |","url":"https:\/\/community.smartsheet.com\/profile\/Ward.Hively","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p1EqaeuboXo!XADon1_mBso!cvKlp5UezJt","dateLastActive":"2023-06-25T21:56:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":123,"score":1,"hot":3367079017,"url":"https:\/\/community.smartsheet.com\/discussion\/104663\/how-can-i-update-jira-comments-via-smartsheet-and-vice-versa","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104663\/how-can-i-update-jira-comments-via-smartsheet-and-vice-versa","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-15T04:06:55+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":450,"urlcode":"jira-connector","name":"Jira Connector"}],"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}">