% Completion Expected Not Correctly Calculating
I am looking to calculate the expected % complete vs actual. The way my formulas are it is not working. In the example below the expected and actual should match, they do not.
The project sheet is calculating expected by looking at the overall start and end dates.
=IF([Start Date]14 > TODAY(), 0, NETWORKDAYS([Start Date]14, TODAY()) / NETWORKDAYS([Start Date]14, [End Date]14))
I am calculating % Complete off of the # of complete in Level 4
=COUNTIFS(Complete:Complete, 1, Level:Level, 4) / COUNTIFS(Level:Level, 4)
I am thinking that I need to add to the expected but am unsure what. Thanks for your help!
Answers
-
the second countifs should be countif.
-
Hi, your level column follows a column formula. Manually inputting '4' will solve the count error.
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!