Skip to main content
Level 9
January 31, 2020
Question

Timestamp of Project Status Change

Team, Before I take tedious precious time that I do not have to do this - I want to check with the community to see if this is the right course of action or if there are better more efficient solutions. I have 6 project status that I need to report on the time in that status. I found this on WF website - so do I just create 6 timestamp custom fields in my custom form - then do my reporting? Display a Status timestamp in a Custom Form Navigate to a Custom form where you want to add the field. Add a Calculated Custom Field to the form. Specify a Label for the Custom Field, for example: Status Timestamp Custom Field . Click Save+Close . Re-open the Custom Form, and select the new Status Timestamp Custom Field. In the Calculation field, specify the following calculation for your Custom Field: IF(Status='INP',IF(ISBLANK({DE:Status Timestamp Custom Field}),$$NOW,{DE:Status Timestamp Custom Field}),{DE:Status Timestamp Custom Field}) Note: You must always use the three letter key for the Status in this calculation. For more information about the keys for Statuses, see Creating and Customizing Statuses in Workfront . Click Save+Close . You can then report on the Status Timestamp Custom Field, or use it in other calculations in reports or Custom Fields. Note: If your status changes to INP, then another status, then back to INP, only the timestamp of the first change to INP will be captured. Benetta Perry APS
Ce sujet a été fermé aux réponses.