Can Smartsheet forecast end date base on % complete input
Start Date: 10 Jan 2022 (Mon)
End Date: 14 Jan 2022 (Fri)
For simple calculation, working day duration is 5 days. Each day should achieve 20%.
Today is 12 Jan 2022 and I should achieved 60%, but I only manage to complete 40%.
Therefore I will need an additional one day to complete the task.
So the forecast end date should be 17 Jan 2022 (working day).
How should I calculate the forecast end date?
Help Article Resources
Check out the Formula Handbook template!