function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ted3423141234ted3423141234 

Last Name First, First Name Last for Pipeline Reporting

Does anyone have a formula field for taking the opportunity owner and having it present last name first, first name last?  Thanks

Ankit AroraAnkit Arora

We can't fetch Owner Name directly in formula field. We only have the option to select the Id of Owner. So to do this you need to go a bit long way.

 

First create a lookup of User on opportunity and when the record is updated or inserted the ownerId should be inserted in the New lookup field (you can do this by trigger).

 

Now you can create a formula which will display the FirstName and LastName of Owner like this :

 

User__r.LastName + ' ' + User__r.FirstName

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page