Text Moding Adjustment from Project Report to Hour Report

[WF_Admin_Dell_Tech]

How do I update the following text mode field in a Project Report to show up for me in a Hour Report:

displayname=Asset Release date
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({milestoneID}="65eb4286001da5f4059b8acb3e9c4ab8",CONCAT("",{plannedCompletionDate}),"")
valueformat=HTML

[VictoriaLinn]

Hi @WF_Admin_Dell_Tech - The above is a collection text mode, which on an hours report the only collections available are for objectCategories and parameterValues. Collection text modes usually work better at the top of the object hierarchy (ex. project) to pull information up from objects below it (ex. tasks). 

What are you looking to achieve here? There might be a different solution. Unfortunately, on an hours report, you can't say for this hours record, hop to the related project, to then pull up task information (too many jumps).

[WF_Admin_Dell_Tech]

Not sure, I just know the user wants to see the Asset Release Date on the hours report and so I pulled the custom data from a project report that was created and was hoping I could make some adjustments and pull the same information into an hour report. 

Could I make a calculated field on the custom form to pull the data?

[VictoriaLinn]

Ah, unfortunately, no. Calculated fields can't pull up information to a custom form (only possible on reports). You could probably explore a Fusion scenario if worthwhile to write the information into the custom form from the task. 

[WF_Admin_Dell_Tech]

Okay. Thank you. I appreciate your help!