I have a spreadsheet which values comes from an importRange built-in function, the thing is that the getRange function is not fetching the right values, regardless the ROW, COLUMN selected, it returns the word "info" all the time except for…
I have a Google Sheet and I'm trying to output a date or string depending on three dates and three booleans which represent a task as complete. I've been writing a custom function to do this but I can't get…
Google Apps Script: I have an array with numbers. The array contains monetary values extracted from an invoice. Another array contains the applicable VAT/tax values. For each tax value I want to find the applicable value pair(s) in the array.…
I'm trying to set up this in Google Sheets, where there's info being added to a spreadsheet and a pdf is created from a template. I copied this code from a YT video: function createBulkPDFs(){ const docFile = DriveApp.getFileById("ID"); const…
This script import new clients from the source files and update the existing clients with possible new data from the client sheet. The problem I'm getting is that the script always update the header "Ultimo cambio" (last change in spanish)…
The options in the dropdown are Completed, In Progress, and Followup. I only want to hide the row when Completed is selected. Is there a way to achieve this? Tried the following function function onEdit(e) { const columns = [3];…
I'm trying to run a script to parse through my sent box and scrape unique email addresses in the to and cc lines of my outgoing email. I think I might be running into a memory limit. But I'm not…
I have a site with a form that is connected to Google Sheets. Whenever I send the form, it will fill the Google sheet nicely, but the Google script won't automatically send out the notification e-mail to the user and…
I'm trying to programmatically check all boxes in a Google Sheet's sheet using Apps Script. I think there is code somewhere whether it's from the source or in some other code else that edits the slicers to show (e.g.) 1…
I have a name in cell A2 eg; A2="Giraffe" i have a specific folder in which i have a file named "Giraffe" Can google sheets find the file and get the link in the output cell B2