The use of Netdays function
Best Answer

Have you tried using IFERROR to suppress the #INVALID DATATYPE message on rows with empty values?
The syntax is:
=IFERROR(your NETDAYS function goes here), "")
The , "") at the end tells the system "if this formula returns an error, replace the result with "", which means a blank cell."
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers

Have you tried using IFERROR to suppress the #INVALID DATATYPE message on rows with empty values?
The syntax is:
=IFERROR(your NETDAYS function goes here), "")
The , "") at the end tells the system "if this formula returns an error, replace the result with "", which means a blank cell."
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

@Jeff Reisman Thank you . it worked
Help Article Resources
Categories
Check out the Formula Handbook template!