Netdays Negative Return

Chris Mondeau

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))

Alejandra

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

Alejandra

@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. 

 

Alejandra

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

Chris Mondeau

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!

Alejandra

@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.