Calculated field to pull in requester's home group

Forum|Forum|7 months ago
June 13, 2025
2 replies
537 views

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

Workfront

Best answer by JustinRenteria2

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:

Madalyn_Destafney

Community Advisor

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

If this helped you, please mark correct to help others : )

JenniferLegateAuthor

Level 2

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

Level 6

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

JustinRenteria2Accepted solution

Level 6

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:

JenniferLegateAuthor

Level 2

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded