Length of Time in a Status

[JSanto16]

Hi, 

Does anyone know if we can capture the length of time an issue/task/project has spent in each status throughout the course of the object being open to close? I know I can create a calculated field for 1 status, example : time stamped for when it was changed to in progress. 

Is there a way to have one field that would show the timestamp for each status such as On Hold, Awaiting Feedback etc... or do I need to create separate fields for each status?

Thank you!

[Rafal_Bainie]

Hi there,

not sure if that would be an option for you, but we use Fusion to create an update whenever a status gets updated. Running journal entry report in that case gives a good overview of when status gets updated.

One other thought that comes to my mind is using actual start and completion dates as reference points, but this is dependant on your instance configuration. For us setting task to "in progress" records actual start time, and marking task "Completed" is recorded as actual completion date. This along with entry date (when task is simply NEW) gives pretty good basic understanding of the task lifecycle.

Hope this helps

Rafal

[TimothyBr]

We use Fusion to populate up to 5 fields per status that captures time put in the status, time moved off the status, and then it calculates the total time. So this is a mix of Fusion and calculated fields to show the entire duration something was in a task status knowing that it can go in and out of a status multiple times. 

[JSanto16]

Hi @TimothyBr would you be able to share a screenshot of your fusion module that captures the time put in the status, time moved off the status?

[ChrisStephens · Accepted solution]

You could try a calculation something like this, possibly?

LEFT(IF(LEFT(Status History,LEN(IF(ISBLANK(Status),"-",Status)))=Status,Status History,CONCAT(IF(ISBLANK(Status),"-",Status)," (",$$NOW,") | ",Status History)),2000)

Source: 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-conc...

[kautuk_sahni]

@JSanto16 Just checking in — were you able to resolve your issue?
We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

[JSanto16]

I was able to create it using the link provided! https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-conc...