How do i track progress based on output?
I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadsheet, but would like to have it as part of my smartsheet plan. Am new to smartsheet! Thanks!
Answers
-
Sounds like you're looking to incorporate some earned value management formulas. Maybe take a look here for some different calculations you could track. (https://www.pmi.org/learning/library/earned-value-management-early-warning-546)
Or if you mean something simple, you could have a column for lineal distance installed, a column for total distance required, and then a formula dividing installed by budgeted to get the current progress %.
Let me know if either of those approaches sound like what you are looking for and I can try to help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 352 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!