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