1.比较【工单-开票申请日期】和【工单-发货日期】,如果【工单-开票申请日期】<=【工单-发货日期】,设置为【工单-开票申请日期】,否则设置为【工单-发货日期】
※两者都为空则不设置,其中一个日期为空则设置为非空的日期
IF(AND(DateOpplication__c = null, EtSendDate__c = null), null,
IF(AND(DateOpplication__c = null,EtSendDate__c!= null),EtSendDate__c ,
IF(AND(DateOpplication__c != null,EtSendDate__c== null),DateOpplication__c ,
IF(DateOpplication__c<= EtSendDate__c ,DateOpplication__c ,EtSendDate__c))))
ISBLANK :去看公式解释
IF(AND(ISBLANK (DateOpplication__c), ISBLANK(EtSendDate__c)), null,
IF(AND(ISBLANK(DateOpplication__c), NOT (ISBLANK (EtSendDate__c ))),EtSendDate__c ,
IF(AND(NOT (ISBLANK(DateOpplication__c )),ISBLANK(EtSendDate__c )),DateOpplication__c ,
IF(DateOpplication__c <= EtSendDate__c ,DateOpplication__c ,EtSendDate__c))))
2.链接字段:放Id,是拼接链接,name是页面上显示的字段
HYPERLINK("https://cs72.salesforce.com/"& Id,Name)