=NETDAYS([Expected Finish Launch Date]48, [Planned Finish Launch Date]48) returns 1 when date is the
Comments
-
If it's in a project template, Smartsheet may be allocating a full workday to the date range. Smartsheet also doesn't deal with times very well and UTC vs Local time can cause issues with the displayed date being different to the underlying system date.
So [Expected Finish Launch Date]48 may be starting at 9am and [Planned Finish Launch Date]48 may finish at 5pm. Or the dates may even be treated by Smartsheet as different (despite the date being displayed the same). Someone else out there may know more about this.
I know it's weird behaviour, but if it's consistent then you can possibly counteract it by changing the formula to =NETDAYS([Expected Finish Launch Date]48, [Planned Finish Launch Date]48) -1
Or I could just be speaking waffling off on a tangent and be completely wrong
-
Thanks, Chris! I agree with your theory, and your formula suggestion is just what I needed. Thanks so much!!
Regards,
Lawrence
-
My pleasure Lawrence
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!