Sample Account Management Formulas

For details about using the functions included in these samples, see Formula Operators and Functions Overview.

Account Rating

This formula evaluates Annual Revenue, Billing Country, and Type, and assigns a value of “Hot,” “Warm,” or “Cold.”

In addition, you can reference this Account Rating formula field from the contact object using cross-object formulas.

Account Region

This formula returns a text value of “North,” “South,” “East,” “West,” or “Central” based on the Billing State/Province of the account.

Contract Aging

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.