% Complete Forecast to Future Date
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!