You need to sign in to do that
Don't have an account?

Validation Rule on length
HI,
I am having a text field.I wnat a length validation on that.
AND(ISPICKVAL(Vertical__c,'HI'),NOT(LEN(Proposal_Application_Number__c)=10))
but it is not working.Field should only accept 10 digit numeric number for HI vertical.
I am having a text field.I wnat a length validation on that.
AND(ISPICKVAL(Vertical__c,'HI'),NOT(LEN(Proposal_Application_Number__c)=10))
but it is not working.Field should only accept 10 digit numeric number for HI vertical.
Let me know if it helps
Your validation rule should work and accept only 10 characters (not only digit numeric numbers) when Vertical__c value is 'HI'.
Are you sure that your Validation rule is active ?
Best regards