avoiding #INVALID DATA TYPE

Luis Orosco

=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...

Kelly Moore

Hey @Luis Orosco

Try this

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

Luis Orosco

thank you!!! I tried several iterations of "ISBLANK", gave up trying!

Kelly Moore

Hey @Luis Orosco

Try this

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

Luis Orosco

thank you!!! I tried several iterations of "ISBLANK", gave up trying!