I've been puzzling over this problem for hours now. Here is what I am trying to achieve. The end goal is to be able to modify the name of a job using a sidebar in Google Sheets. The sidebar can…
I'm trying to merge the data from all the sheets into one sheet. How can I escape the [] inside the query function? function listAllProducts() { var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var sheets = spreadsheet.getSheets(); // Start from index 1 to…
I had the following error and thought I'd share my solution as I couldn't find it online. My initial code: import * as google from 'googleapis'; const sheetsAPI = google.sheets({ version: 'v4', auth: apiKey }); Gave me the error: google.sheets…
Pretty self-explanatory, but given 2D array indices (as CSV), how do I convert it to a spreadsheet cell coordinates? For example, "0, 0" would output "A1", "3, 4" would be "D5", etc.
I have this function that automatically assigns the time when cells are being filled up in certain rows. It works fine in the datasheet, but in the web app that I created for this sheet, VERY wrong dates are being…
I'm hesitant to post this here as it seems like it should be an easy error to solve, but every option that I've tried doesn't result in the error resolving. I'm working on a application in Google Sheets where people…
Please help me with the script I want to run when I check a specific checkbox in Google Sheets. It works for me when I put it with a button but it doesn't work on tablets so I want to…
I have put a form in a Google Sheets sidebar with HTML. The form loads quickly when I select the form from my custom menu. This form is used once at the beginning of the day by one user. However,…
Is there any way to apply this function to a sheet named "Production Log"? function CopyDatatoLog() { var spreadsheet = SpreadsheetApp.getActive().getSheetByName('Production Log'); spreadsheet.getRange('B8:B11').activate(); spreadsheet.getActiveSheet().insertRowsBefore(spreadsheet.getActiveRange().getRow(), 4); spreadsheet.getActiveRange().offset(0, 0, 4, spreadsheet.getActiveRange().getNumColumns()).activate(); spreadsheet.getRange('A8:BL11').activate(); spreadsheet.getRange('4:7').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false); }; I keep getting this error "TypeError:…
I have an onEdit trigger set up for this script: function ifBold() { var cell = SpreadsheetApp.getActiveSpreadsheet().getRange("'Prospect List'!A:A"); if(cell.getFontWeight() == 'bold') return true; else return false; } I have one sheet that I enter data into and it creates a…