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

Validation Rule - Closing Cases
I am trying to write a VR that prevents a case from being closed if it's not owned by a user. It also include several other statements that should apply. It should fire with any RT with any of the closed statuses listed but it's not. Any assistance is greatly appreciated! Thank you!
AND
(
NOT($Setup.Global_System_Flags__c.Disable_Validation_Rules__c),
NOT CONTAINS(Source:EmailMessage.FromAddress, "@greenhouse.io"),
LEFT(OwnerId,3) <> '005',
AND(
OR(
(RecordType.Name = 'A'),
(RecordType.Name = 'B'),
(RecordType.Name = 'C'),
(RecordType.Name = 'D'),
(RecordType.Name = 'E'),
(RecordType.Name = 'E')),
OR
(
ISPICKVAL(Status, 'Closed'),
ISPICKVAL(Status, 'Duplicate'),
ISPICKVAL(Status, 'Canceled'),
ISPICKVAL(Status, 'Resolved'),
ISPICKVAL(Status, 'Reassigned')
)
)
)
AND
(
NOT($Setup.Global_System_Flags__c.Disable_Validation_Rules__c),
NOT CONTAINS(Source:EmailMessage.FromAddress, "@greenhouse.io"),
LEFT(OwnerId,3) <> '005',
AND(
OR(
(RecordType.Name = 'A'),
(RecordType.Name = 'B'),
(RecordType.Name = 'C'),
(RecordType.Name = 'D'),
(RecordType.Name = 'E'),
(RecordType.Name = 'E')),
OR
(
ISPICKVAL(Status, 'Closed'),
ISPICKVAL(Status, 'Duplicate'),
ISPICKVAL(Status, 'Canceled'),
ISPICKVAL(Status, 'Resolved'),
ISPICKVAL(Status, 'Reassigned')
)
)
)
Validation looks good, can you try to break validation rule into small snippet and test. First test AND scenario and then remaining ones
Thanks,
Could you please try this
Please let us know if it works.
Thanks,
Kamala. K
Sweet Potato tec