Advanced Formula Fields in Salesforce.
Use the following formula samples when creating custom formula fields. For samples of other types of formulas, see Examples of Validation Rules and Useful Default Field Value Formulas.
This document contains the following categories of custom formula samples:
See Also:About FormulasOperators and FunctionsFormulas: How Do I...Tips on Building FormulasQuick Reference Guide: Formula Fields
This formula evaluates Annual Revenue, Billing Country, and Type, and assigns a value of “Hot,” “Warm,” or “Cold.”
IF (AND (AnnualRevenue > 10000000,
In addition, you can reference this Account Rating formula field from the contact object using cross-object formulas.
This formula returns a text value of “North,” “South,” “East,” “West,” or “Central” based on the Billing State/Province of the account.
This formula calculates the number of days since a contract with an account was activated. If the contract Status is not “Activated,” this field is blank.
CNN™ News Search
This formula creates a link to a CNN news search site using the Account Name.
This formula creates a link to an account's ticker symbol on the Marketwatch.com website.
This formula creates a link to a Google search site using the Account Name.
Google News Search
This formula creates a link to a Google news search site using the Account Name