NetworkDays #Invalid Operation


Hello Community,

Trying to figure out what I am doing wrong here :-(

I have the below formula to calculate the network days it takes for a contractor to submit the project As-Builts from the day of Actual Completion Date. If the corresponding fields have dates in it, it works perfect. But if the fields are empty, I get the #INVALID OPERATION error, even though l have " " for the blanks.... Help?!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!