I have a workflow rule that fires an email when a field value is >= 90%. I have the rule set to fire on created, editied and did not previously meet criteria. I don't want the rule to fire every time the record is edited when that field in >= 90%.
Is there a way to have the rule fire the FIRST time the criteria is met, then not fire again until the field drops BELOW 90% and then again above 90%? Effectively, resetting the rule once it fires and then no longer meets the criteria?
Thanks!
4 answers
Take a look at PRIORVALUE() and ISCHANGED() functions in the workflow entry criteria function list. You can use these in addition to your existing criteria so the rule only applies when you want it to.
