How can I make start dates update automatically when tasks are late
Hi! How can I automate the start date of a task to be updated if the previous task runs late? If someone runs late, it makes everybody else automatically overdue for their task. There has to be some way that it can auto update.
Answers
-
Do you have predecessors and whatnot set up?
-
Yes! We have predecessors
-
As long as they are set up properly, updating end dates should push start dates that are affected by that task.
-
I think the problem is that manually updating end dates for hundreds of lines takes a lot of time. We were hoping that when someone enters their completed date, it would automatically update the start date.
-
Wouldn't that be the end date?
-
We have start date, end date and completed date. Someone goes in, does their task and enters the completed date. If this is entered after the end date, the next person's task becomes ready but is already late since the start date doesnt automatically update.
-
When completing a task, you could put the completed date in the end date column instead of using a separate column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!