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.
If you are using gSheet as a backend, then the script would be the next solution.
@Aleksi_Alkio Good idea. Do you have an example? In my Test I had 462 syncs and it took 22 minutes
Iโm afraid I donโt have any but it should be quite simple when you know the language.
@Fabian you can use the macro record option in gsheet.
Why do you want to do this?
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |