Hour Report: Help with text mode for custom column to provide link to the referenced timesheet

[AndrewGr1]

Accepted Answer:
displayname=Timesheet Link
textmode=true
valueexpression=CONCAT("https://YOURDOMAIN.my.workfront.com/timesheet/", {timesheet}.{ID},"/overview")
valueformat=HTML

We have a report built to show any errors that occurred when using Fusion but the hour report doesn't provide a link directly to the timesheet where the referenced hours had an issue. 

Does anyone know if there's text mode possible to provide a link to the timesheet within an Hour report?

If it helps, in a Timesheet report, this is the text mode for the native column that you can use for this link:
link.linkproperty.0.name=ID
link.linkproperty.0.valuefield=ID
link.linkproperty.0.valueformat=val
link.page=/timesheetOpenTime.cmd
link.valuefield=objCode
listsort=atDateAsAtDate(startDate)
namekey=daterange
querysort=startDate
valueexpression=CONCAT(DATENOTIME({startDate}),' - ',DATENOTIME({endDate}))
valueformat=val
width=80

Thanks!

[skyeh · Accepted solution]

When I open up any timesheet, the URL appears to be in the following format:

https://yourdomain.my.workfront.com/timesheet/GUID/overview

tentatively (not having tried this myself), I would probably say that you may end up needing to build this link by referencing the timesheetID from your hour entry and then concatting the rest of the URL around it. An example showing this kind of concat can be found in the following post response:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/is-it-possible-to-pull-project-...

[AndrewGr1]

Thanks!

This text mode seems to be doing what I want. 
displayname=Timesheet Link
textmode=true
valueexpression=CONCAT("https://YOURDOMAIN.my.workfront.com/timesheet/", {timesheet}.{ID},"/overview")
valueformat=HTML