Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Can anyone tell me how to calculate the age of an issue when it's closed? The native Age field continues to calculate after an issue has been closed. I want to know the time elapsed between entering an issue and closing it.

Avatar

Level 5
 
1 Reply

Avatar

Employee

Hi Melissa,

You have a few options.

#1) You can set up a report with a column using text mode, and a valueexpreesion similar to:

valueexpression=DATEDIFF({entryDate},$$TODAY)

OR

#2) You can create a calculated field that is applied to each issue you want the data on, with a similar expression as above, slightly modified: DATEDIFF(Entry Date,$$TODAY)

One thing to note if you go the field route is that custom data is not calculated every time you view it, only when it's changed, or another custom field from the same form on the same object it's on is changed.

Ex: If I update a different custom field on the same form on my issue, it'll update all the custom data on that field on that issue.

Good luck!