+ Start a Discussion
SurenderSurender 

Need help in writing validation rule..

Hi,

 

I want below kind of validation rule.

 

CONTAINS(lower(text(Type__c)), "certain type") && ISBLANK(text(Opportunity_Amount__c))

 

But Type__c is of multi-select pick list, so it is not accepting CONTAINS.

 

Can some one help me how to write same validation rule for multi-select picklist.

 

Your feedback is appreciated.

 

Regards

G. Surender

SurenderSurender

Hi,

 

I want below kind of validation rule.

 

CONTAINS(lower(text(Type__c)), "certain type") && ISBLANK(text(Opportunity_Amount__c))

 

But Type__c is of multi-select pick list, so it is not accepting CONTAINS.

 

Can some one help me how to write same validation rule for multi-select picklist.

 

Your feedback is appreciated.

 

Regards

G. Surender

Navatar_DbSupNavatar_DbSup

Hi,

 

For the multiselect pick list use INCLUDES(multiselect_picklist_field, text_literal) .it will return true or false if the value exist according to the condition .

You can try below formula

 

INCLUDES(Type__c, "certain type") &&  ISBLANK(text(Opportunity_Amount__c))

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

Ankit AroraAnkit Arora

@Surendra : From next time please ensure you don't post the same content multiple times.

 

@S Jain : Help us by reporting these kind of duplicate post rather to put same comment on multiple post.

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page

sri.gullapallisri.gullapalli

 

Use INCLUDE for validating a pick list, not CONTAINS.