Skip to main content
Topics#Data ManagementDomanda di Roger Lao
Roger Lao (Y. Hata & Co., Ltd.) ha fatto una domanda in #Data Management
4 ott 2017, 22:38

How to create a formula field that creates specific text if another field contains text

On the Account object we have a custom field (AS_400_Customer_Key__c) (text).  We need to create another formula field (CustomerLocation) (text?) that says if AS_400_Customer_Key__c contains "# 1# 1" then CustomerLocation should show the text "Location1" if CustomerLocation contains "# 1# 2" then CustomLocation should show the text "Location2", etc.  This is what we have right now, but CustomerLocation is not showing anything despite AS_400_Customer_Key being populated

 

IF(CONTAINS(AS_400_Customer_Key__c,"# 1# 1# 1# 1"),"Location1",

 

IF(CONTAINS(AS_400_Customer_Key__c,"# 1# 2# 1# 1"),"Location2",

 

IF(CONTAINS(AS_400_Customer_Key__c,"# 1# 1# 3# 1"),"Location3",

 

IF(CONTAINS(AS_400_Customer_Key__c,"# 1# 1# 2# 1"),"Location4",NULL))))
8 risposte
  1. Ankur Saini (IBM)
    5 ott 2017, 05:26
    Hi Scott,

     

    I have tried your formula code. It is working fine.

     

    Please ensure, the value entered in AS_400_Customer_Key__c field is same as the value used in formula.

     

    Please check the value, it may have extra space or no space.

     

    Thanks,

     

    Ankur Saini

     

    http://mirketa.com
Scrivi una risposta...
0/9000