I have seen a few tickets with this general solution, but I have a thought about how this would work and how I would like it to update and need some input on how to make it work.
I have a trouble ticket. I need to know the number of days this ticket is open.
I need to know:
1.) Number of Days Open from Opening Day to Today
2.) Number of Days Open from Opening Day to Closed
3.) Stop after Closed
and I need both of these to exist within a If/Else type of statement so that it stops counting once Status = Closed
From what I have read the problem is refreshing. If I somehow refreshed tickets with a workflow, I would be alright with that, and then just have an end workflow to where if any updates were made to a ticket after it was closed the dates wouldn't change. Any input would be helpful, but I think this approach makes sense, just not sure how to implement something like this.