Dear Erica, There's a couple of steps here. You can put a filter on your task report based on number of children (greater than 0 or not null) to only show parent tasks. You may be able to filter more (e.g. if you have 15 'setup' tasks, maybe task number >15 AND number of children >0, or maybe parent task name = 'Deliverables' AND number of children >0) So once that's worked out, (yippee) we've got the tasks we want information on working, just not the information. To see information about a 'child' of an object in Workfront, you use a collection report. A project has a collection of tasks, for example, Or a team has a collection of users in the team. The API Explorer tells us a task has a collection called 'children'. To do a collection report, you add a column and convert it to text mode. To list everyone assigned to a child task, we would use the following: valueformat=HTML textmode=true type=iterate listdelimiter= displayname=Assignees listmethod=nested( children ).lists valueexpression={ assignedTo}.{name} That would get everyone assigned to a child task. To further limit this to just graphic designers, we would modify the last line: displayname=Graphic Designer(s) listdelimiter= listmethod=nested(children).lists textmode=true type=iterate valueexpression=IF({role}.{name}='Graphic Designer', {assignedTo}.{name}) valueformat=HTML Note that the term Graphic Designer between the single quotes needs to be an exact match to the job role name (including use of capital letters). As it stands, it will add a blank line for each sub-task that doesn't have a graphic designer, and a name for each task that does. If you have a lot of sub-tasks that aren't graphic designers, you may prefer a slight variant: displayname=Graphic Designer(s) listdelimiter= listmethod=nested(children).lists textmode=true type=iterate valueexpression=IF({role}.{name}='Graphic Designer', CONCAT(' :',{assignedTo}.{name})) valueformat=HTML This will put all the entries on one line, and if there happens to be more than one graphic designer, separate them with a : and a space (many thanks to Doug Den Hoed for picking up that tip in one of his many, many valuable posts). Barry Buchanan - WMA Work Management Australia
