Project Report Calculated Field Change from Home Team to Other Team

[MichelleFr2]

I need help changing this calculated field (on a Project Report) from pulling the Project Owners Home team to Project Owners Other Team ID:

owner:homeTeamID=

owner:homeTeamID_Mod=in

[ChristinaJay]

did you try owner:teamID=?

[MichelleFr2]

yes and I get this error

[Kurt_Jones]

Michelle,

You can't get to that info via a calculated field, however, on a project report you should be able to search in the column for Owner->Other Groups and that will provide you the other groups the owner is in.  Once found, if you put that field in textmode it looks like below:

viewalias=owner:otherGroupsNames
linkedname=owner
namekey=view.relatedcolumn
namekeyargkey.0=owner
namekeyargkey.1=otherGroupsNames
valueformat=HTML
tile.name=component.othergroups.names

[kautuk_sahni]

@MichelleFr2 just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!