NetworkDay formula condition question

Kathy PPT
Kathy PPT ✭✭✭
edited 04/12/24 in Formulas and Functions

I'm looking for guidance please and appreciate any input!

I was able to get the NETWORKDAY formula to work by itself. However, I am now trying to put a condition to calculate NETWORDAY if the Project Status is not "Complete". Otherwise, I want it to display the Duration field. It's not erroring, just says the format is not correct.

All these fields are in the Intake sheet


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!