+ Start a Discussion
SriniSrini 

Validation Rules:

Hi Team,

How to create a validation rule for below requirement:

Block opportunity with stage from C5-Closed Won onward, which means once Opportunitys stage is up to C5-Closed Won, its owner can't change back stage to  C4/C3/C2/C1.

Can any one please help us.

Thanks in Advance
Best Answer chosen by Srini
VineetKumarVineetKumar
Are all the stages after C5 closed stages?
If yes then you can write a validation rule to stop this change.
AND(
    ISCHANGED(StageName),
    PRIORVALUE(IsClosed),
    NOT(IsClosed)
)

All Answers

Dutta SouravDutta Sourav
Try This:
AND(
ISCHANGED(IsClosed),
PRIORVALUE(IsClosed),
NOT( IsClosed)
)

 
VineetKumarVineetKumar
Are all the stages after C5 closed stages?
If yes then you can write a validation rule to stop this change.
AND(
    ISCHANGED(StageName),
    PRIORVALUE(IsClosed),
    NOT(IsClosed)
)
This was selected as the best answer
SriniSrini
Hi Vineet,

Yes ,All values are avalable in the Stage field.

Thanks
VineetKumarVineetKumar
Did you try the above?
SriniSrini
Hi Vineet,

Yes,Working as expected..

Thanks