Skip to main content

I have the following VR:

AND(

ISPICKVAL( Account__c, "Nurture"),

( Account__c, "Nurture")

ISBLANK( PLC_Parent_ID__c )

)

 

What I need is one that when PLC_Parent_ID__c is blank then the the following pickvalues for Account__c can't be: 

Renewing/Expanding

Expansion Implementation

Inactive (Never Client)

Previously Active 

1 Antwort
  1. 12. Apr. 2023, 22:10

    Hi @Juan Quintero ,

     

    Try this

     

    AND(

    ISBLANK( PLC_Parent_ID__c ),

    OR(

    ISPICKVAL( Account__c, "Renewing/Expanding"),

    ISPICKVAL( Account__c, "Expansion Implementation"),

    ISPICKVAL( Account__c, "Inactive (Never Client)"),

    ISPICKVAL( Account__c, "Previously Active ")

    )

    )

0/9000