Report Help: Capturing specific tasks that have been In Progress for more than 5 days | Community
Skip to main content
E
EAnderson-1
Level 1
June 30, 2026
Solved

Report Help: Capturing specific tasks that have been In Progress for more than 5 days

  • June 30, 2026
  • 2 replies
  • 94 views

Hello! 

I am trying to create a report that tracks Client Review tasks that have been In Progress for more than 5 days. I’m assuming I will use a Task Report and include status and name but I am getting stuck when it comes to the “In Progress for more than 5 days" Would that require Text Mode for a calculation? 

Any ideas are greatly appreciated!

Best answer by skyehansen

if this is for client review tasks that are currently in progress you could also try a journal entry report and pull up everything in progress and when the journal entry was entered. Otherwise, I would agree with Nino which is that you timestamp your task.

 

  • upside to timestamping your task: being able to have the historical record for further analysis
  • downside to timestamping: you need to have a custom form on every client review task
  • downside to timestamping: will work going forward but not for anything already in that status
  • upside to journal entry report: it’s available and works for everything currently in that status, and no custom fields and forms necessary
  • downside to journal entry report: it’s pretty darn impossible to get any historicals that would allow you to easily run analytics. Although you could definitely do it.
  • downside to journal entry report: works well for the initial job of “this is what we have for anything entry date < 5” but terrible for “and here’s a link you can click on to take you there”

2 replies

ninoskuflic
ninoskuflic
Level 5
June 30, 2026

You would somehow need to capture when the task was put in that specific status. What you can do is have a calculated field that will “bake in” when status = INP; and then use that date to check if it’s more than 5 days. If yes, you would then display it in a report. 😃

If this solved your issue, please mark it as solved so others can find the solution faster.
    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe ChampionAccepted solution
    June 30, 2026

    if this is for client review tasks that are currently in progress you could also try a journal entry report and pull up everything in progress and when the journal entry was entered. Otherwise, I would agree with Nino which is that you timestamp your task.

     

    • upside to timestamping your task: being able to have the historical record for further analysis
    • downside to timestamping: you need to have a custom form on every client review task
    • downside to timestamping: will work going forward but not for anything already in that status
    • upside to journal entry report: it’s available and works for everything currently in that status, and no custom fields and forms necessary
    • downside to journal entry report: it’s pretty darn impossible to get any historicals that would allow you to easily run analytics. Although you could definitely do it.
    • downside to journal entry report: works well for the initial job of “this is what we have for anything entry date < 5” but terrible for “and here’s a link you can click on to take you there”
      Terms & ConditionsAccessibility statement

      Loading footer...