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
petec@i2isyspetec@i2isys 

And/or in validation rule

Hi all,
I have a validation rule I need to run where 3 things need to be true for it to fire. A needs to = True, B=True and C OR D = True.
I can't figure out the syntax for this.  I thought maybe:
AND(A=True, B=True, OR(C=True,D=True)  But that didn't work.  Any ideas?
Best Answer chosen by petec@i2isys
Ajay K DubediAjay K Dubedi
Hi Petec,

Please Try this validation rule:-

AND(A=True, B=True,OR(C=True,D=True))


Please mark as best answer if it helps you.

Thank You
Ajay Dubedi

All Answers

Raj VakatiRaj Vakati
AND (A=True, B=True) 
OR
OR (C=True,D=True)
Maharajan CMaharajan C
Hi petec,

It should be like below any one way  :

===========

AND ( AND(A=True, B=True), OR(C=True,D=True) ) 

===========

( A=True && B=True  && (C=True || D=True) )

===========

AND ( A=True, B=True, OR(C=True,D=True) ) 

===========

Can you please Let me know if it helps or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
Raj
Ajay K DubediAjay K Dubedi
Hi Petec,

Please Try this validation rule:-

AND(A=True, B=True,OR(C=True,D=True))


Please mark as best answer if it helps you.

Thank You
Ajay Dubedi
This was selected as the best answer
petec@i2isyspetec@i2isys
This worked best, thanks!