Welcome to the Smartsheet Forum Archives


这个论坛的帖子不再监视for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Forced dates when dependency is enabled

cmsherer
cmsherer
edited 12/09/19 inArchived 2017 Posts

We are working to importa 1800 line project plan into smartsheet and have run into a dabilitating problem with the dates.

What looks to be happening is that the “Duration” and “predecessors” fields are completely driving the dates for the tasks. Anything with a predecessor is automatically forcing the start date to be the day immediately after the predecessor completes, whereas this is not necessary true for all tasks.

MS Project:

However, with this turned off, none of the dates have any dependencies, including the roll-up dates. So I am forced to choose between giving up the predecessors functionality, or giving up the date dependency, which causes each date field to act independent and would not be feasible to maintain.

Any suggestions or solutions for this?

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee
    edited 02/13/17

    Hello,

    You're correct in that the dependencies functionality in Smartsheet works such that the End Date on the Predecessor task drives the start date of dependent tasks. You can add lag to your dependent tasks to push their start dates out:https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors#lagtime

  • Just to confirm, in theory, in order to make our dates match, we would need to go through all 1800 rows and add the correct number of lag days so the dates populates correctly?

  • Correct.

    We don't have a way to maintain the dependency relationship in Smartsheet and have tasks start on a date that isn't immediately following the Predecessor task without adding lag days. I'll get your vote down for functionality to create a dependency relationship that doesn't drive the dependent task's start date or end date to our enhancement request list for further consideration.

  • Thank you for submitting. We did some additional testing with the lag time functionality this morning, and this creates an issue on the other end where if a precessor shifts 3 days, the successor also shifts three days, even if there is a 2 month lag between the items. This doesn't seem logical and makes it impossible to manage a project of this size and complexity in the tool.

  • Lag times are static—as currently Smartsheet is centered around the model of Predecessor tasks driving the dates on their dependent tasks.

    @PAughey—I've got your vote down for this as well!

  • Is there a way to drag the following task and have the lag time update? Would like to drag a dependent task back to a week later, but doing so breaks the dependency. We often sit together and go down the gantt chart and adjust start/finish days visually. Having to enter a date manually for each one would be a hassle.

  • Please also add my vote - For large scale projects with complex dependencies there needs to be a way to lock down certain dates even if they have dependencies.

  • Has this been resolved? I would really like to keep using Smartsheet, but this feature has me shying away until there is an option to disable lag time dependencies on individual tasks and/or disable globally. Changing the predecessor lag time is such an inefficient and nonintuitive method to change the dependent task dates.

  • JustinB
    JustinB
    edited 04/19/18

    I'm looking for a status on this as well. Other web based project management solutions simply have a setting to turn this feature on and off as needed. Is this something that can be implemented? It could be a global toggle. Toggle is on and lag time stays constant. Toggle off and lag times recalculate when you adjust a predecessor.

    也可以是checkbox option.

    Seems like a pretty reasonable function, regardless of how it is implemented.

  • Hi fellow Smartsheet users. We just came accross the same issue and i was wondering if the solution is to allow the desactivation of the dependency by row not to the complete sheet. It is like in MS Project that you have the option to say if the task is manually scheduled or auto-scheduled and still you have the option to enter a predecessor.

    I will appreciate if you can update us about when this will be resolved.

    thank you!

  • Is there any word on if this has been solved?

  • Would be good to have this feature

  • Has this now been resolved?? I would be interested in the outcome as would need to lock specific milestone dates to avoid movement when there is slippage with a tasks that is is dependent on.

This discussion has been closed.
In that case you would use the same syntax but you would reference the column in the sheet using the appropriate column name. <\/p>

[Column name]:[Column name]<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":108286,"type":"question","name":"Configuring Predecessors in forward scheduling vs backward scheduling","excerpt":"I have a user who wants to schedule some projects in a forward-looking manner (top to bottom) and schedule other projects in a backward-looking manner (bottom to top). To explain to her how Predecessors would need to be configured in either scenario, I created the little example shown below. In the FORWARD section, the…","snippet":"I have a user who wants to schedule some projects in a forward-looking manner (top to bottom) and schedule other projects in a backward-looking manner (bottom to top). To explain…","categoryID":321,"dateInserted":"2023-07-29T00:11:14+00:00","dateUpdated":null,"dateLastComment":"2023-07-31T14:48:51+00:00","insertUserID":163593,"insertUser":{"userID":163593,"name":"George Speier","url":"https:\/\/community.smartsheet.com\/profile\/George%20Speier","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-31T18:25:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163593,"lastUser":{"userID":163593,"name":"George Speier","url":"https:\/\/community.smartsheet.com\/profile\/George%20Speier","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-31T18:25:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":35,"score":null,"hot":3381405605,"url":"https:\/\/community.smartsheet.com\/discussion\/108286\/configuring-predecessors-in-forward-scheduling-vs-backward-scheduling","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108286\/configuring-predecessors-in-forward-scheduling-vs-backward-scheduling","format":"Rich","lastPost":{"discussionID":108286,"commentID":388026,"name":"Re: Configuring Predecessors in forward scheduling vs backward scheduling","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388026#Comment_388026","dateInserted":"2023-07-31T14:48:51+00:00","insertUserID":163593,"insertUser":{"userID":163593,"name":"George Speier","url":"https:\/\/community.smartsheet.com\/profile\/George%20Speier","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-31T18:25:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/4M6FSYYJUAME\/predecessors2.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"predecessors2.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-31T14:47:57+00:00","dateAnswered":"2023-07-29T20:17:17+00:00","acceptedAnswers":[{"commentID":387957,"body":"

This has to do with how a milestone is represented (ie. a 0 day duration). If you hard type milestone without a predecessor or successor, it will show up as the beginning of that day instead of the end of the day. If you have a milestone that is following a standard finish to start logic, it will show up at the end of the previous activity. <\/p>

So, Task B4 in the backwards version is actually saying that the completion happened in the 00:00 hr of that day. if you put any activity in that has a duration and uses the start to finish relationship, that activity will naturally finish at the end of the previous day. So, to get your example above to work, the finishing task would need to be 1 day long so it takes up the full work day. I found it easier to visualize if you zoom all the way in on the gantt chart so you can see the diamond symbol of the milestone at the beginning and end of the days when used in different set ups.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":108291,"type":"question","name":"Conditional formatting in Gantt not working with dependencies","excerpt":"For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable dependencies, but I need those and don't understand why this should matter since I don't have any rules related to status or % complete in the…","snippet":"For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable…","categoryID":321,"dateInserted":"2023-07-29T22:50:55+00:00","dateUpdated":null,"dateLastComment":"2023-07-30T15:38:08+00:00","insertUserID":164323,"insertUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164323,"lastUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":null,"hot":3381404343,"url":"https:\/\/community.smartsheet.com\/discussion\/108291\/conditional-formatting-in-gantt-not-working-with-dependencies","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108291\/conditional-formatting-in-gantt-not-working-with-dependencies","format":"Rich","tagIDs":[219,319,437,439],"lastPost":{"discussionID":108291,"commentID":387971,"name":"Re: Conditional formatting in Gantt not working with dependencies","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387971#Comment_387971","dateInserted":"2023-07-30T15:38:08+00:00","insertUserID":164323,"insertUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/4N6Y1NCLVR43\/2023-07-29-15-46-58-281-29-moving-plan-smartsheet-com.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2023-07-29 15_46_58-(1) Moving plan - Smartsheet.com.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-30T15:39:24+00:00","dateAnswered":"2023-07-30T09:21:36+00:00","acceptedAnswers":[{"commentID":387967,"body":"

Hi @smbailey<\/a> <\/p>

I hope you're well and safe!<\/p>

I can't see any rows in your screenshot that should be colored differently. Parent rows can't be changed.<\/p>

Can you share more screenshots with the conditional formatting options used on a few child rows?<\/strong> (Delete\/replace any confidential\/sensitive information before sharing) That would make it easier to help. <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts