Skip to main content The Trailblazer Community will be unavailable from 2/1/2025 to 2/2/2025. Please plan your activities accordingly.
I have a two fields in Tax master object Excise_Duty__c and Sales_Tax__c  how to write a validation for Only one of the two to be entered.

      i am wrote a formula like this:

OR(

NOT( ISBLANK( Excise_Duty__c ) ),

ISBLANK( Sales_Tax__c )  

)

This is working for only one field for checking condition,how can i check for both fields!

Please provoide me profer solution for this!! Thanks in advance 
2 answers
  1. Apr 16, 2015, 5:20 AM
    Hi Naveen,

    Use of  AND operation will do it

    AND( ISBLANK( Excise_Duty__c ),

    ISBLANK( Sales_Tax__c )

    )

    Please mark this as solution if this solves your problem, So that if anyone has this issue this post can help
Loading
0/9000