Length of Time in a Status | Community
Skip to main content
J
JSanto16
Level 2
June 24, 2025
Solved

Length of Time in a Status

  • June 24, 2025
  • 4 replies
  • 642 views

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!

Best answer by ChrisStephens

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-concept/m-p/487997

4 replies

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity Advisor
Community Advisor
June 24, 2025

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
    TimothyBr
    Level 4
    June 24, 2025

    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. 

      J
      JSanto16Author
      Level 2
      June 24, 2025

      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
      Community Advisor
      ChrisStephensCommunity AdvisorAccepted solution
      Community Advisor
      June 24, 2025

      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-concept/m-p/487997

        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        July 16, 2025

        @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!

        Kautuk Sahni
        J
        JSanto16Author
        Level 2
        July 17, 2025

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

        Terms & ConditionsAccessibility statement

        Loading footer...