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
SFDC palaceSFDC palace 

Custom Formula Field - New Merge Field

Any of clever people know how to create a formula field that will look up the Owners Telephone number from the user record.
The $User Merge fields, only put the current users phone number not the owner, is there any way to create a formula to do this?
The reason for this is we use Exact Target Email tool, and they ahve recently upgraded and now you can only include contact or Lead fields on your email templates.   It would be nice to have the owners phone number on the emails. 
Of course I could create and populate a standard custom field, but would prefer it to recalculate when owner changes.
Appreciate any suggestions.

SFDC Palace,

I know this isn't ideal, especially if you have a high number of employees.  I have attached the formula for formula(text) field that would do what you are looking for.  Besides this I don't know of a way of doing this except through a sControl.

IF(  CONTAINS(OwnerId , "hAqD") , "Phone One",  IF(  CONTAINS(OwnerId , "i0by"), "Phone Two", "Phone Three") )


I wish there was an easier way of doing this....