@* Salesforce Administrators * Hey everyone, I'm wondering about the use of the "NOT" function in this validation rule. For instance, if I enter an account number like "3423423AF," the "ISBLANK" function will give us "True," but then the "NOT" function will flip it to "False." Similarly, the "ISNUMBER" function will give "False," and "NOT" will change it to "True." Consequently, the "AND" function returns a value of "False," indicating that it's a valid value.
Could someone please help me understand what I might be missing here?
#Salesforce #Validation #CRM Configuration
Forum Ambassador
Michael Brown (Salesforce)So, if you enter 3423423AF, ISBLANK will render false, because a value is populated, and then the NOT of that will make that condition true.
So, the following would be true:
NOT(ISBLANK(3423423AF)) = NOT(FALSE)= True
ISNUMBER will render false for 3423423AF, since it contains text, so
NOT(ISNUMBER(3423423AF)) = NOT(FALSE)= True
The AND condition then requires both of these conditions to be true, which means that the validation rule will fire if:
AccountNumber is populated with a value (via the ISBLANK function)
and that Account Number is not a number (via is ISNUMBER function)
