Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Calculating Days - Error if no date is entered


I have a column called "Closing Date".  I also have a column that calculates the number of days until the closing date.  It works great if I have entered the closing date.  However, if we don't know the closing date yet and leave that column blank I then get an error in the column that is calculating the closing date.  Anyway to just have it be blank?


Here is the formula I am using:  =NETDAYS(Today2, [Close Date]2)


Here is the error I am getting when no date is entered in the Close Date column:  



Thanks for your help.




This discussion has been closed.