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…
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)…
Importing using importxml code: =LET(list, IMPORTXML("https://www.officialcharts.com/charts/dance-singles-chart/20240212/104/", "//*[@id='__nuxt']/div[3]/div/main/div[2]/section/div/div/div/div/div/div[2]/p/a/span"), WRAPROWS(BYROW(list, LAMBDA(r, JOIN("", r))), 2)) The errors are to do with pulling unwanted text from column 1 chart positions NEW and Re get pulled in and causes table data to jump out of…
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
This is the simple code which remove all the duplicate values and working fine. function removeDuplicate2ndPhase() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Hourly Data'); var lastRow = sheet.getLastRow(); var range = sheet.getRange('B3:M' + lastRow); range.removeDuplicates([3]); } all i want to remove duplicate…