Hi @Kerri_Sheehan - how about this:
Create two tables - one of the events and one for the tasks:
The event is linked to the task and the event date is pulled through as a lookup. Each task has a “number of days before event” field and then the due date for this task is a formula using the {Days Before}
and {Event Date}
fields:
DATEADD({Event Date}, ({Days Before} * -1), 'days')
Then, when you have a new event, create this in the events table. In the tasks table select and copy the set of tasks from the previous event, then paste this back into the tasks table. Finally, change the linked event for the newly copied tasks to the new event:
JB