+ Start a Discussion
Karla Pliego 3Karla Pliego 3 

Formula for date field

Hello, I have the folloiwng formua, but want to add that it only triggers if a date field named Transaction closed out date is blank (Transaction_Closed_Date__c). How do I incorporate that into this formula? 

AND(
NOT(ISBLANK(Lender_Company_Contact__c )),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISNULL(  Contract_Acceptance_Date__c  )),
  
OR(
ISNULL(  Appraisal_Ordered_Date__c  ),
ISNULL( Appraisal_Date_Time__c )),

OR(

TEXT ( rethink3__Broker_Representation__c ) = "buyer",

TEXT( rethink3__Broker_Representation__c ) = "Double sided"))
Sourav PSourav P
Try this,

IF(ISBLANK(Transaction_Closed_Date__c),
AND(
NOT(ISBLANK(Lender_Company_Contact__c )),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISNULL(  Contract_Acceptance_Date__c  )),
  
OR(
ISNULL(  Appraisal_Ordered_Date__c  ),
ISNULL( Appraisal_Date_Time__c )),

OR(

TEXT ( rethink3__Broker_Representation__c ) = "buyer",

TEXT( rethink3__Broker_Representation__c ) = "Double sided")), Null)