Skip to main content
Topics#Data ManagementAlicia Castorina의 질문
Alicia Castorina (Act-On Software) 님이 #Data Management에 질문했습니다
2017년 9월 8일 오후 9:39

Need help with ISCHANGED and Picklists

I am trying to create a field that stamps the date any one of 5 picklist fields (on the same object) is updated.  I assumed a WFR would do the trick, but even going with "any time it's edited" I can't make the ISCHANGED work with a picklist.  I'm not looking for a stamp on when these fields are changed to any specific values, just want a date stamp for when any of the five are updated, each time it/they are updated.

 

Obviously, the below isn't going to work, but this was my starting point.  Any suggestions?

 

ISCHANGED( CRM__c ) ||

 

ISCHANGED( Target_Market__c ) ||

 

ISCHANGED( Customer_Class_Level_1__c ) ||

 

ISCHANGED( Customer_Class_Level_2__c ) ||

 

ISCHANGED( Marketing_Team_Size__c )

 

 
답변 10개
  1. Maxim Makarenko (iMMERSIVE)
    2017년 9월 12일 오전 8:39

    My bad, Alicia. I think we've got way off-track here =) When you said "Obviously, the below isn't going to work", did you even try it? I realize now that ISCHANGED(TEXT()) is definitely not going to work, because ISCHANGED takes in field names as arguments, not text. So I think your original formula should work, and the more readable option of 

    OR(
    ISCHANGED(CRM__c) ,
    ISCHANGED(Target_Market__c) ,
    ISCHANGED(Customer_Class_Level_1__c) ,
    ISCHANGED(Customer_Class_Level_2__c),
    ISCHANGED(Marketing_Team_Size__c)
    )

    should as well.

답변을 작성하세요...
0/9000