0

This is the Validation Rule I have created so far, what I need is to include - VAT field on the Account can't be blank except when the Account Country field says USA

AND(
    NOT(ISBLANK( Account.Legal_Name__c)),
    NOT(ISBLANK(Account.Shareholder__c)),
    NOT(ISBLANK(Account.Executive__c)),
    NOT(ISBLANK(Account.BillingAddress)),

    ISPICKVAL(Type,"Partner"),

    OR(
        ISPICKVAL(StageName,"P4"),
        ISPICKVAL(StageName,"P5"),
        ISPICKVAL(StageName,"P6"),
        ISPICKVAL(StageName,"P7")
   )
)
1
  • (ISBLANK(Account.Vat__c) && NOT(ISBLANK(Account.BillingCountryCode)) && Account.BillingCountryCode == 'USA' The validation Rule should look like this – H R Dec 9 '20 at 17:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.