5 answers
I appreciate the help, but it did not work out.In the Consumer__c picklist field in Loan__c custom object I have the following values belowNot reviewedConsumerNon-consumerInsufficient informationAmbiguousExample: If one Opportunity (Deal) is connect to 2 loans (loan A and Loan B) . If the the Consumer__c picklist = "Consumer" in Loan A and the Consumer__c picklist = "Ambiguous" or "Insufficient information" or "Not reviewed" or "Null" in Loan B, then the Consumer_Loan__c = TRUE and the Consumer_Loan_Hidden__c = FALSE. the "Consumer" value in the Consumer__c picklist is always superior to other values. However if a user changes the Consumer__c picklist = "Ambiguous" or "Insufficient information" or "Not reviewed" or "Null" in Loan A, then the Consumer_Loan__c = FALSE and Consumer_Loan_Hidden__c = TRUE. I hope my explanation helps. thank you for your time again.