Ask Search:
Neha reddyNeha reddy 

Validation Rule: We have picklist field called contact type. The need is to be able edit the picklist field , if and only if the picklist value is not primary.

Best Answer chosen by Neha reddy
Deepak AnandDeepak Anand
Take this a shot = 
AND(
    ISCHANGED(Contract_Type__c),
    TEXT(PRIORVALUE(Contract_Type__c)) = "Primary"
)

All Answers

Deepak AnandDeepak Anand
Are there two picklist fields involved in the question ?
Neha reddyNeha reddy
No. It is the same picklist field.
Neha reddyNeha reddy
We are giving the access to edit contacts to the community users. If the contact type is primary, we donot want them to change the value.
Deepak AnandDeepak Anand
Take this a shot = 
AND(
    ISCHANGED(Contract_Type__c),
    TEXT(PRIORVALUE(Contract_Type__c)) = "Primary"
)
This was selected as the best answer
Narender SinghNarender Singh
Like this:
Like this:
AND(TEXT(PRIORVALUE(contact_type__c))='Primary',
ISCHANGED(contact_type__c)
)

 
Neha reddyNeha reddy
That works! Thanks a ton.