At my organization, we host an annual event. The event is hosted on a different day each year, but the due dates for the items leading up to it need to be the same number of days before the event each year.
Right now I’ve set this up using a column dedicated to the event date “Ball Date” and when you change/update this date it runs an automation to reflect the duration reflected in the “Due Date Dependency” numeric column (ex. due 30 days before gala.)
My first question: is this the most effecient way to set this up?