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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!