Help with using Networkdays as a column formula
I want to create a column Formula that captures the Start Date and End Date in Networkdays but does not show the Invalid Data Type error for every unused column.
Trying to do this without using dependencies since I want more freedom with the start/end dates to be driven by the status rather than input.
I tried to use IF but can't seem to make it work.
Thank you,
Hector Arriaran
Business Process Manager
Best Answer
-
Hello @hjarriaran
Wrap your formula in IFERROR to stop the #INVALID DATA TYPE
=IFERROR(NETWORKDAYS([Start Date]@row, [End Date]@row), "")
Hope this helps
Peggy
Answers
-
Hello @hjarriaran
Wrap your formula in IFERROR to stop the #INVALID DATA TYPE
=IFERROR(NETWORKDAYS([Start Date]@row, [End Date]@row), "")
Hope this helps
Peggy
-
Thank you! It did.
Thank you,
Hector Arriaran
Business Process Manager
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!