I've just downloaded the Holiday Planner sheet, which seems exactly what we're looking for. However, it doesn't seem to be working correctly The only changes I have made is to update the year from 2022 to 2023, however, when I try and run the script I get the error - TypeError: Cannot read properties of null (reading 'getLastColumn') When someone fills in the form, it's correctly recording the data in the vacation request form and manager sheets, but that info is not feeding into the 2023 (was 2022) tab, and is also not being recorded in the calendar Anyone have any ideas?

@"EmilStickland"#p1773 Hi there, Could you please share your sheet with us? Share with [me ](karoline@sheetgo.com)and then I'll be happy to share with our tech team.

TypeError: Cannot read properties of null (reading 'getLastColumn')

JessDavies

uroberts-twinn

I have exactly the same issue - is someone able to assist please? Thanks.

Vitor from Sheetgo

Hello uroberts-twinn Please, could you share the calendar ID with your colleagues?
They need to subscribe to the calendar.

uroberts-twinn

Everyone has now subscribed, same issue, am I missing something? Thanks

Vitor from Sheetgo

uroberts-twinn would you mind sharing your workflow so we can investigate this issue? Enter our web app, click on the workflow, and then on “share settings.” Add my email [vitor.m@sheetgo.com](mailto:vitor.m@sheetgo.com), press ↹ (tab key), and make sure you enable “manager access” and check the “enable file editing” checkbox

Vitor from Sheetgo

uroberts-twinn Ursula thank you for sharing your workflow, we’re addressing this issue with our development team. As soon as I have an update I’ll let you know

sue

I’m having the same problem. Staff members have not subscribed to the calendar as I can add them directly from the settings, is this the problem?

It shows as collated data from the form and give me the option to approve or deny, but isn’t adding that data into the sheet, calendar or notifying me when a holiday is booked.

Is this because I’m trying to test it from my own email address?

sue

I’m still having issues with my sheet, if someone could let me know where I’m going wrong would be great.

Currently I’m having to manually approve the days, add them to the sheet and calendar.

Karoline from Sheetgo

sue Hi Sue,

We are actively investigating the issue and will have an update for you within the next few days.

SarahRobertson

Hi,

I am having this issue. Is there any update?

Thanks!

Vitor from Sheetgo

Hello SarahRobertson this template is currently going through review to improve it’s usage. If you would like I can share with you the new beta version of this template that you can try it out

SarahRobertson

Vitor from Sheetgo yes please! That would be extremely helpful :)

Vitor from Sheetgo

SarahRobertson perfect, I’ll share it directly with you