I have a formula that works, but for cells that should be blank, it shows INVALID DATA TYPE.
I've tried the IFERROR and that is not working.
It's a simple formula to count the dates between when the Case Manager was supposed to sign the form, to when they did sign the form.
=NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row)
As soon as I make it a column formula, it shows all the cells as INVALID DATA TYPE.
The IFERROR formula isn't working:
=IFERROR(=NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row, ""))
This results in INCORRECT ARGUMENT.
Best Answer

I had an extra parenthesis in the formula. I edited. Try this.
=IFERROR(NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row), "")
Answers

Try:
=IFERROR(NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row), "")

I copied and pasted that into the cell… now it says #UNPARSEABLE.

I had an extra parenthesis in the formula. I edited. Try this.
=IFERROR(NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row), "")

That took away the error, but it's still not filling in the cell. It's just empty.
The Document signed date is empty. The Due Date is filled. So it should be counting the number of days from the Due Date until now. But it's just empty.

It sounds like you have two date columns but only one has a date? It will need a date (start and end) in both to work. It doesn't default a TODAY date. You'd have to build in an IF to look for an empty cell and then run it using the TODAY function, but if filled, then go with your original formula.

Yes, awesome, it works now and there is no text in the other fields. Thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 304 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!