Ask Search:
Aaron PersichAaron Persich 

Formula Field to Combine Two Formula Fields

Hello,
 
I am working on the campaign members object and I have two formula fields which query on the lead and contact object.  Both formulas are date fields.  I would like to create an additional formula field to combine the two if one is not blank.
 
For example
 
IF(NOT(ISBLANK, Lead_MQL_Date__c then populate the Lead_MQL_Date__c
 
Or IF(NOT(ISBLANK, Contact_MQL_Date__c then populate the Contact_MQL_Date__c
 
Any help is much appreciated.
 
Thanks,
 
Aaron
 
Best Answer chosen by Aaron Persich
Aaron PersichAaron Persich
This worked

IF(ISBLANK(LeadId), 
Contact.Marketing_Qualified_Date__c , 
Lead.Marketing_Qualified_Date__c 
)

All Answers

Amit SinghAmit Singh
like This
BLANKVALUE(Contact_MQL_Date__c, Lead_MQL_Date__c)

 
Aaron PersichAaron Persich
This worked

IF(ISBLANK(LeadId), 
Contact.Marketing_Qualified_Date__c , 
Lead.Marketing_Qualified_Date__c 
)
This was selected as the best answer
Amit SinghAmit Singh
Cheers:) Please close the thread by selecting the best answer :)