function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Kajal Singh 36Kajal Singh 36 

Hi Folks, Can anyone help me to out to write a validation rule for if the Lead Status is already selected then we cannot change the rating to warm. the rating is hot or very hot but not warm.. tell me how to do this. Thanks in Advance

Best Answer chosen by Kajal Singh 36
Kajal Singh 36Kajal Singh 36
this Validation rule is working
AND(
ISPICKVAL( Lead_Status__c,'Site Visit Schedule') &&
ISPICKVAL( Rating__c,'Warm')
)

All Answers

RituSharmaRituSharma
Create a validation rule using below formula:

And(Text(Status)!='' , ISPICKVAL(Rating,'Warm'))
AbhishekAbhishek (Salesforce Developers) 
https://salesforce.stackexchange.com/questions/244232/validation-rule-to-prevent-all-other-users-from-changing-lead-status-when-lead-i

You can check this too.
Kajal Singh 36Kajal Singh 36
OR(ISPICKVAL(Rating__c , 'Warm'),
ISPICKVAL(Lead_Status__c ,'Site Visit Schedule ') )

I wrote this but this validation restrict all the lead status to choose warm.. Can you tall me how to modify this to full fill my critera
 
Kajal Singh 36Kajal Singh 36
@Ritu I tried your validation rule but this rule is not working
RituSharmaRituSharma
Change as below:

And(ISPICKVAL(Rating__c , 'Warm'),
ISPICKVAL(Lead_Status__c ,'Site Visit Schedule ') )
Kajal Singh 36Kajal Singh 36
this Validation rule is working
AND(
ISPICKVAL( Lead_Status__c,'Site Visit Schedule') &&
ISPICKVAL( Rating__c,'Warm')
)
This was selected as the best answer