You need to sign in to do that
Don't have an account?
Surender
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
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
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.
@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
Use INCLUDE for validating a pick list, not CONTAINS.