Is there a way to set a constraint on a task's Start Date that can override a predecessor?
We have migrated a fairly complex plan from MS Project to Smartsheet and have been able to line up most of our dates. However, when Predecessors finish early on a task, the start date is impacted, as expected. In MS Project we can use constraints to say the next task cannot start early even if its predecessors end early. Is there a way to do something like this in Smartsheet?
The highlighted task starts on June 2, as dictated by the predecessors and lead time.
The same highlighted task starts on July 17 because even though the predecessors dictate it should start on June 2, there is a constraint in place to not allow it to start until at least July 17.
This is important because these tasks cannot start early but their relationship must remain if the predecessors push the next task out beyond July 17. At that point, the predecessor date would be used to calculate the task's new Start Date.
Help Article Resources
Check out the Formula Handbook template!