Skip to main content

Doing the text in formula exercises and trying to create the formula for the rating field.  Everything says it is OK but the field does not work.  It appears to default to cold and whatever field I change has no effect.  Formula is below and was pasted direct from the exercise, what am I missing?

 

IF( AnnualRevenue > 1000000 && CONTAINS(CASE(Country, "United States", "US", "America", "USA", "NA"), "US"), IF( ISPICKVAL(LeadSource, "Partner Referral"), "Hot", IF( ISPICKVAL(LeadSource, "Purchased List") || ISPICKVAL(LeadSource, "Web"), "Warm", "Cold" ) ), "Cold" )

 

Many thanks

3 respostas
  1. 26 de set. de 2021, 15:59

    Hello,

     

    Please use the below:

    IF(   AnnualRevenue > 1000000 &&   CONTAINS(CASE(Country, "United States", "US", "America", "US",     "USA", "US", "US", "US", "NA"), "US"),   IF(     ISPICKVAL(LeadSource, "Partner Referral"), "Hot",     IF(       ISPICKVAL(LeadSource, "PurchasedList") ||       ISPICKVAL(LeadSource, "Web"),       "Warm", "Cold"     )   ), "Cold" )

     

    Thanks