function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Nick EngstrandNick Engstrand 

Validation rule: Field Report level must be completed if Contact or Report Broker fields are updated.

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
JustAGirlyGeekJustAGirlyGeek
That should be an easy fix. Try this:

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

All Answers

JustAGirlyGeekJustAGirlyGeek
Haven't tested for errors but this should point you in the right direction:

OR(
ISCHANGED(Contact),
ISCHANGED(Report_Broker__c)
AND(
ISBLANK(Field_Report_Level__c)
)
)
Nick EngstrandNick Engstrand
I believe thats along the right lines as well but i keep receiving the "Error: Syntax error. Missing ')' " i recall this being kinda of like a minor issue. any suggestions?
JustAGirlyGeekJustAGirlyGeek
Try this instead:

AND(
ISBLANK(Field_Report_Level__c),
OR(ISCHANGED(Contact),
ISCHANGED(Report_Broker__c))
)
Nick EngstrandNick Engstrand
User-added image got all the syntax errors out except now its saying tits a picklist field, and based off the information "tell me more" it explains i should be able to do this... but its not working... 
JustAGirlyGeekJustAGirlyGeek
That should be an easy fix. Try this:

AND(
ISBLANK(TEXT(Report_Level__c)),
OR(ISCHANGED(Contact),
ISCHANGED(Report_Broker__c))
)
This was selected as the best answer