Calculated field to pull in requester's home group

[JenniferLegate]

Hello all you smart Workfront peeps!

Does anyone have a quick-and-dirty calculated field script that will allow me to populate the requester's home group name into a report (using it for report grouping)? TIA! Have a great Friday!

Jennifer

[Madalyn_Destafney]

Omg hey Jennifer!

You could just add Home Group ID, then in text mode change ID to :name to get this (example from pulling this in user report):
valuefield=homeGroup:name
querysort=homeGroup:name
valueformat=HTML
linkedname=direct
namekey=homeGroup:name

[JenniferLegate]

Hi Madalyn! Nice to see you. Yours is good advice, but I found Justin's solution a little more helpful for my use case. I appreciate your replying, though. Hope you are well!

[JustinRenteria2]

assuming this is an issues/task/project report the below will work:

group.0.linkedname=enteredBy
group.0.namekey=view.relatedcolumn
group.0.namekeyargkey.0=enteredBy
group.0.namekeyargkey.1=homeGroup
group.0.namekeyargkey.2=name
group.0.valuefield=enteredBy:homeGroup:name
group.0.valueformat=string
textmode=true

---

[JustinRenteria2 · Accepted solution]

Here's a few screenshots showing how to do this easily. Red highlights indicate text that need be deleted. Yellow highlights show what need to be added. It's super easy once you have a few edits done:

[JenniferLegate]

Thank you, Justin. This was the right answer and very helpful!