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
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!