You need to sign in to do that
Don't have an account?
Karla 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"))
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"))
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)