I want to define a formula field to have the value of the Name field of a lookup field. I tried something like this:
where "Lead" is a lookup field pointing to a lead. However, the formula builder complains that "Name is not a field". When I use "Insert Field", and click on the Lead lookup field, it shows me all the expected fields on Leads except Name. Is there something special about Name? What am I missing?