Skip to main content
Topics#Data ManagementMehdi Ahmadi's Question
Mehdi Ahmadi asked in #Data Management
Apr 1, 2021, 2:04 PM

Validation rule error

Hey,

 

I want to create a validation rule in Invoice when Email alert communication is changed to "Standard process" filling out SEPA project manager email and SEPA project manager Validation rule errorname will become mandatory. SEPA project manager name is a picklist value. How can I do that?

 

 
2 answers
  1. Michael Brown (Salesforce) Forum Ambassador
    Apr 1, 2021, 2:10 PM
    Hi Mehdi, 

     

    You should be able to do something like this:

    AND(ISPICKVAL(Email_Alert_Communication__c,"Standard Process"),
    OR(
    ISPICKVAL(SEPA_Project_Manager__c,""),
    ISBLANK(SEPA_Project_Manager_Email__c)))

     

    This will fire if Email Alert Communication is Standard Process and either of those two fields are blank.

     

    Thanks,

     

    Mikey
Write an answer...
0/9000