Reset a sheet at the start of a new year. I ...

[Fabian_Weller]

Reset a sheet at the start of a new year.

I have a sheet with some 600 rows. In each row I have 4 Date columns and 4 Info columns that have to be cleared out at the start of the new year. I can create a set of Actions to do this job, but that would be 60044 = 9.600 Syncs

Does anyone know a better solution?

I don’t want wo go into the google sheet to do this manually.

[Aleksi_Alkio]

If you are using gSheet as a backend, then the script would be the next solution.

[Fabian_Weller]

@Aleksi_Alkio Good idea. Do you have an example? In my Test I had 462 syncs and it took 22 minutes

[Aleksi_Alkio]

I’m afraid I don’t have any but it should be quite simple when you know the language.

[Bellave_Jayaram]

@Fabian you can use the macro record option in gsheet.

[Steven_Coile]

Why do you want to do this?