Tracking Project Duration On Hold | Community
Skip to main content
P
Pat_Paterson
Level 4
December 16, 2022
Solved

Tracking Project Duration On Hold

  • December 16, 2022
  • 3 replies
  • 1402 views

Is there a way to track the duration of time a project has spent in the "On Hold" Status?  If its two separate formulas I know I can use a third WEEKDAYDIFF formula to calculate the duration, but I'm not sure how to get the time stamps of when the project went "On Hold" and when it came off of "On Hold".

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

    I really don't know if there's a way to do this outside of a journal report (which would make it several different line entries and therefore manual effort subtracting line entries from each other).

     

    Even using a calculated field to capture the different timestamps would still involve manual effort (as far as I picture it).

    3 replies

    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe ChampionAccepted solution
    December 19, 2022

    I really don't know if there's a way to do this outside of a journal report (which would make it several different line entries and therefore manual effort subtracting line entries from each other).

     

    Even using a calculated field to capture the different timestamps would still involve manual effort (as far as I picture it).

      Jason_JB
      Jason_JB
      Level 5
      December 21, 2022

      Hi - I have an idea based on something else we've done, but would it be acceptable to only have the most recent time a project moved to a status = "on hold".  Meaning it would not be cumulative if a project goes on hold multiple times.

      P
      Pat_PatersonAuthor
      Level 4
      January 5, 2023

      Yeah, unfortunately we're trying to capture the cumulative time a project has spent "On Hold".

      Jason_JB
      Jason_JB
      Level 5
      January 6, 2023

      Is using Fusion an option?

      Without Fusion what I'm picturing is messy (and has some ***), but my friend @doug_den_hoed__atappstore has helped us get something similar.

       

      Essentially what I think would work, is a set of custom fields:

      • Time on hold: calculated field
      • Most recent on hold start: calculated field
      • Most recent on hold end: calculated field
      • Possibly a change log

      The calculated fields would need to be on the project object. They would use a formula that looks at current value of status, date, and prior value of the field.  I'll include screenshots of what we previously built.  (As a disclaimer, we're not using these in a current report - and I saw an error message based on changes WF has made in one of the formulas.)

       

        Madalyn_Destafney
        Community Advisor
        Madalyn_DestafneyCommunity Advisor
        Community Advisor
        January 6, 2023

        Gotta be a way to do this. I just spent some time trying in a journal entry report to pull in only projects in on hold status, and from there messing with the scope/top objid/columns/filters but not cracking the case but I suggest going in the route of a journal entry report.

        If this helped you, please mark correct to help others : )
          Terms & ConditionsAccessibility statement

          Loading footer...