Close an opportunity 90 days after its last commercial activity (change of stage in this case).
I'm pretty sure this can be done with a pair of workflows, I just can't seem to find the correct approach. I've tried to create a first one with the formula
ISCHANGED( StageName ) that updates a hidden date field. Then, on the time-based workflow, set the condition to
Hidden_Date_field__c = TODAY(), but this isn't working. And even if it did, I'm sure the following day the time-based action would be revoked due to the condition not being met.
Are you guys aware of any workaround for this, preferably standard without code? The formula
ISCHANGED(field)can't be used in a time based-workflow and I'm not too keen on developing a trigger just for this... but I'm all ears.