Hiding #INVALID DATA TYPE with formulas using NETWORKDAYS
Hello, I'd love some feedback and advice on how to get this to work.
I have Start Date, Due Date, Duration and Due in Days columns.
For my Due in Days column I am using this formula:
=NETWORKDAYS(TODAY(), [Actual Due Date]@row)
For my Duration column I am using this formula:
=NETWORKDAYS([Actual Start Date]@row, [Actual Due Date]@row)
My question: How do I hide the error message "#INVALID DATA TYPE" when using the above formulas? Sometimes I have blank cells in the Start Date and Due Date columns so I need to hide the error message.
I'm very new to Smartsheet so if you could provide a full breakdown or formula to plug in using my above formulas I would highly appreciate it.
Thank you!
Best Answer
-
check the closing brackets position @afelo
Answers
-
Hi @afelo ,
You just need to wrap your formula with the IFERROR statement, like -
=IFERROR(NETWORKDAYS([Start Date]@row, [Due Date]@row), "")
This would return blank where either your start date or due date are blank cells. Hope this helps!
Cheers :)
Ipshita
Ipshita Mukherjee
-
Hello Ipshita,
Unfortunately that didn't work. It says #INCORRECT ARGUMENT SET
Any other suggestions?
-
check the closing brackets position @afelo
-
I was going to comment and say it doesn't work because I tried that yesterday, but I figured I'd give it another shot and it worked! thank you :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!