Skip to main content
Topics#Data ManagementJames Coyne's Question
James Coyne (IMS Limited) asked in #Data Management
Jun 17, 2019, 2:43 PM

validation rule query on an NOT ISPICKVAL

Here is my rule as it stands at the moment 

 

AND( 

 

RecordType.Name ='Ordering', 

 

ISPICKVAL(Status__c,'Customer'), 

 

NOT(ISPICKVAL (Years__c,"0")))

 

The last piece of the rule is the problem for me  - I want it to say that 

 

Is not a picklist value of 0 or blank  - 

 

Any help advice on how to proceed please?

 

Thank you 

 

 
8 answers
  1. Amnon Kruvi (The Architech Club)
    Jun 17, 2019, 2:49 PM
    Hi James,

     

    I think you may be looking for something like this:

     

     

    AND( 
        RecordType.Name ='Ordering', 
        ISPICKVAL(Status__c,'Customer'), 
        OR (
            NOT(ISPICKVAL (Years__c,"0")),
            ISBLANK(TEXT(Years__c))
        )
    )

     

     
Write an answer...
0/9000