+ Start a Discussion
Karla Pliego 3Karla Pliego 3 

adding field to formula for workflow trigger conditions

Hello, 

I have the following formula. I want to add the condition that the email only triggers after transaction start (a picklist value) equals = Yes

How do I add this to this formula? 

AND( 
NOT(ISBLANK(Lender_Company_Contact__c )), 
NOT(ISBLANK(Buyer_Selling_Agent__c)), 
NOT(ISBLANK(Listing_Agent__c )), 
ISBLANK (Transaction_Closed_Date__c), 
ISBLANK( TEXT(Buyer_Using_Grants__c )) 

OR( TEXT ( rethink3__Broker_Representation__c ) = "SELLER", 
TEXT( rethink3__Broker_Representation__c ) = "Double sided") 

OR( TEXT(Loan_Type__c) = "FHA", 
TEXT(Loan_Type__c) = "VA", 
TEXT(Loan_Type__c) = "Conventional"))
 
Raj VakatiRaj Vakati
AND( 
NOT(ISBLANK(Lender_Company_Contact__c )), 
NOT(ISBLANK(Buyer_Selling_Agent__c)), 
NOT(ISBLANK(Listing_Agent__c )), 
ISBLANK (Transaction_Closed_Date__c), 
ISBLANK( TEXT(Buyer_Using_Grants__c )) 

OR( TEXT ( rethink3__Broker_Representation__c ) = "SELLER", 
TEXT( rethink3__Broker_Representation__c ) = "Double sided") 

OR( TEXT(Loan_Type__c) = "FHA", 
TEXT(Loan_Type__c) = "VA", 
TEXT(Loan_Type__c) = "Conventional") ,

Text(Transaction_Start__c)=="Yes"

)