• Rahmses Baks
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
Hi Friends,

iam trying to complete the 'Process Automation Specialist Superbadge- Challenge2:  getting the following error:

Challenge Not yet complete... here's what's wrong: 
A validation rule did not prevent a new Account from being saved when Billing Country is blank and Billing State has three characters.

here are my Validation Rule code details
---------------
OR(
    AND(
         LEN(BillingState)>2,
         CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" &
                  "IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" &
                  "NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" &
                  "WA:WV:WI:WY:PR",BillingState)
      ),
      NOT(OR
       (  BillingCountry="USA",
         BillingCountry="US",
         BillingCountry="United States",
         ISBLANK(BillingCountry)
      ))
    )
-------------------------
ShippingAddressValidation

OR(
   AND (
         LEN(ShippingState)>2,
         NOT (
         CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" &
                  "IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" &
                  "NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" &
                  "WA:WV:WI:WY:PR", ShippingState))),
    NOT(OR(
        ShippingCountry="US",
        ShippingCountry="USA",
        ShippingCountry="United States",
        ISBLANK(ShippingCountry)
        )
      )
 )
-------------------