You need to sign in to do that
Don't have an account?
Karla Pliego 3
Formula for Checkbox or Picklist value is blank
Hello,
I want to setup a rule that if a picklist value has not been selected that the WF triggers. I can't get it to work as I'm not sure how to add the picklist value = blank to the formula, used isnull, isblank and they came with errors. The picklist is called buyer using grants in bold below
AND(
NOT(ISBLANK(Lender_Company_Contact__c )),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
NOT(ISBLANK( Appraisal_Date_Time__c )),
OR(
TEXT (isnull (Buyer_Using_Grants__c)
)
,
OR(
TEXT ( rethink3__Broker_Representation__c ) = "SELLER",
TEXT( rethink3__Broker_Representation__c ) = "Double sided"))
I want to setup a rule that if a picklist value has not been selected that the WF triggers. I can't get it to work as I'm not sure how to add the picklist value = blank to the formula, used isnull, isblank and they came with errors. The picklist is called buyer using grants in bold below
AND(
NOT(ISBLANK(Lender_Company_Contact__c )),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
NOT(ISBLANK( Appraisal_Date_Time__c )),
OR(
TEXT (isnull (Buyer_Using_Grants__c)
)
,
OR(
TEXT ( rethink3__Broker_Representation__c ) = "SELLER",
TEXT( rethink3__Broker_Representation__c ) = "Double sided"))
AND(
NOT(ISBLANK(Lender_Company_Contact__c )),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
ISBLANK (Transaction_Closed_Date__c),
OR(
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"))
Please try this
AND(
NOT(ISBLANK(Lender_Company_Contact__c )),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
ISBLANK (Transaction_Closed_Date__c),
OR(
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"))
Can you please elaborate your requirement?
So that I can make it from scretch?
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"))
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( ISPICKVAL(Loan_Type__c) = "FHA",
ISPICKVAL(Loan_Type__c) = "VA",
ISPICKVAL(Loan_Type__c) = "Conventional"))
please use ISPICKVAL function as :
ISPICKVAL(Loan_Type__c,"FHA")
Hi Karla,
Did this worked for you?
If not please let me know.
Hi Karla,
If this works for you please mark it as a best answer
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(
ISPICKVAL ( rethink3__Broker_Representation__c, "SELLER"),
ISPICKVAL( rethink3__Broker_Representation__c, "Double sided")
,
OR
ISPICKVAL(Loan_Type__c,"FHA")
ISPICKVAL(Loan_Type__c,"Conventional")
ISPICKVAL(Loan_Type__c,"VA"))
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(
ISPICKVAL ( rethink3__Broker_Representation__c, "SELLER"),
ISPICKVAL( rethink3__Broker_Representation__c, "Double sided"))
,
OR(
ISPICKVAL(Loan_Type__c,"FHA")
ISPICKVAL(Loan_Type__c,"Conventional")
ISPICKVAL(Loan_Type__c,"VA")))