+ Start a Discussion
Pedda Prakash sovereignPedda Prakash sovereign 

Required validation rule for the picklist value has been set once

I was trying to write a validation rule , but it is not reflecting which i expected. please help there is a picklist field having 6 values namely active, processing, accepted,rejected, Admitted, discharge. once these picklist value has been saved as admitted we need to lock down this value for all users except system admin user.
I have been struck for the below validation rule.
AND(PRIORVALUE(Status) = "Admitted",NOT($User.Id = "005P00000015Vvm"),ISCHANGED(Status))
Thanks in advance.
Varun SinghVarun Singh
Hi

try this i hope it  will heplful
 
AND($Profile.Name <>"System Administrator", 
 PRIORVALUE(Status)<> 'Open - Not Contacted' )

If information is helpful make my answer as  best.. 
Gokula KrishnanGokula Krishnan
Hi,
Try this,

AND(
$User.Id  <>  '005P00000015Vvm',
ISCHANGED(Status),
PRIORVALUE( StageName ) =  'Admitted'
)

If it helps you, please mark is as best answer, so it will be helpful for other developers.