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
SF@SiemensSF@Siemens 

Workflow Function to check if Number field has changed

Hi,
 
I know that there is a function you can use in a workflow (ISCHANGED(field)) to see if a field has changed from a previous value.  For numbers, it only evaluates to "true" if the number was previously blank or zero.  Is there a way to determine if the number differs from the previous one and WAS NOT blank or zero?
 
Thanks for any help,
TCAdminTCAdmin
Hello SF@Siemens,

I haven't tested but you may be able to use a workflow rule and field update to populate a separate field with the PRIORVALUE() of that field. Then use the formula of Prior___c <> Current to trigger another workflow. You can add the blank/null criteria in after that.