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
Options
Cecily H
✭
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!
Comments
-
Hi Cecily,
Try this formula:
=IF(ISBLANK([Close Date]16), "", NETDAYS(TODAY(), [Close Date]16))
-
Success!! Thank you!
This discussion has been closed.