Skip to main content
Topics#Data ManagementRoger Lao 的问题
Roger Lao (Y. Hata & Co., Ltd.) 提问于 #Data Management
2019年4月27日 00:45

Formula Text Field with If And Or

Trying to create a formula field (text), that checks to see if Customer_Key__c Contains "ABC" AND Route_Number__c Contains "123" OR "456" then display "Location 1"

 

If the above is all false, then check to see if Customer_Key__c Contains "DEF" and if so, display, "Location 2"

 

otherwise, display "Location 3"

 

We keep getting "Location 3" for the result

 

IF(

 

AND( 

 

CONTAINS(Customer_Key__c ,"ABC"), 

 

OR( 

 

CONTAINS(Route_Number__c,"123"), 

 

CONTAINS(Route_Number__c,"456"))), 

 

"Location 1", 

 

IF( CONTAINS(Customer_Key__c ,"DEF"), "Location 2", "Location3"))

 

)
7 个回答
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2019年4月27日 02:24

    Try using this 

    IF( 
    AND( 
    CONTAINS(Customer_Key__c ,"# 1# 1# 1# 1"), 
    OR( 
    CONTAINS(UPPER(Route_Number__c),"HILO"), 
    CONTAINS(Route_Number__c,"HIL0"))), 
    "Hilo", 
    IF( CONTAINS(Customer_Key__c ,"# 1# 1# 5# 1"), "Maui", 
    "Oahu"))

     

     
撰写回答...
0/9000