Update to formula regarding date calculation


=NETDAYS([DAW Date]@row, [Activity Start Date]@row

If [DAW Date] is "blank" on certain rows, I would like smartsheet not to show "#invalid data type" in the calculation field/column.

I have played around with a few different formulas without success and know there is a solution to this?

Can someone offer advice? thank you!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!