+ Start a Discussion
KIBLKIBL 

Validation Rule - formula

I am trying to make a validation rule to have a the Customer PO (text field) required if a certain picklist is used.  This formula below is not working and I don't know why.
 
AND (ISPICKVAL( StageName , "Closed Won"),
ISNULL(Customer_PO__c))
 
Can you help?
 
 
 
Jeff TalbotJeff Talbot

For some reason, Salesforce doesn't consider an empty text field as null. This should work:

AND (ISPICKVAL( StageName , "Closed Won"),
Customer_PO__c="")

KIBLKIBL
Thank You!  It worked.