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.

  • ClientSide solution: Build a report using REST api and moment.js. Add export to excel capability.
    – Aveenav
    Commented Jul 14, 2016 at 20:44
  • You can set calculated column as mentioned in this answer (It will shows the days count as per daily basis): sharepoint.stackexchange.com/questions/171222/… Commented Jul 15, 2016 at 4:00

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 you have read our privacy policy.

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