Calculated Field to pull Project Owner Home Team

[MichelleFr2]

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?

[Richard_Le_ · Accepted solution]

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.