+ Start a Discussion
Chad MoutesChad Moutes 

If BillingState = OH then Industry must be populated validation rule.

I am kind of new to writing validation rules and I'm trying to write one for if the field "BillingState" = "OH" then the field "Industry must be populated. Any help would be greatly appreciated.
Best Answer chosen by Chad Moutes
John PipkinJohn Pipkin
if thats the case, then use this: 
BillingState = 'OH'
&&
ISPICKVAL(Industry_must_be_populated__c,'')

 

All Answers

John PipkinJohn Pipkin
BillingState = 'OH'
&&
ISBLANK(Industry_must_be_populated__c)
There ya go!
Chad MoutesChad Moutes
I tried that and the "Industry" field is a picklist, so it gives me an error that picklists are only supported by certain functions....
John PipkinJohn Pipkin
if thats the case, then use this: 
BillingState = 'OH'
&&
ISPICKVAL(Industry_must_be_populated__c,'')

 
This was selected as the best answer
Balaji Chowdary GarapatiBalaji Chowdary Garapati

@Chad Moutes

  Use this:

text(Industry)=='OH'

or isPickVal(Industry,'OH')

Use either of text(pick_list) or ispickval(pick_list,value) functions when refering to picklist values in formulas.

Thanks,
Balaji