Formulas Superbadge Unit - Build Lead Score and Rating Fields - challenge 1
Formulas Superbadge Unit - Build Lead Score and Rating Fields Build the Lead Score and Lead Rating fields according to the business requirements. Tip: Test the outcome of your solutions with test records and data. Lead Score Formula: return number IF( ISBLANK(TEXT(Status)), null, IF( ISPICKVAL(Status, 'Closed - Not Converted'), 0, IF( DoNotCall, -25, 0 ) + IF( ISBLANK(Email), 0, 15 ) + CASE( TEXT(LeadSource), 'Web',20, 'Phone Inquiry',35, 'Partner Referral',25, 'Purchased List',10, 0 ) ) ) Lead Rating formula : return text