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".
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).
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:
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.)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
