Skip to main content
Topics#FormulasQuestion de Bella Cotrone
Bella Cotrone (COREFX) a posé une question dans #Formulas
19 janv. 2022, 22:07

Blank Field Validation rule based on picklist value

Hello, I'm trying to create a validation rule based on picklist values. I am fairly new to formulas and below is what I came up with. If any of the below picklist values are chosen then the user must fill out Opportunity Lost (Explain) field. Any help is greatly appreciated

 

AND( OR( ISPICKVAL( StageName, "Closed Lost"), ISPICKVAL( StageName, "Lost-Product"), ISPICKVAL( StageName, "Closed-CoreFX"), ISPICKVAL( StageName , "Lost-Pricing"))) ISBLANK( Opportunity_Lost_Explain__c )

2 réponses
  1. Forum Ambassador Michael Brown (Salesforce)
    19 janv. 2022, 22:15

    Hi Bella, you're really close! I would try this, which should fire if the Stage is one of those 4 values but the Opportunity Lost field is blank.

    AND(
    OR(
    ISPICKVAL(StageName, "Closed Lost"), 
    ISPICKVAL( StageName, "Lost-Product"),
    ISPICKVAL( StageName, "Closed-CoreFX"),
    ISPICKVAL( StageName , "Lost-Pricing")
    )
    ,
    ISBLANK( Opportunity_Lost_Explain__c )
    )

     

    Thanks,

    Mikey

Rédiger une réponse...
0/9000