function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SBP Admin UserSBP Admin User 

Cross object Formula field referencing standard object

Hi There,

I have a custom object called SBP, On the object I have 2 look up fields to the Contact object "Principal" and "SBP Coordinator"
I'm trying to build a custom formula field which will provide the Principal email address from the Contacts oject and another formula field for the SBP Coordinator email address. 
In the Custom formula field creator these fields are not available.
Can I simply write out the formula manually something like "Principal_{!Contact_MyEmail_c" to get it to work?
Or is there an issue as due to 2 formula fields?

Thanks
Best Answer chosen by SBP Admin User
Rupal KumarRupal Kumar
Hi SBP,
simply write you writte formula for  SBP Coordinator email address= Contact__r.Email
                                                               And other formula is=SBP_Coordinator__r.Email

contact have relationship SBP  so when mve on lookup field


User-added image
when you create formual then you go Advance formala and go according to above img.


Thanks
Rupal Kumar
http://Mirketa.com

All Answers

Rupal KumarRupal Kumar
Hi SBP,
simply write you writte formula for  SBP Coordinator email address= Contact__r.Email
                                                               And other formula is=SBP_Coordinator__r.Email

contact have relationship SBP  so when mve on lookup field


User-added image
when you create formual then you go Advance formala and go according to above img.


Thanks
Rupal Kumar
http://Mirketa.com
This was selected as the best answer
SBP Admin UserSBP Admin User
Thank you Rupal. This has resolved my question.