Skip to main content
Topics#CollaborationJames Coyne's Question
James Coyne (IMS Limited) asked in #Collaboration
Oct 30, 2017, 1:16 PM

Validation rule assistance please ..........

I havent quote goto the logic behind validation rules yet5 so tend to struglle with vcreating them hence this question 

 

my rule is 

 

IF(NOT(BLANKVALUE(Credit_No__c))),

 

(ISPICKVAL(Discarded_Stock__c,""))

 

What this should say in long hnad is 

 

If the Credit_No__c field contains anything then you need to select a pick list value (YES or No) for Discarded_Stock__c

 

Thanks in advance

 

 
3 answers
  1. Mayank Srivastava (eVerge Group)
    Oct 30, 2017, 1:19 PM

    James, give this a shot:

    AND(
       NOT(ISBLANK(Credit_No__c)),
       ISBLANK(TEXT(Discarded_Stock__c))
    )

     

    Copy paste and you should be golden.
Write an answer...
0/9000