Nice one Theresa,
It took half a coffee to solve (as it turned out) so I can now offer a way to report on this, but as it is based on my Targeted Auditing Proof Of Concept, I will leave it to you to decide if it qualifies as "easy":
- Set up a datetime calculated custom parameter (e.g. "First Current Date") on the Project custom form(s) attached to every project of interest
- Save (or "Apply") the form with no formula yet, so Workfront "registers" First Current Date
- Edit the form again, and this time, set the new formula to IF(ISBLANK({DE:First Current Date}),IF(Status="CUR",$$NOW,{DE:First Current Date}),{DE:First Current Date})
- Hmm....without the ability to colorize the formula, I'll just say it in English: If the First Current Date is blank, if the Status is CUR (meaning it JUST turned to Current, as that edit is being made), the put $$NOW into the First Current Date ("locking" it, even if the status then later changes to PLN and back to CUR, etc. since), otherwise (if it's not yet CUR) leave First Current Date as it was (i.e. blank), otherwise (if First Current Date is already filled in) leave First Current Date as it was (i.e. preserving the initial "Locked" value)
With that tricky but useful bit complete, the "locking" pattern established, and the DATEDIFF calculated expression in hand:
- add a numeric custom parameter (e.g. "Request To Current In Days") on the Issue custom form(s) attached to every Request of interest
- Save the form with no formula yet, so Workfront "registers" Request To Current In Days
- Edit the form again, and this time, set the new formula to IF(ISBLANK(Resolve Project.First Current Date),Request To Current In Days,ROUND(DATEDIFF(Entry Date, Resolve Project.First Current Date),0))
From there, you can then view, group, filter, and CHART on the Request's Request To Current In Days.
Regards,
Doug
