We also have a Notes report that monitors when someone makes a comment or document upload (attachment action) on a request that's been converted to a project. NOTES REPORT Issue > Resolving Object Type EQUAL Proj Note > Audit Type EQUAL Note;Attachment Action We went a little bit further and attached a Status Timestamp field onto the original issue to track when the issue was converted to a Project. Then we added a filter to only show notes/attachment actions after the conversion time. We made the timestamp for when the issue had the status "In Progress", since when you change the resolving project's status to "Current", it makes the issue's status "In Progress". From there, the extra filter would be Issue > {Your Timestamp Field Name} LESS THAN Note > Entry Date In text mode, it's DE:opTask:Your Timestamp Field Name=FIELD:entryDate DE:opTask:Your Timestamp Field Name_Mod=lt I've included the instructions below for making a timestamp field.
Displaying a Status Time Stamp 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 "https://support.workfront.com/hc/en-us/articles/216668458" "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 that 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.
Vincent Goodwin The Capital Group Companies