+ Start a Discussion
Nick EngstrandNick Engstrand 

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.
Best Answer chosen by Nick Engstrand
William TranWilliam 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
 

All Answers

William TranWilliam 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
William TranWilliam 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
 
This was selected as the best answer
Nickolas EngstrandNickolas Engstrand
Thanks so much the second one helped the best because report level was a picklist value!