You need to sign in to do that
Don't have an account?
Karla Pliego 3
Formula for workflow rurle
I have the following formula for a workflow rule that, one of the formula items is that from a picklist either 2 of several items are part of the conditions. This picklist field is Broker Representation, I want the WF to trigger if broker reprensentation equals Seller OR Double Side. How can I change the below formula to reflect this? I tried playing around but it seems I'm always missing a ) or ,
AND(
TEXT(Loan_Type__c)= "VA",
NOT(ISBLANK(Lender_Company_Contact__c )),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
NOT(ISBLANK( Appraisal_Ordered_Date__c )),
ISBLANK( Appraisal_Date_Time__c ),
Text ( rethink3__Broker_Representation__c ) = ("SELLER" "Double sided")
)
AND(
TEXT(Loan_Type__c)= "VA",
NOT(ISBLANK(Lender_Company_Contact__c )),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
NOT(ISBLANK( Appraisal_Ordered_Date__c )),
ISBLANK( Appraisal_Date_Time__c ),
Text ( rethink3__Broker_Representation__c ) = ("SELLER" "Double sided")
)
Try this:
-Thanks,
TK
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.
All Answers
Try this:
-Thanks,
TK
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.
Hi Karla,
You can use above mention formula whch has been updated by Tarun. It will work for you.
Thanks,
Arvind Kumar