Hello, I"m building an Airtable Template to recreate a table with the same Event tasks for each new event. We want to use logic like we had in Asana, that let's us say do XYZ task 30 days before Event Start Date. I am using a DATEADD Foruma to produce this, and it's returning the wrong YEAR, but Month and Day is correct.
This is the formula.
I tried just plugging a date directly into the Recurring Tasks Tab, and although that fixed the formula error, it's not what I'm looking for. I'm looking to create a 'template' of tasks, and need the lookup to pull in a date from our list of tradeshows. Is there another way to fix the formula year issue?