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.
Recurring Dates Yearly
+4
+25Isn'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?
+4Isn'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?
+25You 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?
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.