Skip to main content
Topics#CollaborationPatrick Claret's Question
Patrick Claret (Patgroup) asked in #Collaboration
May 6, 2021, 2:15 PM

Billing address formula

I wish to make all the fields related to address mandatory, so far I have this formula but it only fired when the billing street is Blank and not for the rest of the fields.

 

AND(

 

ISBLANK( BillingStreet),

 

ISBLANK( BillingState),

 

ISBLANK( BillingCity )

 

)

 

Thanks everyone :)
2 answers
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    May 6, 2021, 2:21 PM
    Hi Patrick,

     

    Use OR instead of AND

    OR(
    ISBLANK( BillingStreet),
    ISBLANK( BillingState),
    ISBLANK( BillingCity )
    )

     

     
Write an answer...
0/9000