Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
SOLVED

Calculated Field to pull Project Owner Home Team

Avatar

Level 1

I am trying to build a field that will pull the home team of the Project Owner.

 

I was successful in pulling the project owner: 

CONCAT({owner}.{name})
 
But when I adjusted the field to try an pull their home team, I received an NA on the project custom form.
 
CONCAT({team}.{owner}.{name})
 
What am I doing wrong?
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hey,

 

Using the below in your calculation should do the trick:

 

{owner}.{homeTeam}.{name}
 
You don't need the "CONCAT" operator in your expression since you're only pulling one value into the field.
 
Best regards,
Rich.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hey,

 

Using the below in your calculation should do the trick:

 

{owner}.{homeTeam}.{name}
 
You don't need the "CONCAT" operator in your expression since you're only pulling one value into the field.
 
Best regards,
Rich.