Skip to main content
Liz Parker (Digital Space) 님이 #Formulas에 질문했습니다

I've been trying to create a validation rule which will prevent an opportunity being saved when the field contract end date is blank and the type is selected to be "Renewals"

 

I've tried the below:

 

AND(

ISBLANK( Contract_End_Date__c ),

ISPICKVAL( Type , 'Renewals')

)

 

however, I'm still able to save the form.

 

What am I missing? Please help!

답변 1개
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    2023년 5월 12일 오후 3:20

    Hi Liz,

     

    Can you double check the Type value and make sure you use its API name, not its label?

0/9000