function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AnonTestQuestAnonTestQuest 

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
AnonTestQuestAnonTestQuest
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.
Neetu_BansalNeetu_Bansal
Hi,

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.

Thanks,
Neetu
AnonTestQuestAnonTestQuest
How is this any different that what was suggested by Mr. Patel??