Schedule Health based on % Complete gernerates errors in some rows.
I need help troubleshooting a formula (pasted below). In some rows it works fine, and in others I get an error, "#INVALID OPERATION". I expect the error ina row where NETWORKDAYS and DURATION cannot be calculated because the startdate and end date are not populated. Does anyone know what I am missing?
Thanks in advance!
=IF([% Complete]@row >= NETWORKDAYS([Start Date]@row, TODAY()) / Duration@row, "Green", IF(([% Complete]@row >= NETWORKDAYS([Start Date]@row, TODAY()) / Duration@row) - 0.05, "Yellow", "Red"))
Help Article Resources
Check out the Formula Handbook template!