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 | Associate Director, Smartsheet
CrossCountry Consulting - 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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives