Skip to main content
Jo Deng a posé une question dans #Data Management
Please help me build a validation that says, if stage name is 'Performance Review initiaited', following fields are required:

 

1. Location : Picklist

 

2. Start Date: Date

 

3. Rating: Picklist

 

4. Sale types: Picklist

 

5. Commission: Number

 

6. Primary: Checkbox

 

Thank you
6 réponses
  1. 14 févr. 2017, 20:06

    Then this:

    AND(

    TEXT(StageName) = 'Performance Review initiated',

    ISBLANK(TEXT(Location__c )),

    ISBLANK(TEXT(Rating__c)),

    ISBLANK(TEXT(Sale_types__c)),

    ISBLANK(Start_Date__c),

      ISBLANK(End_Date__c),

    ISBLANK(Commission__c),

    Primary__c = FALSE

    )

     

    That's it.