Thank you. That's what I was thinking initially, using exists. Combining IF and EXISTS to do something like IF copywriter exists return their name, if not and copy leadership exists return their name. That way it would all be in one report and only one name would be returned each time.

When using this method, it returns both values when present, not just the first value once the condition is met as truedisplayname=Copywriter listdelimiter=<br> listmethod=nested(projectUsers).lists type=iterate valueexpression=IF({user}.{role}.{name}="Copywriter",{user}.{name}, IF({user}.{role}.{na...

Yes, this works when only one of the two roles is on a project, however since most projects have both roles, using IFIN returns both values for those projects, which is not what we want. We only want one or the other, not both.

Hi All,We have a report that returns the users name for a specific role type in a project. The text looks like this:displayname=Copywriter listdelimiter=<br> listmethod=nested(projectUsers).lists type=iterate valueexpression=IF({user}.{role}.{name}="Copywriter",{user}.{name}) valueformat=HTMLThis wo...