function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Kimberly DaleKimberly Dale 

I am trying to create a validation rule where and & or are used

In my Validation rule:  If the type is Reseller Standard or Reseller Premium and the Partner Account is blank  then send an error that partner is required.  This gets no errors but does not give an error message

AND
(
 TEXT(Type) = "Reseller Standard",
  OR(TEXT(Type) = "Reseller Premium))",
  AND(ISBLANK(PartnerAccount__r.Name))))
Best Answer chosen by Kimberly Dale
TinkerMeTinkerMe
Try This!
AND (
          OR (
                 ISPICKVAL (Type, "Reseller Standard"),
                 ISPICKVAL (Type, "Reseller Premium")
                 ),
 ISBLANK(PartnerAccount__r.Name)
)

Please mark this as Best Answer if it works.

All Answers

TinkerMeTinkerMe
Try This!
AND (
          OR (
                 ISPICKVAL (Type, "Reseller Standard"),
                 ISPICKVAL (Type, "Reseller Premium")
                 ),
 ISBLANK(PartnerAccount__r.Name)
)

Please mark this as Best Answer if it works.
This was selected as the best answer
Kimberly DaleKimberly Dale
Thank you that was perfect