Skip to main content
Simeon Payne 님이 #Trailhead Challenges에 질문했습니다

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개
  1. 2021년 9월 26일 오후 3: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