I want to auto calculate the estimated date of completion based on the current status and pending work items in the backlog.
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
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
©2022. All Rights Reserved Smartsheet Inc.