Netdays Negative Return
Hi All!
I'm running into a quirk when using the netdays formula."Create Date" is a system generated column used for the start date, and "Resolution Date" is the end date.
When I have a record where the resolution date is the same as the startdate, I'm getting a -2 for the netdays between these values. Any idea what's going on?
=IF(ISBLANK([Resolution Date]@row), NETDAYS(Created@row, TODAY()), NETDAYS(Created@row, [Resolution Date]@row))
Best Answers
-
Hi @cmondo,
I believe this is happening because the underlying dates and times in Smartsheet are all in the UTC time zone. Hypothetically speaking, if you're located in the Central Time zone, anything created after 6:00 PM would reflect the next day.
If needed, more information on this can be found here: https://help.smartsheet.com/articles/1108408-auto-numbering-rows#advanced
-
@cmondo we typically communicate about new or improved features once they’ve been released, but I'd encourage you to submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.
Answers
-
Hi @cmondo,
I believe this is happening because the underlying dates and times in Smartsheet are all in the UTC time zone. Hypothetically speaking, if you're located in the Central Time zone, anything created after 6:00 PM would reflect the next day.
If needed, more information on this can be found here: https://help.smartsheet.com/articles/1108408-auto-numbering-rows#advanced
-
Thanks @Alejandra! Is there any development to adjust this per account/sheet in the future? This seems to be a common problem in a few other threads. Thank you!
-
@cmondo we typically communicate about new or improved features once they’ve been released, but I'd encourage you to submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 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
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!