+ Start a Discussion
Terry_0101Terry_0101 

How to enforce using Val Rule using CONTAINS

If Opp Name contains the word "VIP", then how to enfore a user to enter the word "VIP" into another field?
ManojjenaManojjena
Hi Samantha,

CONTAINS is a function in formula function which contains two parameter .One is the field API name and other is the search string .

So please check with below formula it will help .
 
AND(ISBLANK(VIP__c),CONTAINS(Name,'VIP'))

Thanks 
Manoj