Skip to main content
Topics#Data ManagementShauna Anderson's Question
Shauna Anderson (currently unemployed) asked in #Data Management
Oct 14, 2020, 8:18 PM

Validation rule not working

Can anyone spot what's missing in my validation rule? I cant get it to work properly. If a user tries to change the stage to Closed Won, the Estimated Fee, Estimated Value of Assets and Product type field need to be completed first. 

 

AND( ISPICKVAL(StageName, "Closed Won" ), RecordType.DeveloperName = "CT_Personal_Trust", (ISBLANK(  Estimated_Fee__c  ),(ISBLANK( Estimated_Value_of_Assets__c ), ISPICKVAL( Product_Types__c , "")))

 

Thanks in advance!! 
3 answers
  1. Sachidanand Jha (Salesforce)
    Oct 14, 2020, 8:37 PM
    Hi Shauna,

     

    Can you try this one?

     

    AND( ISPICKVAL(StageName, "Closed Won" ), RecordType.DeveloperName = "CT_Personal_Trust", ISBLANK( Estimated_Fee__c ),ISBLANK( Estimated_Value_of_Assets__c ), ISPICKVAL( Product_Types__c , ""))

     

    Thanks.
Write an answer...
0/9000