formula Help - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Charlotte Godet DaillCharlotte Godet Daill 

formula Help

Hello ! need help with a formula field. I would like to create a formula that allows me to get an email from a contact and also a formula to get a date. Any ideas ?
Best Answer chosen by Charlotte Godet Daill
Usman AliUsman Ali
Hi Charlotte,

Create a formula text field and formula date field and use Contact lookup field on your object pull Email and Date field.

Please make sure you are using correct Contact Lookup API name in below formula. If lookup is standard field then you can replace Contact__r with only Contact.

Email Formula.
Contact__r.Email
Date formula.
Contact__r.DateField__c

 

All Answers

Usman AliUsman Ali
Hi Charlotte,

Create a formula text field and formula date field and use Contact lookup field on your object pull Email and Date field.

Please make sure you are using correct Contact Lookup API name in below formula. If lookup is standard field then you can replace Contact__r with only Contact.

Email Formula.
Contact__r.Email
Date formula.
Contact__r.DateField__c

 
This was selected as the best answer
Charlotte Godet DaillCharlotte Godet Daill
Thank you very much Usman ! Done !