Ask Search:
Aaron PersichAaron Persich 

Validation Rule on a custom object

Hello,

I am looking to build a validation rule on a custom object and I am not sure how to do this.
 If the Loan Status (Picklist) is set to Underwriting and the Loan Type (Picklist) is set to Refinance then make the Closing Costs Added to the Loan (Picklist) manditory
AND(

ISPICKVAL( Loan_Status__c ,'Underwriting'),
ISPICKVAL( Loan_Type__c ,'Refinance'),
ISBLANK(ISPICKVAL(Closing_Costs_Added_to_the_Loan__c ))
)


Any help is much appreciated,

Thanks,
Aaron

Best Answer chosen by Aaron Persich
Sunil Kumar SirangiSunil Kumar Sirangi
Hi Aaron,

Try below:
 
AND(
TEXT(Loan_Status__c)="Underwriting",
TEXT( Loan_Type__c) = "Refinance",
ISBLANK(TEXT(Closing_Costs_Added_to_the_Loan__c ))
)

Thanks.