Expand my Community achievements bar.

Update Stream - Track Status date/time changes

Avatar

Level 8

6/6/18

It would be helpful to know how long an issue or task was in a status. Today you can only see the current status and one prior, but not even the date/time it changed. We would like to see the date/time change of each status so we can report on how long each action took. Thanks.

1 Comment

Avatar

Level 1

8/14/19

EVERYONE ON THIS THREAD, YOU SHOULD MOVE YOUR COMMENTS AND VOTES TO A SIMILAR IDEA AT: https://experience.workfront.com/s/idea/0870z000000PSBEAA4/detail. IF WE CAN CONSOLIDATE OUR VOTES TO JUST ONE IDEA, WE CAN GET MORE TRACTION ON THIS.



Agreed! When a status is changed, it gets logged in the Updates with a timestamp, but this data is not accessible for reporting.


I have found the calculated field you can create to capture the timestamp of a status change:

IF(Status='INP',IF(ISBLANK({DE:Status Timestamp Custom Field}),$$NOW,{DE:Status Timestamp Custom Field}),{DE:Status Timestamp Custom Field}).

The problem with this equation is that it uses the $$NOW wildcard, which works great for status changes going forward, but does not work on past status changes. If you open the task after attaching the custom form, the timestamp for the past status change, gets logged as today's date ($$NOW), which is incorrect.


Please provide a way to capture status changes and then for users to retrieve that data for reporting. If you did this, it would be a powerful tool for putting metrics to processes. You can reduce the time of your process if you don't have the data to show where to improve.