Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Custom grouping to show all projects assigned to a specific designer

Avatar

Level 1

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

1 Reply

Avatar

Level 8

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