Validation Rule on a custom object
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,
AND( TEXT(Loan_Status__c)="Underwriting", TEXT( Loan_Type__c) = "Refinance", ISBLANK(TEXT(Closing_Costs_Added_to_the_Loan__c )) )