Validation rule: Gift_Date_Amount_and_Ask_made

Name

Gift_Date_Amount_and_Ask_made

Label

Gift_Date_Amount_and_Ask_made

Object

Opportunity

Active

Yes

Formula

!OR($Profile.Name = 'AQ Sys Admin', $Profile.Name = 'System Administrator', $Profile.Name = 'USyd Standard User - Prospect Development', $Profile.Name = 'USYD System Administrator') &&
(contains (text( StageName ), "Gift Handover")) &&
(
NOT(CONTAINS(RecordType.Name , "Unsolicited")) ||
NOT(CONTAINS(RecordType.Name , "Gifts in Will"))
)

&&

(ISBLANK( AQB__GiftDate__c )||
ISBLANK ( AQB__GiftAmount__c) ||
NOT( Ask_made__c ))

Error message

Either Gift date OR Gift amount is missing, OR Ask made is not checked

Error location

Top of Page

Description

Validation used for advancement of Opportunity to stage closed - gift date and amount must exist and ask made needs to be checked