Skip to main content
Topics#Data ManagementEmily Farnham의 질문
Emily Farnham 님이 #Data Management에 질문했습니다
2014년 8월 20일 오후 7:00

Need help with formula: True Unless Original Picklist Value = "X"

I want this formula to evaluate to true if the Picklist Field value is changed UNLESS the original picklist value is "X" and is changed to something else, then I do not want the formula to be true. Right now it evaluates true unless I CHANGE my picklist value from something else to "X", which is the opposite of my desired result.

 

Here's what I have:

 

NOT(ISPICKVAL(Picklist_Field, "X"))&& ISCHANGED(Picklist_Field)

 

How do I change my formula to look at the picklist field's original value to evaluate?
답변 5개
  1. Matthew Brown (IBM)
    2014년 8월 20일 오후 7:03
    Almost got it! Just need to add one thing here:

     

    AND(
    ISCHANGED(Picklist_Field__c),
    NOT(ISPICKVAL(PRIORVALUE(Picklist_Field__c), "X")))
답변을 작성하세요...
0/9000