I would like to create a formula field on the oportunity that looks up the "FirstName" of the related contact. To complicate matters we may have more than one contact related to an opportunity, so I want to get the primary contact, which may be assigned by another field called "PrimaryContact__c". 

Is this possible with a formula field? Do I need to write a soql query to accomplish this? What's the best way to make this work?

Thanks in advance for your help!

Hi All,

I have requirement to create dash board for opportunity with the condition of opportunites woned/opportunites woned +opportunites Lost. Any one can help to achieve this functionality in reports. 

What is the process for resetting a password for trailhead when the email address that is there may be wrong and the reset link is not working?