function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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