Skip to main content

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 réponses
  1. 6 juil. 2023, 22:28
    IF(ISBLANK(Account_Manager__c), Owner__r.Email, Account_Manager__r.Email)