Validation rule: SpendPlan_Latest_Activation_Date_Changed

Name

SpendPlan_Latest_Activation_Date_Changed

Label

SpendPlan_Latest_Activation_Date_Changed

Object

Spending_Plan__c

Active

No

Formula

AND(
ISCHANGED(Latest_Activation_Date__c),
ISPICKVAL(Status__c, 'Active'),
NOT(
OR(
OwnerId = $User.Id,
$Profile.Name ='System Administrator',
$UserRole.Name = 'Trusts Office (OGC)'
)
)
)

Error message

Last Authorisation Date can only be changed in Active status by Owner or Trusts Office

Error location

Last Authorisation Date