I have an validation rule on the Opportunity Object which disallows reselecting previous stages based on stage values from 1-8.
These are my stages:
01 - Identifying an Opportunity Open 02 - Determining Problem, Impact, Ideal 03 - Validating Benefits & Value 04 - Confirming Value with Power 05 - Negotiating $$ & Mutual Plan 06 - Finalizing Closure 07 - Pending 08 - Closed Won 08 - Closed Lost 08 - Closed Lost (alternative Quote)
And this is my validation rule so far:
AND( (PRIORVALUE(stage_value__c) > stage_value__c), (PRIORVALUE(stage_value__c) = 8) )
As you can see I have several values in stage 8. Now I want the user to be allowed to change values from stage 8 to another stage 8 value.
How can I archieve this?