avoiding #INVALID DATA TYPE

Options

=NETWORKDAY([Date Down]@row, [Closing Date]@row) * 8

Trying to calculate the hours between 2 dates but I need to keep Smartsheet from running the formula if the closing date cell is blank...



Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!