Receiving Error: Syntax error: Extra AND for my Validation Rule

OR( ISCHANGED(Contact), ISCHANGED(Report_Broker) ) AND ( ISBLANK(Report_Level_c))

I'm Receiving this Extra AND error, how do i get my syntax to be correct?

I'm in need of help creating a Validation rule that does the following task: Field Report level must be completed if Contact or Report Broker fields are updated.

December 3, 2015
·
Like
0
·
Follow
2

Best Answer chosen by Nick Engstrand

William Tran
Usually, __c is needed for custom fields and use Text() if one of the value is a picklist like:

AND ( ISBLANK(Text(Report_Level__c)),
OR( ISCHANGED(Contact), ISCHANGED(Report_Broker__c) ))

Thx

December 3, 2015
·
Like
1
·
Dislike
0

William Tran
Try this:

AND ( ISBLANK(Report_Level_c),
OR( ISCHANGED(Contact), ISCHANGED(Report_Broker) ))

As a common practice, if your question is answered, please choose 1 best answer.
But you can give every answer a thumb up if that answer is helpful to you.

Thanks