Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Natasha AliNatasha Ali 

Simple formula for validation rule

Hi,
I have a simple formula I need help with for a validation rule. The criteria is IF Course__r.Name CONTAINS 'ICT' or 'Maths' or 'English' AND RecordTypeId not equal to ‘0120O000000tbh0QAA’ THEN THE VALIDATION RULE SHOULD FIRE

I've tried a couple ways but to no avail.

Any help is much appreciated :)
Many Thanks,
Natasha 
Best Answer chosen by Natasha Ali
Lokesh KumarLokesh Kumar
AND(
OR(
Contains(Course__r.Name,'ICT'),
Contains(Course__r.Name,'Maths'),
Contains(Course__r.Name,'English')
),
RecordTypeId <>  '0120O000000tbh0QAA'
)



Try this.