+ Start a Discussion
Local EdgeLocal Edge 

Custom Validation Rule assistance

I am attempting to create a validation rule that specifies if a certain value is selected in the Opportunity Stage picklist field it forces the owner to enter the contract duration before they can save the record.
Any help would be greatly appreciated.
Below is what I put together based on other rules I have in place on but cannot get it to work:
AND(
(Probability >= 0.50),
ISNULL( Length_of_Contract__c ))
Message Edited by Local Edge on 04-08-2009 08:45 AM
Best Answer chosen by Admin (Salesforce Developers) 
NPMNPM

AND( (Probability >= 0.50), Len(Length_of_Contract__c )=0)

 

All Answers

NPMNPM
What data type is Length_of_Contract__c ? If it is Text ISNULL will not work.  Would need to use

Len(Length_of_Contract__c )=0

 

Local EdgeLocal Edge

It is a text field.

 

I changed it to:

 

AND(
(Probability >= 0.50),
Len(Length_of_Contract__c )=0

 

but now I get a syntax error.

 

Error: Syntax error. Missing ')'

NPMNPM

AND( (Probability >= 0.50), Len(Length_of_Contract__c )=0)

 

This was selected as the best answer