You need to sign in to do that
Don't have an account?
Local 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 ))
(Probability >= 0.50),
ISNULL( Length_of_Contract__c ))
AND( (Probability >= 0.50), Len(Length_of_Contract__c )=0)
All Answers
Len(Length_of_Contract__c )=0
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 ')'
AND( (Probability >= 0.50), Len(Length_of_Contract__c )=0)