Report Question: Can you report on date project status changed to CURRENT and then how long in that status? | Community
Skip to main content
C
cwatson
Level 4
September 15, 2020
Question

Report Question: Can you report on date project status changed to CURRENT and then how long in that status?

  • September 15, 2020
  • 1 reply
  • 397 views

We're looking to get a better handle on projects that have been open too long (started but dragging or incomplete potentially due to resource constraints). Is it possible to build a report that:

  • looks at the date when Project Status was changed to CURRENT
  • then reports on any projects that are still CURRENT four weeks later?

We don't want to use the start date as that clock seems to starts ticking as soon as any modification is made to a task, even if the project isn't set to CURRENT.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    September 15, 2020

    Hi Chris,

    Lots of ways to tackle this one.

    My favorite would be to use Targeted Auditing to capture the date time that the Project was switched to Current in a custom parameter, calculating a Target Completion Date that is 4 weeks later, then using the latter to filter for Projects whose Target Completion Date is < $$TODAY (but are not yet complete).

    If you happen to have the functionality that automatically creates a baseline when a Project is set to Currrent "turned on", another approach would be to run a Baseline report for any Baseline whose Entry Date < $$TODAY-4w (and whose Project is still not complete).

    Regards,

    Doug

    Terms & ConditionsAccessibility statement

    Loading footer...