You need to sign in to do that
Don't have an account?
Cameron Seitz
Validation Rule That States If = Y, Field Must Be Null
I have a field that has a picklist that offers the options "Y" or "N". I have a separate field that needs to be empty if the answer is Y and required if the answer is N to that previous field.
This is the validation I have to make it required if "N":
AND(
ISPICKVAL(Bank_Full_Deposit_Flag_1__c , "N")
)
The field that it is applied to is called "Bank_Deposit_Deduction_Amount_1__c"
I just can't seem to figure out the "Must be blank" part for "Y". Appologies if I'm missing something obvious here. I have been going through the guide and can't seem to find it.
This is the validation I have to make it required if "N":
AND(
ISPICKVAL(Bank_Full_Deposit_Flag_1__c , "N")
)
The field that it is applied to is called "Bank_Deposit_Deduction_Amount_1__c"
I just can't seem to figure out the "Must be blank" part for "Y". Appologies if I'm missing something obvious here. I have been going through the guide and can't seem to find it.
OR(
AND(
ISPICKVAL(Bank_Full_Deposit_Flag_1__c , "N"),
ISBLANK(Bank_Deposit_Deduction_Amount_1__c)
),
AND(
ISPICKVAL(Bank_Full_Deposit_Flag_1__c,"Y"),
NOT(ISBLANK(Bank_Deposit_Deduction_Amount_1__c)
))
)
All Answers
IF(AND(TEXT(Bank_Full_Deposit_Flag_1__c) == 'Y', ISBLANK(Other_Field__c)), true, false)
It would basically need to cover both of these stipulations in one rule:
If Bank Full deposit Flag 1 is "N" then Bank Deposit Deduction Amount is required.
If Bank Full Deposit Flag 1 says "Y" then the bank Deposit Deduction Amount Must Be Null
OR(
AND(
ISPICKVAL(Bank_Full_Deposit_Flag_1__c , "N"),
ISBLANK(Bank_Deposit_Deduction_Amount_1__c)
),
AND(
ISPICKVAL(Bank_Full_Deposit_Flag_1__c,"Y"),
NOT(ISBLANK(Bank_Deposit_Deduction_Amount_1__c)
))
)