Skip to main content
Validates that when the Billing Country is equal to: United States, Canada, Austraila, Brazil, China, India, Ireland, Italy, Mexico, then the Account Billing State/Province is a required manatadory field. Otherwise state and province field is not manatadory.

 

 
3 respuestas
  1. 7 mar 2018, 17:09

    Like this = 

    AND(

    CASE(

    BillingCountry,

    "United States", 1,

    "Canada", 1,

    "Austraila", 1,

    "Brazil", 1,

    "China", 1,

    "India", 1,

    "Ireland", 1,

    "Italy", 1,

    "Mexico", 1,

    0

    ) = 1,

    ISBLANK(BillingState)

    )

0/9000