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

Validation rule on status field based on checkbox
Hello Guys,
I am working on a validation rule that will prevent the users from changing the status value.
I have two objects Test__c and Risk__c, both are having a look up relationship here.
I also have a Checkbox__c field on Test__c object and Status__c picklist field in Risk__c object.
My requirement is that if Checkbox__c on Test__c object is checked then only I should able to change the Status__c on Risk__c object.
Can anyone help me out to complete this if possible.
I am working on a validation rule that will prevent the users from changing the status value.
I have two objects Test__c and Risk__c, both are having a look up relationship here.
I also have a Checkbox__c field on Test__c object and Status__c picklist field in Risk__c object.
My requirement is that if Checkbox__c on Test__c object is checked then only I should able to change the Status__c on Risk__c object.
Can anyone help me out to complete this if possible.
Please try this below validation formula on Risk Object
AND(NOT(Test__r.Checkbox__c),ISCHANGE(Status__c))
Let me know if it revert some error.
Please like and Mark it as best answer if you find it Positive.
Thanks,
Jolly Birdi