You need to sign in to do that
Don't have an account?
SFDC palace
Custom Formula Field - New Merge Field
Hi
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.
Regards
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") )
Chris
:(