I would like to add two fields on a contact record. One date, "Start Date", and one integer, "Call Frequency (months)". I will then have a formula field, "Days until next call" that evaluates to:
Now, each day that number will count down from 30*frequency (so if you set at 2 months, it will start at 60 and count down)
I would to verify that this formula changing counts as editing the contact. If so, this means that I can use this formula as a trigger for a workflow rule. Everytime "Days until next call" is equal to one, create a task with a due date of trigger date + 1.
Will this work? I've verified that the trigger works, but only by changing the start date. I want to check if TODAY() changing will also trigger the workflow.