Salesforce Hyperlink Formula
Sometimes it’s not at all useful having a link from a lookup field displayed as an meaningless auto generated reference – especially when these are displayed in list views. It would be much nicer if the link actually meant something, like the name of a product or a property for example.
You can do this by creating a text formula field containing a hyperlink to the record, and incorporating any other field, like a name or description… see the example below:
HYPERLINK( "/" & Id , OtherObject__r.Name, "_self")
HYPERLINK(url, friendly_name [,target]) and replace url with the web address, replace friendly_name with the link text, and, optionally, replace target with the window or frame in which to display the content.
This way your end users will know exactly which records they’ll see and where to click avoiding any confusion and keeping them happy!