You need to sign in to do that
Don't have an account?
Karla Pliego 3
Formula with Picklist values
I am unable to figure out how to build formulas for picklist values. For the following formula I want that if Loan type equals any of the following statuses VA, FHA and Conventional, and broker representation is SELLER or double sided and Lender company contact is blank, then the WF triggers. I've tried numerous combinations of the below, but it does not trigger. No errors in syntax, just does not work when the conditons are met.
or(
ISPICKVAL(Loan_Type__c, "VA"),
ISPICKVAL(Loan_Type__c, "fha"),
ISPICKVAL(Loan_Type__c, "conventional"),
(ISBLANK(Lender_Company_Contact__c )),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
OR(
ISPICKVAL( rethink3__Broker_Representation__c, "SELLER"),
ISPICKVAL( rethink3__Broker_Representation__c, "Double sided")))
or(
ISPICKVAL(Loan_Type__c, "VA"),
ISPICKVAL(Loan_Type__c, "fha"),
ISPICKVAL(Loan_Type__c, "conventional"),
(ISBLANK(Lender_Company_Contact__c )),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
OR(
ISPICKVAL( rethink3__Broker_Representation__c, "SELLER"),
ISPICKVAL( rethink3__Broker_Representation__c, "Double sided")))
Use this,
Thanks,
Arvind Kumar
Use below formula, It would be more helpful for you.
If you have any query,then contact me.
Thanks,
Arvind Kumar