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-28T17:36:50+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":1224,"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-29T08:35:12+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-28T18:51:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":49,"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":127,"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}]},{"discussionID":105045,"type":"question","name":"Can you assign a random value based on a list?","excerpt":"I am trying to automate the task of assigning a person to an assignment. Users can submit a form, which generates a row on my sheet. The row then has to be manually assigned to someone to complete it. There are no values that can be used to really assign it to one given person- these are submission for setting up new…","categoryID":322,"dateInserted":"2023-05-10T13:41:31+00:00","dateUpdated":null,"dateLastComment":"2023-05-14T07:07:42+00:00","insertUserID":161310,"insertUser":{"userID":161310,"name":"reiem87","title":"Purchasing Specialist","url":"https:\/\/community.smartsheet.com\/profile\/reiem87","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-24T19:26:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":129958,"lastUser":{"userID":129958,"name":"Lucas Rayala","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!7HVumwhOGBb","dateLastActive":"2023-06-29T07:27:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":67,"score":null,"hot":3367774753,"url":"https:\/\/community.smartsheet.com\/discussion\/105045\/can-you-assign-a-random-value-based-on-a-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105045\/can-you-assign-a-random-value-based-on-a-list","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-15T12:16:02+00:00","dateAnswered":"2023-05-14T07:07:42+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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":89997,"type":"question","name":"Formula for Hours Scheduled by Month","excerpt":"We're trying to determine how many hours we have scheduled in a month for a particular project based on the start and end date of the project. I can't quite figure out how to set the MAX\/MIN without the EOM function. Can someone please help?","categoryID":322,"dateInserted":"2022-04-11T21:05:48+00:00","dateUpdated":null,"dateLastComment":"2023-05-13T14:07:15+00:00","insertUserID":146898,"insertUser":{"userID":146898,"name":"SarahALLBRiGHT","url":"https:\/\/community.smartsheet.com\/profile\/SarahALLBRiGHT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3AHC_5rshv4!xtFDcfK5PXo!rXyuUJ68Y8A","dateLastActive":"2022-04-15T19:33: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-06-28T18:51:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":547,"score":null,"hot":3333706383,"url":"https:\/\/community.smartsheet.com\/discussion\/89997\/formula-for-hours-scheduled-by-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/89997\/formula-for-hours-scheduled-by-month","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LU3ELO2DPSH7\/production-tracker-question.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Production Tracker Question.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-04-13T11:55:41+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":218,"urlcode":"Construction","name":"Construction"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":347,"urlcode":"ask-me-anything","name":"Ask me anything"},{"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":105179,"type":"question","name":"AVE or AVERAGEIF when refrencing another sheet","excerpt":"I have my master sheet set up with a duration column. I've been trying to build a formula on my metrics sheet that will allow me to average the duration column based on who is assigned that purchase order. I've tried two formulas, one using AVE and the other using AVERAGEIF and both return the #UNPARSABLE error. The first…","categoryID":322,"dateInserted":"2023-05-12T15:08:57+00:00","dateUpdated":"2023-05-12T15:35:26+00:00","dateLastComment":"2023-05-13T04:08:53+00:00","insertUserID":154905,"insertUser":{"userID":154905,"name":"Galadriel975","url":"https:\/\/community.smartsheet.com\/profile\/Galadriel975","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!knMqvzomcgo!3GtrPzY0BLo!ed-Utf2KUko","dateLastActive":"2023-05-15T14:15:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-06-27T00:59:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":56,"score":null,"hot":3367855670,"url":"https:\/\/community.smartsheet.com\/discussion\/105179\/ave-or-averageif-when-refrencing-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105179\/ave-or-averageif-when-refrencing-another-sheet","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/AB33IQW82R76\/screenshot-2023-05-12-at-16-35-13.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-05-12 at 16.35.13.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-15T12:17:58+00:00","dateAnswered":"2023-05-13T04:08:53+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":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":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":105206,"type":"idea","name":"Rendering Milestone on dashboard","excerpt":"Creating dashboards and image widgets. There is a problem with the widget pulling from the source file. An example is a dashboard displaying milestones for a project. Milestones are seen as flat parent relationships The project plan has a typical parent-child structure, but the widget does not render correctly when linked…","categoryID":349,"dateInserted":"2023-05-12T22:37:35+00:00","dateUpdated":null,"dateLastComment":"2023-05-12T22:37:35+00:00","insertUserID":154735,"insertUser":{"userID":154735,"name":"Miles C","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Miles%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/1W9L9465QU97\/nN9COEJSAGCDF.jpg","dateLastActive":"2023-06-15T19:18:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":154735,"lastUser":{"userID":154735,"name":"Miles C","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Miles%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/1W9L9465QU97\/nN9COEJSAGCDF.jpg","dateLastActive":"2023-06-15T19:18:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":39,"score":1,"hot":1683931355,"url":"https:\/\/community.smartsheet.com\/discussion\/105206\/rendering-milestone-on-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105206\/rendering-milestone-on-dashboard","format":"Rich","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/N6NCDTLJOMWS\/parent-child-child-milestone-dashboard-05-12-2023.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Parent child child milestone dashboard 05 12 2023.jpg"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":105175,"type":"idea","name":"Let folders be folders!","excerpt":"Let at least JPEG\/PDF files be uploaded to a folder without a sheet. It is assanin to have to create a sheet to add an attachment that you have to REDOWNLOAD in order to use\/export. Why not just allow a folder to have a normal folder use and upload images if I can't even export the attachments off the sheet without having…","categoryID":349,"dateInserted":"2023-05-12T13:47:34+00:00","dateUpdated":null,"dateLastComment":"2023-05-12T13:47:34+00:00","insertUserID":161407,"insertUser":{"userID":161407,"name":"kmur","title":"Project Engineer","url":"https:\/\/community.smartsheet.com\/profile\/kmur","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxa4yhxzy6jShxv2IWE381I477qGino8MI0Kqef1=s96-c","dateLastActive":"2023-05-12T14:09:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161407,"lastUser":{"userID":161407,"name":"kmur","title":"Project Engineer","url":"https:\/\/community.smartsheet.com\/profile\/kmur","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxa4yhxzy6jShxv2IWE381I477qGino8MI0Kqef1=s96-c","dateLastActive":"2023-05-12T14:09:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":true,"countComments":0,"countViews":41,"score":2,"hot":1683899854,"url":"https:\/\/community.smartsheet.com\/discussion\/105175\/let-folders-be-folders","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105175\/let-folders-be-folders","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":96251,"type":"idea","name":"Adding New Task After Setting Baseline","excerpt":"Smartsheet Community: Once The Baseline is Set. It Would Be Nice to Have The Ability to Add New Tasks and for those Tasks to be Added to The Baseline without Re-Setting it. Today, I have to Manual Change All the Dates. This Drastically Increase human Errors and is Very Time Consuming.","categoryID":349,"dateInserted":"2022-10-05T14:14:44+00:00","dateUpdated":"2022-10-10T11:34:23+00:00","dateLastComment":"2023-05-10T20:14:16+00:00","insertUserID":146904,"insertUser":{"userID":146904,"name":"Kaleb","url":"https:\/\/community.smartsheet.com\/profile\/Kaleb","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hzlAoSbUIDs!hU_D4f686H8!MeM8OksBL1v","dateLastActive":"2023-06-28T19:50:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":161204,"lastUser":{"userID":161204,"name":"Cheryl Ferraro","title":"Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/Cheryl%20Ferraro","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-10T20:09:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":203,"score":11,"hot":3348735240,"url":"https:\/\/community.smartsheet.com\/discussion\/96251\/adding-new-task-after-setting-baseline","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96251\/adding-new-task-after-setting-baseline","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":393,"urlcode":"baseline","name":"Baseline"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">