You need to sign in to do that
Don't have an account?
sumit d
validation rule on opportunity
Hi All,
i need Validation Rule For all open opportunities that do not have a contact role entered that it must be entered before updating the opportunity .
how to do this?
Any suggestions?
i need Validation Rule For all open opportunities that do not have a contact role entered that it must be entered before updating the opportunity .
how to do this?
Any suggestions?
Can you please explain requirement briefly?
Thanks,
K.Kamala,
Sweet Potato Tec.
if thier Contact role is blank than there should be error before updating the opportunity that ContactRole must be entered.
Try this one,
AND( ISPICKVAL( StageName , "Closed Won")), ISPICKVAL( StageName , "Closed Lost")),(ISBLANK(ContactRole)))
Hope this helps!
Thanks,
K.Kamala,
Sweet Potato Tec.
try this
AND( ISPICKVAL( StageName , "Closed Won")), ISPICKVAL( StageName , "Closed Lost")),(ISBLANK(ContactRole_c)))
Is this with Relationship with contact role.
May I know the object name and the field because field is ContactRole or object is ContactRole.
You can create custom formula fields(ContactRoleOpportunitity_c) on the junction object that contain the values from the related record then create the validation rule like this
AND( ISPICKVAL( StageName , "Closed Won")), ISPICKVAL( StageName , "Closed Lost")),(ISBLANK(OpportunityContactRole.ContactRoleOpportunitity_c)))
Hope this helps!
Thanks,
K.Kamala,
Sweet Potato Tec.
Will you please remove the bracket before the isblank and at the end of it.
Thanks
Please Try this validation rule:-
Please mark as best answer if it helps you.
Thank You
Ajay Dubedi