Add column to Project Report that lists all Assignments on a specific task

[nryan2]

I'm trying to list all users assigned to a specific task on a Project Report but I am only able to list the primary assignee. 

This is what I have. I tried changing "assigned to" to "assignments" but that didn't work.  

displayname=Task Assignments
listdelimiter=<div>
listmethod=nested(tasks).lists
type=iterate
valueexpression=IF({name}="Product Strategy Due",{assignedTo}.{name},"")
valueformat=HTML

Does anyone know how to list all assignees?  

[Kurt_Jones]

Nryan,

Contains might work better here, 

displayname=Task Assignments
listdelimiter=<div>
listmethod=nested(tasks).lists

textmode=true
type=iterate
valueexpression=IF(CONTAINS("Product Strategy Due",{name}),{assignedTo}.{name},"")
valueformat=HTML

[KatherineLa · Accepted solution]

Hi Nryan,

Unfortunately, this is not possible with text-mode. You are trying to reference a collection (Assignments) of a collection (Tasks). 

This is one of the examples specifically noted in the documentation as not supported, see under 'Limitations of a collection View'.

Collections Reporting 

If I absolutely HAD to do it, the only way I can think of would require a custom form on every task. You could create a calculated field on the form that aggregated together all the people assigned and then pull that field into your project report. That would be a LOT to set-up and somewhat error-prone as changes to the assignees wouldn't necessarily cause the field on the form to recalculate.