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

Comments

Post a Comment

Popular posts from this blog

Build a Battle Station App : Create the Battle Station App

Image
  Build a Battle Station App : Create the Battle Station App - Create the Battle Station Constructions app. - Create the Battle Station object. - Add fields to the Battle Station custom object. - Create a Resource custom object and fields. - Create a Supply custom object and fields. - Modify the Battle Station page layout. - Add a Roll-up Summary for Resources. - Remind your users of data requirements with a validation rule. - Automate a business process with Flow Builder. - Create a Report for Supply costs. - Create a Dashboard to display reports.
Read more

Build a Battle Station App : Create Reports and Dashboards

Image
  Build a Battle Station App : Create Reports and Dashboards A report in Salesforce is a list of records that meet the criteria you define. It’s displayed in Salesforce in rows and columns, and can be filtered, grouped, or displayed in a graphical chart. You'll create a report to monitor your supply costs for each Battle Station being constructed.
Read more