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.
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 151 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!