+ Start a Discussion
Jay Parikh 36Jay Parikh 36 

Workflow rule for checkbox

I have one checkbox field on account object and I want to create workflow rule where every time that checkbox values go from True to False then it will update one field which is date data type with on which date that checkbox goes from true to false and I do not want to update that date field when record is created it only fired when checkbox goes from true to false
Best Answer chosen by Jay Parikh 36
Shawn Reichner 29Shawn Reichner 29
Hope this helps

When you create your workflow rule, you will need to choose the option to fire when record created or any edit, and for your criteria use a formula and have your formula such as the following:

AND(
!IsNew(),
 PRIORVALUE( Checkbox Field API Name) = True,
Checkbox Field API Name= FALSE)

Then have your workflow acton as a field update and update your date field using a formula and set the folrmula for the field update to TODAY() if your field is of date type or use NOW() if your field is date/time type

Hope this helps, if so please click th ebest answer!

Shawn