function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Workflow Criteria Issue <> <70

I have a WFR firing an email when a percent field is 70% or greater. It has the criteria, Custom % field greater or equal to 70. It fires anytime the record is edited though, even if the field in the criteria is entered as 35% or something below the 70 threshold. I am trying to change the criteria to a formula where the custom field >= 70 && custom field <> <70.

SF doesn't like that syntax.

Any ideas?
Ketankumar PatelKetankumar Patel
Try this. 
ISCHANGED(Your_Custom_Field) && Your_Custom_Field >= 70

User-added image
I will give that a shot but this doesn't cover the part of code I wanted to ensure that when the record was updated with a % below 70 that the alert wouldn't be sent. What you posted is sort of the same thing as what I had and it fired when a record was saved ever.

Give this formula a try in your workflow rule:
AND( ISCHANGED( Your_Custom_Field ), Your_Custom_Field >= 70 )
Let me know, if you need any other help.

How is this any different that what was suggested by Mr. Patel??