Validation rule: Consult_PartyRole_Allowed_Values

Name

Consult_PartyRole_Allowed_Values

Label

Consult_PartyRole_Allowed_Values

Object

Assigned_Person__c

Active

No

Formula

AND(
NOT(System_Is_Automated__c),
AND(
NOT(ISPICKVAL(Role__c, 'Academic Lead')),
NOT(ISPICKVAL(Role__c, 'Head of Faculty')),
NOT(ISPICKVAL(Role__c, 'Head of Portfolio')),
NOT(ISPICKVAL(Role__c, 'Head of Recipient Area')),
NOT(ISPICKVAL(Role__c, 'Head of School')),
NOT(ISPICKVAL(Role__c, 'Other')),
NOT(ISPICKVAL(Role__c, 'Philanthropy Finance')),
NOT(ISPICKVAL(Role__c, 'Professional Lead')),
NOT(ISPICKVAL(Role__c, 'Finance Partner')),
NOT(ISPICKVAL(Role__c, 'Gift Administration Board')),
NOT(ISPICKVAL(Role__c, '')),
AND(
NOT(ISPICKVAL(Type__c, 'Review')),
NOT(ISPICKVAL(Role__c, 'Trusts Office'))
)
),
OR(
NOT(Spending_Plan_ID__r.System_Switch_Off_Business_Rules__c),
AND(
Spending_Plan_ID__r.System_Switch_Off_Business_Rules__c,
NOT(CONTAINS($Profile.Name, 'System Administrator'))
)
)
)

Error message

Selected Consultant/Reviewer is for automation only and may not be selected by a user.

Error location

Consultant/Reviewer Role

Description

User may only select specific Consultant/Reviewer