I created a workflow rule where the Lead Satus will change to Contacted when the Last Contact Date field is not Null. The rule works for new field updates, but doesn't update old records or goes back to Not Contacted if that field is Nulled out for whatever reason. Advise? I ran into it a few times before with workflow rules... Should I be using process builder instead?
1 answer
You will need 2 Workflow Rules here -
- One Workflow Rule + Field Update to set the field to Not Contacted when someone EMPTIES out the date
- Another Workflow Rule + Field Update to set it to Contacted(which you already have)
Now Workflow Rules are NOT retroactive. In order to apply them for existing records you have to use Data Loader and update a Field say the Last Contacted Date to itself so as to trigger the WFRs.