Validation rule: Name_on_Instrument

Name

Name_on_Instrument

Label

Name_on_Instrument

Object

Opportunity

Active

Yes

Formula

AND(
(ISCHANGED(StageName) ||
ISCHANGED( AQC_NameontheInstrumentofGift__c ) ),
ISBLANK(AQC_NameontheInstrumentofGift__c ),
RecordType.DeveloperName = "OutrightGift",
OR(
ISPICKVAL(StageName, "Gift Handover"),
ISPICKVAL(StageName, "Closed Won")
)
)

Error message

Please fill in the Name on the Instrument of Gift as the field can't be null at Gift Handover or Closed Won stage.

Error location

Name on the Instrument of Gift