Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I got a Boolean formula field which is turn to true while records created date more than 3 days. if this formula field turn to true then a workflow assume be triggered to change a lookup field (User) value. this workflow rule Evaluation Criteria I set as (created, and any time it's edited to subsequently meet criteria)
But based on my observation and result outcome, when formula field turn to true but lookup value still remain the same value.
who can give me some help?
Workflow rules do not trigger based on formula field .There is an idea that you can upvote
https://success.salesforce.com/ideaview?id=08730000000BrIGAA0
The value of a formula field is not stored in the database hence I don't think the idea will be easier to deiver .
As an alternative you can write an apex scheduled job or look for other alternatives like time based workflow .
