Validation rule: Gift_Theme_Required

Name

Gift_Theme_Required

Label

Gift_Theme_Required

Object

Opportunity

Active

Yes

Formula

RecordType.DeveloperName='OutrightGift' &&
ISBLANK(Usyd_Gift_Theme__c)&&
OR(ISPICKVAL(StageName,"Solicitation"),
ISPICKVAL(StageName,"Gift Handover"),
ISPICKVAL(StageName,"Closed Won")) &&
(ISCHANGED(StageName) || ISCHANGED(Usyd_Gift_Theme__c))

Error message

At least select one Gift Theme

Error location

Top of Page

Description

Gift_Theme is required field when the opportunity reaches the Solicitation stage