Hide Errors Until Cell is Populated

edited 12/09/19 in Formulas and Functions

I'm calculating the variance between dates using the following formula.  The problem is that an error is displayed if the Actual Start Date is not populated as show in the screenshot.  

Formula used in Variance Start Date: 

=NETWORKDAYS([Planned Start Date]3, [Actual Start Date]3) - 1


Is it possible to have the Variance Start Date cell blank if there is not an Actual Start Date defined by adding something to the formula above? 

Screen Shot 2019-04-16 at 10.05.05 AM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!