+ Start a Discussion
Lucas Arruda 8Lucas Arruda 8 

validation rule to specific to allow the changes with an specific value.

Hello, I'm trying to create a validation rule the checks if an status field into the Quote object is filled, if so the system should let the end user change the  status field of the other object to closed. I have created the validation rule bellow, however the validation didn't work. the validation it is requesting me to fill the status field during the record creation.
 
IF(
AND(
ISCHANGED(Fase__c),
ISPICKVAL(Fase__c, 'Closed'),
ISBLANK(
TEXT(Oportunidade__r.SyncedQuote.StatusECR__c)
)),false,true)

Thanks,
Lucas
Maharajan CMaharajan C
Hi Lucas,

Try the below one :

AND(
NOT(ISNEW()),
ISCHANGED(Fase__c),
ISPICKVAL(Fase__c, 'Closed'),
ISBLANK(
TEXT(Oportunidade__r.SyncedQuote.StatusECR__c)
))

Thanks,
Maharajan.C
Lucas Arruda 8Lucas Arruda 8
Hello Maharajan, I tried the code that you made, but unfortunately it didn't work! It has the same effect as the code that I made.