% Completion Expected Not Correctly Calculating

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!