You need to sign in to do that
Don't have an account?
Matt van Wijk
Concatenate formula that references a lookup field
I am trying to give a custom name to a campaign name, pulling from different values. One of those is a Team Leader, which is a lookup(contact) field.
When I use
"& Team_Leader__c"
it returns the contact ID.
When I use
"& Team_Leader__c.Name"
it produces an error saying "Error: Field Team_Leader__c does not exist. Check spelling."
Any thoughts on how I can get it to pull through the name of the Team Leader as displaying in the lookup field rather than the ID?
When I use
"& Team_Leader__c"
it returns the contact ID.
When I use
"& Team_Leader__c.Name"
it produces an error saying "Error: Field Team_Leader__c does not exist. Check spelling."
Any thoughts on how I can get it to pull through the name of the Team Leader as displaying in the lookup field rather than the ID?
Best Answer chosen by Matt van Wijk
V V Satyanarayana Maddipati
Matt, Change the formula to Team_Leader__r.Name