NETWORKDAYS Invalid
Why would this show as INVALID? I enter a NETWORKDAYS formula that highlights with the VALID colors instead of staying grey but then once I hit enter, it does not calculate the NETWORKDAYS? Smartsheet highlights the cells I want it to calculate from correctly. I am at a loss on why this is not working.
Answers
-
Have you defined your network days? Right click on any column header and select "Project Settings". The following window will appear.
Then click "Edit" under "Working Days" and define which days are working as well as enter the dates for the holidays your company recognizes so they can be taken into consideration.
Hope that helps!
BRgds,
-Ray
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!