I want to create workflow and i want formula to be like is, When Property_status__c = Unqualified, Watch__c = True, Current_price_list__c = --Decrease, Top__c = ++increase, City__c = Chicago.

For example,If Current List Price goes down And If Top Property Price goes up and meet other criteria, at that time workflow should fire.

In this one i am not sure how can i use increase and decrease for any field?

Any help please.

  • The issue is how would you keep track of old value.
    – Mr.Frodo
    Apr 29, 2016 at 14:56
  • Cant i do like if the value goes down from current value(whatever it is) then workflow will fire. Apr 29, 2016 at 14:59

2 Answers 2


Not sure if this is the right syntax, but you could try to create the workflow when the formula evaluates to true. It would look something like this, without having to create any additional fields.

(Property_status__c == "Unqualified"),
(Watch__c == "True"),
(City__c == "Chicago" ),
(ISCHANGED(Current_price_list__c )),
  • Tried that,but its not working. Apr 29, 2016 at 16:09
  • are all your described fields of type 'Text' , because if they are of type picklist value you'd have to use the following syntax IsPickValue(MyField__c, "Case1") Apr 29, 2016 at 16:20
  • What about currency field? Current_price_list__c is a currency field. Apr 29, 2016 at 16:24
  • the currency shouldn't be a problem as it will interpret the value when performing the calculations as far as I'm concerned. try To eliminate 1 condition at a time and see where is failing. From a logical perspective the workflow should work Apr 29, 2016 at 16:32
  • AND( (IsPickValue(Property_status__c, "Unqualified")), ( Watch__c == "True"), (City__c == "Chicago" ), (ISCHANGED(Current_price_list__c )), (Current_price_list__c -(PRIORVALUE(Current_price_list__c ))<0), ) Apr 29, 2016 at 16:37

You will probably need a new field for the previous price. and have a workflow that will copy the value into this field when the price changes. then on your other workflow you can do if old price is larger than new or if old price is smaller than new fire the workflow.

  • Thats what i also thought, but how can i store previous value in other field? Apr 29, 2016 at 15:20
  • you will need a workflow for the price with ISCHANGED(Field name) and then workflow can use update field and update the new field (old price) with the price.
    – Benjy Hunt
    Apr 29, 2016 at 15:29
  • I think directly using PRIORVALUE() is much better choice rather then creating new field.See @marc answer.
    – Mr.Frodo
    Apr 29, 2016 at 15:31

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .