+ Start a Discussion
azhar khasimazhar khasim 

Validation Rule :When field: 'Candidate Final Status" is not blank, then field: "Interviewer" and field: "Comments" is mandatory

Hello guys,

Need help in these for writing a validation rule

When field: 'Candidate Final Status" is not blank, then field: "Interviewer" and field: "Comments" is mandatory Validation Rule

Please help me from thiss...

Regards,
Azar Khasim

 
Best Answer chosen by azhar khasim
Devi ChandrikaDevi Chandrika (Salesforce Developers) 
try this formula
AND( NOT( ISPICKVAL( Candidate_Final_Status__c ,'' )) ,
(OR(ISBLANK(F2F_Interviewer__c ),ISBLANK( F2F_Comments__c ))))

Hope this helps you
If this helps kindly mark it as solved so that it may help others in future.

Thanks and Regards

All Answers

Priya@999Priya@999
AND(NOTISBLANK(Candidate_Final_Status_c),OR(ISBLANK(Interviewer),ISBLANK(Comments)))
Devi ChandrikaDevi Chandrika (Salesforce Developers) 
Hi Azhar,
Try this one.Please Modify according to your field types
AND( NOT( ISBLANK( Department )) ,
(OR(ISBLANK(Description ),ISBLANK( Title ))))

Hope this helps you
If this helps kindly mark it as solved so that it may help others in future.

Thanks and Regards
azhar khasimazhar khasim
Hello Priya, Devi,

Thanks for your response but i forget to say actually 
Candidate Final Status field is a Picklist.

This is how i have modified.
Please help me from thisss..

AND (NOT( ISBLANK( ISPICKVAL( 'Candidate_Final_Status__c',Null ) ) ) ,
         OR( ISBLANK(F2F_Interviewer__c), ISBLANK(F2F_Comments__c) ) )

Give me a solution from thiss..

Regards,
Azar Khasim.
Devi ChandrikaDevi Chandrika (Salesforce Developers) 
try this formula
AND( NOT( ISPICKVAL( Candidate_Final_Status__c ,'' )) ,
(OR(ISBLANK(F2F_Interviewer__c ),ISBLANK( F2F_Comments__c ))))

Hope this helps you
If this helps kindly mark it as solved so that it may help others in future.

Thanks and Regards
This was selected as the best answer
azhar khasimazhar khasim
Dear Devi,

Thank you so much its working for mine..

Regards,
Azar Khasim.