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
Leyadk DevelLeyadk Devel 

Validation rule - Please assist

Hi all,

 

I'm trying to create a validation rule where if the site classification picklist value = mobilised, then unless the pipeline divestment stage filed is left blank, the validation error should fire.

 

AND(ISPICKVAL(Site_Classification__c, Mobilised)), NOT(ISNULL(Pipeline_Divestment_Stage__c))

 

Please can you tell me what I am doing wrong here?

 

Many thanks,

Dave

Starz26Starz26

Maybe as simple as forgetting the quotes??

 

AND(ISPICKVAL(Site_Classification__c, "Mobilised")), NOT(ISNULL(Pipeline_Divestment_Stage__c))
BewitchedBewitched

Hi,

 

Just try using this and tell me whether it works ?

 

AND(
NOT(ISBLANK(Pipeline_Divestment_Stage__c)),
NOT(ISPICKVAL(Site_Classification__c, "Mobilised")))

 

 

Thanks,

Tulika