function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SpunkySpunky 

edit validation rule to make it applicable for changed records only

I'll be the first to admit that you experts out there will probably scoff as this is probably quite easy;

 

But- I created the following Validation rule for a specific set of opportunities and it works. But , all new opportunities are created with this stage "Prospect" and I want this validation rule to be applicable not to new opps but only to those opps where the stage has been changed back to prospect. I've tried prior value and is changed but it's not quite working.

 

Any ideas?

 

 

AND($RecordType.Name = "Master",
$UserRole.Name <> "Marketing",
AND(ISPICKVAL (StageName ,"Prospect")),CASE( Setback__c ,"",1,0 )<>0)

Best Answer chosen by Admin (Salesforce Developers) 
Amber NeillAmber Neill

Take a look at the ISNEW function: https://na6.salesforce.com/help/doc/en/customize_functions.htm#ISNEW

I think that'll help!

Good luck!
Amber

All Answers

Amber NeillAmber Neill

Take a look at the ISNEW function: https://na6.salesforce.com/help/doc/en/customize_functions.htm#ISNEW

I think that'll help!

Good luck!
Amber

This was selected as the best answer
SpunkySpunky
thanks