Sample Account Management Formulas

Use these formulas to manage account details.

Available in: both Salesforce Classic and Lightning Experience

Available in: All Editions

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

Account Rating

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

1IF (AND (AnnualRevenue > 10000000, 
2CONTAINS (CASE (BillingCountry, "United States", "US", "America", "US", "USA", "US", "NA"), "US")), 
3IF(ISPICKVAL(Type, "Manufacturing Partner"), "Hot", 
4IF(OR (ISPICKVAL (Type, "Channel Partner/Reseller"), 
5ISPICKVAL(Type, "Installation Partner")), "Warm", "Cold")), 
6"Cold")

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

1Account.Account_Rating__c

Account Region

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

1IF(ISBLANK(BillingState), "None",
2IF(CONTAINS("AK:AZ:CA:HA:NV:NM:OR:UT:WA", BillingState), "West",
3IF(CONTAINS("CO:ID:MT:KS:OK:TX:WY", BillingState), "Central",
4IF(CONTAINS("CT:ME:MA:NH:NY:PA:RI:VT", BillingState), "East",
5IF(CONTAINS("AL:AR:DC:DE:FL:GA:KY:LA:MD:MS:NC:NJ:SC:TN:VA:WV", BillingState), "South",
6IF(CONTAINS("IL:IN:IA:MI:MN:MO:NE:ND:OH:SD:WI", BillingState), "North", "Other"))))))

Contract Aging

This formula calculates the number of days since a contract with an account was activated. If the contract Status isn’t “Activated,” this field is blank.

1IF(ISPICKVAL(Contract_Status__c, "Activated"), 
2NOW() - Contract_Activated_Date__c, null)

Examples of Advanced Formula Fields

Sample Account Management Formulas

Account Rating

Account Region

Contract Aging