Constraining a deadline that has predecessors
Since Smartsheet does not have constraints built into the scheduling software, I have trouble with drifting deadlines. A proper schedule has predecessors and dependencies assigned to tasks and this string of links needs to logically end with the deadline. The problem is that as soon as someone makes an adjustment to a duration or finish date, the deadline is automatically changed.
I know the logical answer to holding the deadline will be to use the Start-to-Finish predecessor relationship, but people find that confusing and it can be hard to teach. It also limits predictive functions when you do have the option of extending a deadline. The default Finish-to-Start predecessor is so much easier to set up and is the most versatile. Does anyone have a trick for locking that deadline in a Finish-to-Start dependency schedule that will not allow preceding tasks to exceed it?
So far, my only solution has been to eliminate that final dependency link to the deadline. Then I enhance it with a conditional formatting rule to highlight any finish dates that exceed the deadline date. But this gets complicated, especially when there are multiple deadlines in a project.
Answers
-
Have you tried Baselines? This should help!
Set baselines on a project sheet | Smartsheet Learning Center
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
-
Hi Joe. Thanks for the suggestion, but baselines wouldn't help for the sheet I'm working with. It is a conglomerate schedule of 30 or more projects, with new projects being added weekly. Baselines only work once, and a reset removes all previous data. I need a way to apply a brake to an individual task line.
-
Hi @DanR
Smartsheet does not currently have constraints, as you've found. Please add your vote and scenario to this Product Idea thread so the Product team can hear from you: Constraint Types in Gantt View
Cheers,
Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives