I'm looking for a way to trigger a Process Builder 'process' when a formula field updates.
In previous years, this wasn't possible, but I SWEAR that it was fixed a few months ago and you had to check off a combination of attributes ('fire only when relevant changes made/evaluate criteria multiple times'). I thought I ran into this problem before and I solved it.
Am I crazy? Is there no way to fire a process builder 'process' from a formula field update?
Best Answer
You can't fire from a formula change, but there is strange path. Have a Workflow rules fire on EVERY change (every edit and where CreatedDate not blank). And have this do a field update of the formula field into text field (or number or date, whatever matches). On the field update check the box that it will re-fire workflow evaluations. Now you should be able to do your Process Builder (or other Workflow) off of the text field. Bit convoluted I'll admit, but it should work. Good luck.