Gantt View

expected % complete Yellow - if the actual % complete is within 10% below the expected % complete Red - if the actual %…","categoryID":322,"dateInserted":"2022-06-01T19:18:08+00:00","dateUpdated":null,"dateLastComment":"2022-06-02T19:35:11+00:00","insertUserID":148609,"insertUser":{"userID":148609,"name":"wodifysoftware","url":"https:\/\/community.smartsheet.com\/profile\/wodifysoftware","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJyY2Bh4NjHKgGlSG9xievD-cpsKcOk5dyW_pBcq=s96-c","dateLastActive":"2022-06-22T19:12:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148609,"lastUser":{"userID":148609,"name":"wodifysoftware","url":"https:\/\/community.smartsheet.com\/profile\/wodifysoftware","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJyY2Bh4NjHKgGlSG9xievD-cpsKcOk5dyW_pBcq=s96-c","dateLastActive":"2022-06-22T19:12:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":214,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/91702\/task-status-based-on-expected-complete","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91702\/task-status-based-on-expected-complete","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-02T13:16:46+00:00","dateAnswered":"2022-06-02T13:07:22+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":439,"urlcode":"gantt-view","name":"Gantt View"}],"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":91184,"type":"question","name":"Disregarding N\/A in Formula","excerpt":"Hi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, \"Blue\", IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary…","categoryID":322,"dateInserted":"2022-05-17T07:58:41+00:00","dateUpdated":null,"dateLastComment":"2022-05-20T12:42:22+00:00","insertUserID":145296,"insertUser":{"userID":145296,"name":"Ann11","url":"https:\/\/community.smartsheet.com\/profile\/Ann11","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-06T07:34: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-07-10T20:09:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":204,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/91184\/disregarding-n-a-in-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91184\/disregarding-n-a-in-formula","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/72KE3KWR55GS\/screen-shot-2022-05-17-at-5-20-39-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2022-05-17 at 5.20.39 pm.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-05-17T12:15:14+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"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":47986,"type":"discussion","name":"Formula under Duration in a Gant chart","excerpt":"Hi there, I'm new to smartsheet I want to switch from MS Project to smartsheet to set up the planning schedule. I know we can assign multiple of people to a task but at the planning\/biding level, I just want to juggle with the number of resources to set the best outline. I would like to set the work (total effort to…","categoryID":322,"dateInserted":"2019-05-13T09:47:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-05-05T03:19:22+00:00","insertUserID":88241,"insertUser":{"userID":88241,"name":"Bernard Goulet","url":"https:\/\/community.smartsheet.com\/profile\/Bernard%20Goulet","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-05-13T09:38:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":146327,"lastUser":{"userID":146327,"name":"Tom L","url":"https:\/\/community.smartsheet.com\/profile\/Tom%20L","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgbAD1EhTlL8fftg3qBT2SeDg2NcTYgjcsZKU_B=s96-c","dateLastActive":"2022-05-05T03:17:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":472,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/47986\/formula-under-duration-in-a-gant-chart","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/47986\/formula-under-duration-in-a-gant-chart","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-05\/fe\/cd\/fecd07815fea33b51ce936b0ffc8b0d5.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Gant.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":439,"urlcode":"gantt-view","name":"Gantt View"}],"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":90279,"type":"question","name":"Calculated parent % complete issue","excerpt":"Hello - We are using one of the templates to track a project. We track % complete at the lowest level and then use the parent rolled up % complete. We are seeing a very strange error in the parent % complete. I have attached a few examples that show the problem. You can see that the cost rolling up is not the same as the %…","categoryID":322,"dateInserted":"2022-04-20T16:00:42+00:00","dateUpdated":null,"dateLastComment":"2022-04-25T12:58:23+00:00","insertUserID":147184,"insertUser":{"userID":147184,"name":"JAM_BFT","url":"https:\/\/community.smartsheet.com\/profile\/JAM_BFT","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-25T14:43:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147184,"lastUser":{"userID":147184,"name":"JAM_BFT","url":"https:\/\/community.smartsheet.com\/profile\/JAM_BFT","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-25T14:43:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":395,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/90279\/calculated-parent-complete-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/90279\/calculated-parent-complete-issue","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/Z9GJFKMGWKAL\/smartsheets-1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheets 1.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-04-25T14:27:16+00:00","dateAnswered":"2022-04-25T12:58:23+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":281,"urlcode":"Support","name":"Support"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"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":90104,"type":"question","name":"Iterative Functionality (circular reference) in smartsheet.","excerpt":"I'm currently trying to find a way to do a simple iterative count using the automation tools in smartsheet. Simple iteration is one of the most basic tools in computer based problem solving, so it seems like a good feature to have built into automation tools. The specific situation is that I want to track how long a card…","categoryID":321,"dateInserted":"2022-04-13T20:01:25+00:00","dateUpdated":null,"dateLastComment":"2022-04-22T14:16:21+00:00","insertUserID":146984,"insertUser":{"userID":146984,"name":"Chris Harrigan","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Harrigan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-05-01T21:25:43+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-07-10T19:50:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":217,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/90104\/iterative-functionality-circular-reference-in-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/90104\/iterative-functionality-circular-reference-in-smartsheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-04-22T14:16:21+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":265,"urlcode":"Reports","name":"Reports"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"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":29046,"type":"discussion","name":"Dates start flashing after updating another task's predecessors","excerpt":"I have a project plan that I am now updating to establish dependencies. Everything was going fine until I updated one task's predecessors and a completely separate row's dates (and associated span in the gantt chart) started flashing. I'm guessing that there is some circular logic or something that might be causing this…","categoryID":321,"dateInserted":"2018-07-23T16:22:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-04-13T21:36:57+00:00","insertUserID":55316,"insertUser":{"userID":55316,"name":"JennyN","url":"https:\/\/community.smartsheet.com\/profile\/JennyN","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/dd\/25\/ndd25748fe26e14d836d8da1538424576.jpg","dateLastActive":"2018-12-10T17:21:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":146990,"lastUser":{"userID":146990,"name":"TonyT","url":"https:\/\/community.smartsheet.com\/profile\/TonyT","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gg4XATxNzasT_Wvhv7qn6b1CdPHarZ25F69ld-n=s96-c","dateLastActive":"2022-04-13T21:35:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":true,"countComments":17,"countViews":4235,"score":null,"hot":17,"url":"https:\/\/community.smartsheet.com\/discussion\/29046\/dates-start-flashing-after-updating-another-tasks-predecessors","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29046\/dates-start-flashing-after-updating-another-tasks-predecessors","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">