I have a field called Contract on the lead object. I also have a formula field called 'Contract Number' on the Lead object which should get populated with the Date that the 'Contract' field was populated.
I cannot use Workflow because there is batch apex updating the 'Contract Date' field so it needs to be the formula field I have created. The 'Contract' field will only be updated once and will not change therefore the Contract Date should be the same. Any ideas?
Best Answer
So if I understand correctly, the requirement is this:
So the steps to take are:
That should do it. The workflow will run only once (when the Contract field goes from empty to non-empty).