+ Start a Discussion
Karla Pliego 3Karla 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"))
Best Answer chosen by Karla Pliego 3
Deepak Maheshwari 7Deepak Maheshwari 7
If it is picklist field then use it like NOT(ISBLANK(TEXT(Start_Transaction__c)))

All Answers

Deepak Maheshwari 7Deepak Maheshwari 7

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")))

Karla Pliego 3Karla Pliego 3
Got this message: 

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>
Deepak Maheshwari 7Deepak Maheshwari 7
If it is picklist field then use it like NOT(ISBLANK(TEXT(Start_Transaction__c)))
This was selected as the best answer