number of the company-only 9 numbers allowed validation rule

Question

Amnon Kruvi · Answer

Hi Menachem,

What is the field type where you enter the company number, is it text or number?

If it's text, you can use the LEN function:

AND (

NOT(ISBLANK(Company_Number__c)),

LEN(Company_Number__c) != 9

)

If it's a number, you will need to convert it to text first:

AND (

NOT(ISBLANK(Company_Number__c)),

LEN(TEXT(Company_Number__c)) != 9

)

Collaboration