Sample Scoring Calculations Formulas

Available in: All Editions

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

Lead Scoring

This formula scores leads, providing a higher score for phone calls than website requests.

1CASE(LeadSource, "Phone", 2, "Web", 1, 0)

Here's a formula that scores a lead based on his or her rating:

1CASE(1, IF(ISPICKVAL(Rating, "Hot"), 1, 0), 3, IF(ISPICKVAL(Rating, "Warm"), 1, 0), 2, IF(ISPICKVAL(Rating, "Cold"), 1, 0), 1))

This formula uses a simple scoring algorithm to rank customers a high score for positive survey results in Salesforce.

1Survey_Question_1__c * 5 + Survey_Question_2__c *2