Closed 2 hours ago.

Closed 2 hours ago.

Closed 2 hours ago.

Is it possible to create a script for AppScript that function as xlsx converter ? I know there is an easier way to convert using “save as”. But i’m hoping that the old file is still being used.

Is it possible to create a script for AppScript that function as xlsx converter ? I know there is an easier way to convert using “save as”. But i’m hoping that the old file is still being used.

Is it possible to create a script for AppScript that function as xlsx converter ? I know there is an easier way to convert using “save as”. But i’m hoping that the old file is still being used.

I’m attempting to clean a spreadsheet of CSV data that originally contained roughly 700,000 rows. My specific issue is that I’m having trouble finding an easy way to mass delete all rows (minus column headers) that have blank cells scattered in the last two columns. I’m hoping someone can give me an example of an apps script to delete these many rows at once that are only partially blank (or maybe some other solution).

I’m attempting to clean a spreadsheet of CSV data that originally contained roughly 700,000 rows. My specific issue is that I’m having trouble finding an easy way to mass delete all rows (minus column headers) that have blank cells scattered in the last two columns. I’m hoping someone can give me an example of an apps script to delete these many rows at once that are only partially blank (or maybe some other solution).

I have an Autocrat job set up in Google Sheets using info from Form, which I later process in the same answer sheet. Part of that processing includes a VLOOKUP search which looks for dates in a second sheet.

I’m currently working in Google Sheets. When I want to set a link from one “Worksheet” to another “Worksheet”, I usually do the following: