Trying to create a validation if a certain pick list value is selected, title needs to contain "Live"

Question

Here is the formula I am trying to use, but even when Go-Live is selected, the validation does not fire AND( ISPICKVAL( Onboarding_Method__c , "Go-Live") , (CONTAINS( Name , "Live")))

Deepak K Anand · Accepted Answer

Can you try this =

AND( 
    ISPICKVAL(Onboarding_Method__c, "Go-Live"), 
    NOT(CONTAINS(LOWER(Name), "live"))
)

If that doesn't work then you should try -

AND( 
    ISPICKVAL(Onboarding_Method__c, "Go_Live"), 
    NOT(CONTAINS(LOWER(Name), "live"))
)

Chad Coffey · Answer

Deepak, Thank you very much.  I needed to select the API value for the picklist.  Once I used that value the validation worked as expected.

Trying to create a validation if a certain pick list value is selected, title needs to contain "Live"

Data Management

Related Learning

More Help