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

Options

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:  

#INVALID DATA TYPE

 

Thanks for your help.

 

Tags:

Comments

This discussion has been closed.