Validation rule for preventing user to going back in stage on Opportunity.

As salesforce admin we have to write a lot of advance validation rules to achieve our requirement. Now validation rules as we all know are condition we can apply in salesforce that prevents the user to make change in the record. That is the user will not be able to save, update the record. In this article we will be solving simple validation problem faced by new salesforce admin. Here we will try make a validation which prevents the user to go back in opportunity stage.

Create Validation rule on Opportunity

				
					CASE(StageName,
"Prospecting",1,
"Qualification",2,
"Needs Analysis",3,
"Value Proposition",4,
"Id. Decision Makers",5,
"Perception Analysis",6,
"Proposal/Price Quote",7,
"Negotiation/Review",8,
"Closed Won",9,
"Closed Lost",10,0)<
CASE(PRIORVALUE(StageName),
"Prospecting",1,
"Qualification",2,
"Needs Analysis",3,
"Value Proposition",4,
"Id. Decision Makers",5,
"Perception Analysis",6,
"Proposal/Price Quote",7,
"Negotiation/Review",8,0)
				
			

Leave a Comment