function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Reshmi Sangani 5Reshmi Sangani 5 

Validation rule:

I want to create a validation rule on a Custom object which is related to Opportunity
If the opportunity stage is set to "1","2" or "3"
The date field on the Custom object cannot be edited 
 
Andrew GAndrew G
Hi Reshmi

Have the validation with OR testing the Stage names across the related object (using object__r notation)
and AND for the ISCHANGED
Example: 
AND (
 OR (
    ISPICKVAL(Opportunity__r.StageName, "Stage 1"),
    ISPICKVAL(Opportunity__r.StageName, "Stage 2"),
    ISPICKVAL(Opportunity__r.StageName, "Stage 3")
  ),   
  ISCHANGED( DateField__c)
)

Regards
Andrew