% Complete Without Dates
Hey There,
I work for a construction company, and one of our subdivisions has multiple townhome blocks. We are currently building 3 blocks, but don't know when we will start the other ones (all dependent on sales)
I'm wondering if there is a way to get the % Complete for the whole project, not just the blocks currently in progress. When I use the built in function, it only calculates the % Complete base on the 3 blocks we are building, because the remaining 12 blocks don't have start and end dates.
I know the simple solution would be to sum the % Completes and divide by the number of items, but that would not be accurate as some blocks are a different design, and therefore require more time.
Answers
-
Can you share the formula that you currently have as the total % complete? You can probably adjust it to include only rows where start date is not blank.
-
Currently I am just using the built in % Complete calculation found int the Project Settings.
-
If you have dependencies enabled on your sheet, you cannot edit the % complete formula. You could include a new column and put your own formula in that to calculate the % complete differently. At the moment the % complete will be doing something like this:
=SUM(CHILDREN()) / COUNTIF(CHILDREN(), >0)
The sum of the child rows divided by the number of non-zero child rows.
You may be able to create a similar formula to use a denominator that is better for your use case. It sounds like you might need a column for estimate project time for each block and then use this to calculate your % complete.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!