Custom grouping to show all projects assigned to a specific designer

[EmeraldWe]

Hi there! 

In one of my project reports I've created a custom column to show who the specific designer is on each project using the below formula in text mode: 

displayname=Designer
listdelimiter=
listmethod=nested(projectUsers).lists
textmode=true
type=iterate
valueexpression=IF(CONTAINS("Designer",{user}.{role}.{name}),{user}.{name})
valueformat=HTML

What I would like to do next, is be able to group those projects by the specific designer so we can see all projects assigned to Designer A, for example. I know we can leverage the workload balancer for similar details, but I was hoping to accomplish this view within a specific report. So far I have been unsuccessful in identifying if/how this can be done. 

Any thoughts? 

TIA

Emmi

[lgaertner]

Hi,

that's a tricky one, but really interesting. 

At the moment I do not have a solution ready. To have more chances to get input on this, you really should move the question to the main Workfront community, as it's now under Workfront Fusion.

Regards

Lars