How do I make a validation rule to not allow Closed Won if field is "0"?

I want to make it so that reps have to have a value other than zero in a field before being able to change the opportunity to closwed won. So far I have this:

AND (

ISPICKVAL( StageName , "Closed Won" ),

ISNUMBER( my_field__c , "0" )

)

the syntax is in error.

Can anyone help me out?

Thanks!

4 réponses

Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
3 déc. 2014, 17:35
What is the Data Type of the"my_field__c" ? Can you try:
AND(
ISPICKVAL(StageName, "Closed Won"),
OR(
my_field__c = 0,
ISBLANK(my_field__c)
)
)

Ajouter un commentaire

Rédiger une réponse...

0/9000

How do I make a validation rule to not allow Closed Won if field is "0"?

Sales And Marketing

Formation associée

Aide supplémentaire