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

AppSheet AppSheet Q&A
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

Does anyone know a better solution?

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

2

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

3

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

4

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

5

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

6

Why do you want to do this?