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

(Fabian Weller) #1

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 :slight_smile:

Does anyone know a better solution?

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

(Aleksi Alkio) #2

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

(Fabian Weller) #3

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

(Aleksi Alkio) #4

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

(Bellave Jayaram) #5

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

(Steven Coile) #6

Why do you want to do this?