Hiding #INVALID DATA TYPE with formulas using NETWORKDAYS


Hello, I'd love some feedback and advice on how to get this to work.

I have Start Date, Due Date, Duration and Due in Days columns.

For my Due in Days column I am using this formula:

=NETWORKDAYS(TODAY(), [Actual Due Date]@row)

For my Duration column I am using this formula:

=NETWORKDAYS([Actual Start Date]@row, [Actual Due Date]@row)

My question: How do I hide the error message "#INVALID DATA TYPE" when using the above formulas? Sometimes I have blank cells in the Start Date and Due Date columns so I need to hide the error message.

I'm very new to Smartsheet so if you could provide a full breakdown or formula to plug in using my above formulas I would highly appreciate it.

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!