Can you give an example of such a formula? We need to have the Account and Opportunity names as part of our custom object, and the person (not me) who designed it did it by creating custom fields and making them lookups. This works except that it is an indirect relationship and so the Opportunity lookup is not filtered when choosing the Account, and vice versa. We need them to be directly related. Anybody know why you can't have other standard fields in custom objects?
You could create custom fields which work similarly
If you want exact values from a standard object you could use URLS or S-Controls
Kaushik
I figured out a much simpler way to do this.
Use the formula editor and select the appropriate merge field from the $User profile.
Thanks