Parent task in a project report
Hi folks, trying to get a Project report to display a column pulling in a specific task start date.
Its a parent task (because the child starting task for the section can change but we want to see when Data team starts).
the task name starts with “Data | “ - the rest of the task name might change as they put in the audience name or date etc, so trying to use a contains.
Heres what i tried from a previous post by
displayname=Strategy Comp
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true type=iterate
valueexpression=IF({numberOfChildren}>0&&CONTAINS("Strategy",{name}),{actualCompletionDate})
valueformat=HTML
But it is pulling in the start date of the project rather than the related task.
See my version below, i was hoping to isolate the Task rather than project, but im not getting anything.
valueexpression=IF({numberOfChildren}>1&&CONTAINS("Data",{name}),{task}.{actualStartDate})
valueformat=HTML
Thanks for the help & any ideas!