Hello All,
I have created an hour report to display all the hours logged in by users for projects. I am able to display timesheet approver name and timesheet status. How can I display timesheet approval date in Workfront report?
Thank you in advance!
Deepa Mahishi
Hi @deepama1,
Thank you for your question! In Workfront, the timesheet approval date is not directly available as a standard field in reports. You can look at the lastUpdateDate field instead and include an expression to ensure that it was last edited by the approver and that the timesheet is currently closed.
Navigate to your existing report and add a new column; then switch to text mode and paste the following:
displayname=Timesheet Approval Date
linkedname=direct
namekey=timesheet:lastUpdateDate
querysort=timesheet:lastUpdateDate
valueexpression=IF({timesheet}.{lastUpdatedByID}={timesheet}.{approverID}&&{timesheet}.{status}="C"&&!ISBLANK({timesheet}.{lastUpdatedByID}),{timesheet}.{lastUpdateDate},"")
valueformat=longAtDate
- Monica
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.