Could you please suggest a workaround to fire a work flow/ process when a formula field changes. I have a complex formula field which calculates 'yes' or 'no' based on certain date criterias. When a date expires it will change the formula field accodingly.I want a workflow or process to update another field when this formula field updates. Any suggestions on work around would be much appreciated.
4 réponses
Hi Ancy,
A formula field will not trigger a workflow or process builder
the workaround is to trigger the workflow if any of the fields referenced in the formula field changes.
for simplicity say your formula references two fields, Field A and Field B
trigger the workflow or process when either of the fields gets changesthe criteria will be as below
OR(
ISCHANGED(FieldA__c),
ISCHANGED(FIeldB__c)
)
could you please post your formula here
