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.


2 Answers 2


I think that what you're thinking will work. You'd have to write a workflow to pause for 24 hours, then update the item so that the calculated columns got updated. Or you might just set the values from the workflow rather than using a calculated column. If you're in 2013, you could loop the 24-hour pause in a while statement to stop running once the ticket is closed. In 2010, you'd have to just have the workflow run on every edit and the first step of the workflow would be to terminate the workflow if the ticket is closed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.