Opportunity Validation Rule: Now requires an entry in that field

Question

I used the following VRs in custom opportunity fields and made them active. Now they require informatioin to be entered, but I don't want them to be mandatory. I only want them to be restricted to numbers. Both fields are text fields that we now want only numbers to be entered. I don't want to change the field type and delete all data currently there. I looked at the Edit Layout as well as Setup and these are not required fields. How can I use the VR, but not make them mandatory?

NOT(ISNUMBER( Interest_Rate_Spread__c ))

NOT(ISNUMBER( Term_months__c ))

Thank you!

Mayank Srivastava · Accepted Answer

Erika, just modify them to be this:

AND(
   NOT(ISNUMBER( Interest_Rate_Spread__c )),
   NOT(ISBLANK ( Interest_Rate_Spread__c ))
)

AND(
   NOT(ISNUMBER( Term_months__c )),
   NOT(ISBLANK ( Term_months__c ))
)

Opportunity Validation Rule: Now requires an entry in that field

Data Management

関連学習

さらにヘルプを表示