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

Find more posts tagged with

Formulas

functionality

Accepted answers

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.

All comments

Alejandra

Hi @cmondo,

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.