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 help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!