You need to sign in to do that
Don't have an account?
Prasunna
Validation rule for Opportunity Record Type
Hi All,
I created a validation rule On opportunity record type. When Opportunity Satge is closed and won picklist filed1 and picklist field2 must be populated. So that I created a validation rule like this:
AND(
OR(ISPICKVAL( StageName , "Closed Won") ),
OR($RecordType.Name = " Rec1 " ),
OR(ISPICKVAL( Picklistfield1, "" ),
ISPICKVAL( Picklistfield2 , "" ))
)
It is not showing any errors. But it is not working. Can anyone have idea about this?
Thanks in Advance,
Pavithra.
I created a validation rule On opportunity record type. When Opportunity Satge is closed and won picklist filed1 and picklist field2 must be populated. So that I created a validation rule like this:
AND(
OR(ISPICKVAL( StageName , "Closed Won") ),
OR($RecordType.Name = " Rec1 " ),
OR(ISPICKVAL( Picklistfield1, "" ),
ISPICKVAL( Picklistfield2 , "" ))
)
It is not showing any errors. But it is not working. Can anyone have idea about this?
Thanks in Advance,
Pavithra.
AND(ISPICKVAL(StageName, "Close Won"),
$RecordType.Name = "Rec1",
OR(ISBLANK(TEXT(Picklistfield1)),
ISBLANK(TEXT(Picklistfield2))
)
)
All Answers
AND(ISPICKVAL(StageName, "Close Won"),
$RecordType.Name = "Rec1",
OR(ISBLANK(TEXT(Picklistfield1)),
ISBLANK(TEXT(Picklistfield2))
)
)
Or Let us know if this will help you
Thanks
Amit Chaudhary
Thank you,
Pavithra.