Calculated Field to pull Project Owner Home Team

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Richard_Le_

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.

Accepted solution