+ Start a Discussion

Lead & Contact Name on Formula Field

I have a lookup to a lead & contact on a custom object. I would like to create a formula field that displays the Lead Name or the Contact Name. But neither the lead name or the contact name shows as a field on the related list when inserting the field into the formula. If i try to use the API name "Lead__r.Name" it says "Error: Field Name does not exist"





Is it possible to get the name field for a contact or lead in a formula? I can get it for custom objects, seems very odd? I know i can create it but this doesn't seem right that its not available.

Message Edited by jadent on 10-13-2009 09:20 AM