Skip to main content

I would like the holidays to be recurring dates yearly. This is to be included in the same table as the leave tracker so that everything is in 1 calendar view only.

Isn't that tricky because your end date will vary? Do you want a fixed number of days or a certain day of the week as end date?

Isn't that tricky because your end date will vary? Do you want a fixed number of days or a certain day of the week as end date?


For the holidays, they will all have the same end dates. Is it possible to make them a recurring one?

You could add 2 formula fields to add a year to your current start and end date, and then have an automation that triggers on the update of those fields to create a new record for the next year. 

Formula could be:

IF(TODAY()={Start Date}, DATEADD({Start Date}, 1, "year"))

 Would that be an option?

Reply


Terms & Conditions