Auto calculate the estimated date of completion
Hello,
I want to auto calculate the estimated date of completion based on the current status and pending work items in the backlog.
Tags:
Answers
-
Hi @Fahad F
The way I would do this is to ensure that all of my tasks are linked together using the Predecessor column. Then as dates are completed I'd update the End Date of that task to the actual End Date. That will bump forward all of the following tasks so that the last one is a new estimated final date.
See: Enable Dependencies and Use Predecessors
Here's a webinar on Project Management tools in Smartsheet: SmartStart: Project Management
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!