I'm progressively working through learning enough of HTML and javascript to apply to a google sheets package I'm developing for personal use. I developed a script from assistance on a previous post I made but am having some issues. Essentially…
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 am trying to create a sheet for my friend and me about some items selling, cost, and state (Sold, in the sale, etc) and I want to automate my "state" column, which contains dropdown menus with "Sold !", "waiting…
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…