% Complete Forecast to Future Date
Options
Is there a way to project a POC (Percentage of Completion) to a certain Date?
The assumption is that the baseline schedule has been vetted, and agreed upon.
What I would want to do is forecast for example what the POC would be to the end of the Month, or to the end of the Next Month - I'm at May 30th right now, so I can recognize what is is now (say 8%) but I'm being asked to forecast where the project will be on June 30th and July 31st.
Answers
-
You would use something like this...
(DATE(date_you_want_to_project_to) - [Start Date]@row) / ([End Date]@row - [Start Date]@row)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!