Skip to main content
Topics#Data ManagementAnamika Singh's Question
Anamika Singh (CGI) asked in #Data Management
Nov 16, 2020, 4:21 PM

Unable to sort a custom Last Name-First Name formula field in my Contact List View

I added a custom formula field on the Contact object that displays the Last Name followed by the First Name, when  I try to sort this field in the List View alphabetically with some filter this doesn't seem to work properly.

 

Can someone please explain why this discrepancy? and how to solve this.

 

Thanks.
6 answers
  1. Lea Ann Morrison (TNTP)
    Nov 17, 2020, 5:05 PM
    The final output for the formula is a hyperlink, and therefore it appears to sort by the URL link.  While there are many articles that detail a solution, none of them seem to work as expected.  There is an idea noting this here (https://trailblazer.salesforce.com/ideaView?id=0873A0000003gXjQAI). 

     

    For now it looks like your best bet is to not use the hyperlink and just use the formula of (LastName & " " & FirstName), add the column to the list next to the standard Name column then direct your users to sort by new column but click on the Name hyperline to get to the record. Not ideal, but gets the user to the record.
Write an answer...
0/9000