I have a team member object. Team member have a master detail relationship with "Team" object and a lookup relationship with "User" object. The lookup field for User object is labelled as "Related User" and its API name is "Users__c".
I need a formula field to display the profile name of the user object(lookup relationship - Users__c) in team member object . The name of this formula field is "User Profile".
I could display the profile name of the "User__c" in team object as shown in below screenshot.
But the problem I face is, the profile name when displayed in related list, i.e when team member is shown as related list in "Team" detail page of a record, it is shown as "PT1" as shown in below screenshot.
Formula I used for "User Profile" field is :- Users__r.Profile.Name. Please Help.