Net days if blank


I have a formula to calculate the net days between an order and shipment date in weeks.

=(NETDAYS([Order Rec.]@row, [Actual delivered date]@row) / 7)

This formula works; however, many of the old projects do not have an order date, resulting in an error of "#INVALID DATA TYPE". How do I add an If(isblank) to avoid this error?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!