We have a custom object called Policy__c
It has two lookup fields on it that both are users. Owner__c and Account_Manager__c
My goal is this:
1- If Account_Manager__c is populated than Email from the Account_Manager__c email address
2- If the Account_Manager__c is NOT populated than Email from the Owner__c email address
If I could create a Formula that returned a Lookup value then I could create a 3rd field (a formula field) that would be the email from field. But with this not being possible I am wondering if anyone else has come up with an easy solution for this problem.
Thank you as always for any help!!!
2 risposte