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.

Netdays - if blank

Cecily H
Cecily H
edited 12/09/19 in Archived 2017 Posts

Hello all --

I have created a column to show me how many days between "today" and the expected close date of a sale. This is the formula I'm using:

=NETDAYS(TODAY(), Close Date16)

This is working, but I have one problem: I don't always have an expected close date. In those situations, I want the cell to display as blank. RIght now, if the close date column is blank, the net days column displays: #INVALID DATA TYPE. 

What do I need to add to my formula to fix this?

Thanks in advance for your help!



This discussion has been closed.