You need to sign in to do that
Don't have an account?
Karla Pliego 3
Formula For Lookup field being blank
I want to trigger a WF if a lookup contact field is blank in a record. There are a few other conditions as well. THe start transaction (date field), buyer selling agent and listing agent (both lookup contact fields) must not be blank and it has to be broker represenation Seller or Double sided which are picklist values both, I get an Extra , error when checking the syntax
AND(
NOT(ISBLANK(Start_Transaction__c)),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
ISBLANK(Title_Contact__c)),
OR(
ISPICKVAL( rethink3__Broker_Representation__c, "SELLER"),
ISPICKVAL( rethink3__Broker_Representation__c, "Double sided"))
AND(
NOT(ISBLANK(Start_Transaction__c)),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
ISBLANK(Title_Contact__c)),
OR(
ISPICKVAL( rethink3__Broker_Representation__c, "SELLER"),
ISPICKVAL( rethink3__Broker_Representation__c, "Double sided"))
All Answers
Please try below:
AND(
NOT(ISBLANK(Start_Transaction__c)),
NOT(ISBLANK(Buyer_Selling_Agent__c)),
NOT(ISBLANK(Listing_Agent__c )),
ISBLANK(Title_Contact__c),
OR(
ISPICKVAL( rethink3__Broker_Representation__c, "SELLER"),
ISPICKVAL( rethink3__Broker_Representation__c, "Double sided")))
Error: Field Start_Transaction__c is a picklist field. Picklist fields are only supported in certain functions. <a href="javascript:openPopupFocusEscapePounds('https://login.salesforce.com/services/auth/sso/00D30000000XsfGEAS/HTAuthProvider?startURL=%252Fapex%252Fhtdoor%253Floc%253Dhelp%2526target%253Dtips_on_building_formulas.htm%252523picklists_and_msps%2526section%253DCustomizing%2526language%253Den_US%2526release%253D206.18.3%2526instance%253DNA35&site=https%3A%2F%2Fhelp.salesforce.com', 'Help', 1024, 768, 'width=1024,height=768,resizable=yes,toolbar=yes,status=yes,scrollbars=yes,menubar=yes,directories=no,location=yes,dependant=no', false, false);">Tell me more</a>