Currently, adding (1) manually a start date for a specific task AND (2) defining certain predecessors for the same task is not possible
// Problem Description
Let's imagine, we have the following two tasks to plan:
Task 1: Starting at day 1 and a duration of 10 day
Task 2: Starting at day 15 and a duration of 10 day, predecessor is task 1
--> Currently I have three options to implement this
Option 1 (Don't use the predecessor function): Task 1, manually set start date to day 1 & Task 2 set manually start date to day 15. ---> Problem: When I have to extend Task 1 to a duration of 20 days, Task 2 remains as it is.
Option 2 (Use the predecessor function): Task 1, manually set start date to day 1 & Task 2 set predecessor as task 1. ---> Problem: Task 2 starts directly after Task 1, i.e. at day 10 and not day 15 as it should be.
Option 3 (Use the predecessor with lag function): Task 1, manually set start date to day 1 & Task 2 set predecessor as task 1 with lag 5 days. At the beginning this looks good. However, when I have to extend the duration of Task 1 to 15 days, Task 2 starts only at day 20, because the "lag" is still added, despite it is no longer relevant.
// Requirement Description (Solution):
It shall be possible to manually define a start date of a specific task but still allow the definition of predecessors. Therefore, in the background, such a task should always have (1) the manually defined start date and (2) a automatically calculated start date (based on the predecessor). Now, the system should always check which of these two dates is "more in the future" and only display this one as actual start date of the specific task in the Gantt.
2023-07-01T08:02:49.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":108289,"type":"idea","name":"Document View 💡","excerpt":"Hi Smartsheet Team, I hope you're doing well. I've been using Smartsheet extensively and have a technical suggestion that could significantly enhance the platform's capabilities. I'd like to propose the implementation of an advanced Document View feature, which would enable users to seamlessly interact with both tabular…","snippet":"Hi Smartsheet Team, I hope you're doing well. I've been using Smartsheet extensively and have a technical suggestion that could significantly enhance the platform's capabilities.…","categoryID":349,"dateInserted":"2023-07-29T18:43:04+00:00","dateUpdated":"2023-07-29T18:44:19+00:00","dateLastComment":"2023-07-29T18:43:04+00:00","insertUserID":21126,"insertUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-07-29T18:49:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":21126,"lastUserID":21126,"lastUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-07-29T18:49:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":20,"score":1,"hot":3381312743,"url":"https:\/\/community.smartsheet.com\/discussion\/108289\/document-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108289\/document-view","format":"Rich","tagIDs":[268,363],"lastPost":{"discussionID":108289,"name":"Document View 💡","url":"https:\/\/community.smartsheet.com\/discussion\/108289\/document-view","dateInserted":"2023-07-29T18:43:04+00:00","insertUserID":21126,"insertUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-07-29T18:49:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":108274,"type":"idea","name":"Automation to send form for a sheet at specified cadence","excerpt":"It would be nice in the automations to send out a form at a specific time, weekly, monthly etc. to emails so staff can be reminded to send over form responses on a project. Not an update, but fill out a form from scratch.","snippet":"It would be nice in the automations to send out a form at a specific time, weekly, monthly etc. to emails so staff can be reminded to send over form responses on a project. Not an…","categoryID":349,"dateInserted":"2023-07-28T19:26:32+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T23:35:25+00:00","insertUserID":164306,"insertUser":{"userID":164306,"name":"andreadarcy","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/andreadarcy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T23:36:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164306,"lastUser":{"userID":164306,"name":"andreadarcy","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/andreadarcy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T23:36:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":1,"hot":3381161217,"url":"https:\/\/community.smartsheet.com\/discussion\/108274\/automation-to-send-form-for-a-sheet-at-specified-cadence","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108274\/automation-to-send-form-for-a-sheet-at-specified-cadence","format":"Rich","tagIDs":[204,334,363,510],"lastPost":{"discussionID":108274,"commentID":387942,"name":"Re: Automation to send form for a sheet at specified cadence","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387942#Comment_387942","dateInserted":"2023-07-28T23:35:25+00:00","insertUserID":164306,"insertUser":{"userID":164306,"name":"andreadarcy","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/andreadarcy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T23:36:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CELKJANR1OHA\/form-automation.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Form Automation.jpg"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":108187,"type":"idea","name":"Cell-level Comments","excerpt":"Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads \"Cell\" next to the \"Row,\" \"Sheet,\" and \"All\" tabs. Currently, I'm spending a lot of time describing columns and going back and forth on communication to confirm columns and which…","snippet":"Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads \"Cell\" next to the \"Row,\" \"Sheet,\" and…","categoryID":349,"dateInserted":"2023-07-27T15:06:03+00:00","dateUpdated":"2023-07-27T15:07:29+00:00","dateLastComment":"2023-07-27T15:06:03+00:00","insertUserID":149231,"insertUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":149231,"lastUserID":149231,"lastUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":29,"score":7,"hot":3380942912,"url":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","format":"Rich","tagIDs":[319,363,391,441,507,566],"lastPost":{"discussionID":108187,"name":"Cell-level Comments","url":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","dateInserted":"2023-07-27T15:06:03+00:00","insertUserID":149231,"insertUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":7}],"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":566,"urlcode":"idea","name":"idea"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-07-01T08%3A02%3A49%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":168,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">