You need to sign in to do that
Don't have an account?
Compare two date fields only if one of the date fields is NOT blank.
Trying to write a formula that compares two date fields only if one of the date fields is NOT blank.
Here is what I have so far.
IF(
Last_Sales_Call__c > Last_Telephone_Sales_Call__c,"Yes","No")
Basically I need the formula to compare Last Sales Call vs Last Telephone Sales Call only if the Last Telephone Sales Call is NOT blank.
Here is what I have so far.
IF(
Last_Sales_Call__c > Last_Telephone_Sales_Call__c,"Yes","No")
Basically I need the formula to compare Last Sales Call vs Last Telephone Sales Call only if the Last Telephone Sales Call is NOT blank.
The formula shows "No" if the Last_Telephone_Sales_Call__c is blank.
All Answers
The formula shows "No" if the Last_Telephone_Sales_Call__c is blank.