I have a formula (text field) name Obligation_Type__c in object Subject_Obligations__c . In the same object I have two lookup fields name Judgment__c and Loan__c .
I am trying to create a formula in the Obligation_Type__c field when a value exist in the Judgment__c field, the value "Judgment" will display in the Obligation_Type__c field or when a value exist in the Loan__c field, the value "Loan" will disply in the Obligation_Type__c field.
FYI - I have a Validation Rule which will allow a user to select only a Loan or a Judgment, not both.
I appreciate your help.
2 answers
Try this IF(NOT(ISBLANK(Judgment__c)), "Judgement"
IF(NOT(ISBLANK(Loan__c)), "Loan",
NULL))
