Validation rule: Change_Required_Decision_Needs_Comments

Name

Change_Required_Decision_Needs_Comments

Label

Change_Required_Decision_Needs_Comments

Object

Assigned_Person__c

Active

No

Formula

AND
(
NOT(ISPICKVAL( Role__c , 'Trust Office Review')),
NOT(ISPICKVAL( Role__c , 'GAB Redemption Approval')),
NOT(ISPICKVAL( Role__c , 'GAB Endorsement')),
NOT(ISPICKVAL( Role__c , 'Authorising Delegate')),
ISPICKVAL( Outcome__c , 'Changes Required'),
LEN( Decisiion_Comments__c ) < 1,
NOT(ISPICKVAL( Type__c , 'Approval')),
NOT(ISPICKVAL( Type__c , 'Mandatory Validation')),
NOT(ISPICKVAL( Type__c , 'Review'))
)

Error message

If the decision is “Changes Required”, outcome description become mandatory

Error location

Outcome Description