function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Matt van WijkMatt 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?
Best Answer chosen by Matt van Wijk
V V Satyanarayana MaddipatiV V Satyanarayana Maddipati
Matt, Change the formula to   Team_Leader__r.Name