+ Start a Discussion

Workflow will not fire on formula field... alternative solutions?

We are working with the cases.

The goal is to contact the person who submitted the case when there has been no response from the customer (1 day, 2 days, 3 days).


I have a formula field that calculates the Days with no response which is working perfectly. The problem is you can not run the workflow off the changes of the formula field, since it is not editing the record.


What would be the most efficient way to accomplish this? I tried using a workflow to update the field for Days with no response, but it does not seem to be updating properly.


I would suggest moving the logic from the formula field into a normal field that is populated on a before insert trigger. If you do this, you may be able to use a workflow on this field.


What do you think?