Editing the Community Event Planner Template

Copper Contributor

Hi. I'm in the process of creating an Event Planner. For this purpose, I have modified the "Community Event Planner". The calendar uses a formula e.g. =IFERROR(INDEX(tblEvents,SMALL(IF(Dates=C$11,ROW(Dates)),ROW(1:1))-TableRowStart,4),"") for the data in the table. Unfortunately, this formula does not allow for events lasting longer than one day. Is there any way that would allow me to write event duration in the table (e.g. number of days or end date of the event - assuming the start date is already in that table) and duplicate these events in the following days depending on the given date?

1 Reply

@RobertBuczaBuczyn Is it this one?

Screenshot 2022-01-18 at 07.20.00.png

If so, it's just one of many templates with often very limited functionality and near to impossible to adjust to ones own specific needs. As you noticed, this particular one does not support events based on start and end dates. If you want to include such an event, just include one entry for each of the days as in the example in the picture below (row 15 and 16).

Screenshot 2022-01-18 at 07.20.20.png

Works good in this one and it's not much effort.