Counting days of ticket open but starting at 0?
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.
Answers
-
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!
-
Hi @Sing C
It worked perfectly thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!