function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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)