Counting days of ticket open but starting at 0?

Jeremy Y O · 2024-07-24T14:41:27+00:00

There was an error rendering this rich post.

I asked this question before and got a solution but now it is counting starting at 1 instead of 0. this is the formula used

=IF([Date Closed]@row = "", NETWORKDAYS([Date Opened]@row, TODAY(0)), NETWORKDAYS([Date Opened]@row, [Date Closed]@row))

I tired using (today -1) but then it starts at -2. The date closed is an automation that captures the date based on if the status is changed to closed. The date opened is the created date option.

I would need it to say 0 if it is closed on the same day opened as smartsheet cannot track by the hour unless someone knows a way to do that.

Find more posts tagged with

Formulas

Automations

Accepted answers

All comments

Jeremy Y O

Hi @Sing C

It worked perfectly thank you so much!

Sing C

Hi @Jeremy Y O,

Have you tried adding a -1 to the end of each instance of NETWORKDAYS? That should give you what you're looking for.

=IF([Date Closed]@row = "", NETWORKDAYS([Date Opened]@row, TODAY())-1, NETWORKDAYS([Date Opened]@row, [Date Closed]@row)-1)

Also, the TODAY function doesn't require the 0.

Let me know if that gives you what you need.

Thanks and have a great day!

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.