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

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