You need to sign in to do that
Don't have an account?

Formula for Opportunity Team Member Name
There are times that Salesforce.com really frustrates me!! You would think that it would be easy to just add a text formula custom field that would allow you to populate it with the Full Name of an Opportunity Team Member. What kind of gyrations to I have to get to a field that should otherwise be available for me to access through a standard database relationship. This is where having the ability to do a SOQL select query in a formula field would really come in handy. Come on Salesforce developers. What happened to common sense?!?
Only 3 years late!
With alot of those little child objects - you can just write out the formula - but it won't appear in the options when doing insert field.
For example
User.UserRole.name works when making a formula on the team member for example. I've done similar with opportunity splits.