Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
GMASJGMASJ 

BillingState should be mandatory when Billingcountry = United States or US or USA

Hi, 

  I want to create a validation in account on BillingState this should be mandatory when BillingCountry = United States or US or USA. Please suggest me a logic. 

Thanks
Sudhir
Best Answer chosen by GMASJ
kamala swarnalathakamala swarnalatha
Try this,

AND((BillingCountry  = "United States" || BillingCountry  = "US" || BillingCountry  = "USA"), ISBLANK( BillingState ) )

Kamala
Sweet Potato Tec