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!