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
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!