You need to sign in to do that
Don't have an account?
Marc Mastrocola 9
Workflow Rule Criteria = Run only when a number field increases
Hi guys,
We have a number field on the opportunity page that counts the number of products that the opportunity has and I'm trying to figure out how to run a workflow rule only when that number field increases in value.
For example, if the opportunity goes from having 1 product to 2 products or from 3 products to 5 products, it should run.
Is there a way to do this?
Thanks!
-Marc
We have a number field on the opportunity page that counts the number of products that the opportunity has and I'm trying to figure out how to run a workflow rule only when that number field increases in value.
For example, if the opportunity goes from having 1 product to 2 products or from 3 products to 5 products, it should run.
Is there a way to do this?
Thanks!
-Marc
All Answers
Thanks for the quick reply, however when I try to use that function in a workflow rule I get the following error:
"Function PRIORVALUE may not be used in this type of formula"
Here is my code:
of_Products__c >(PRIORVALUE(of_Products__c))