Skip to main content

2014년 12월 3일 오후 5:29

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개

Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
2014년 12월 3일 오후 5: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)
)
)

댓글 추가

답변을 작성하세요...

0/9000