The company I work at has been making and printing daily reports as .ods files. Historically it's been a painstaking process, so I'm trying to automate pieces of it with Google Sheets and Apps Script. The bookkeepers however still expect…
Good evening, I am trying to figure out a way to automatically delete files with duplicate filenames from a Google Drive folder. I'd like to keep the file with the oldest creation date, treat the others as duplicates, and delete…
In Google Sheets, I have been trying to copy data from Sheet "Main" to Sheets (Completed, Pending, Hold) based on selection from dropdown in column 6 named (Status) in Main Sheet. Column 6 DropDown List (Completed, Pending, Main) Once a…
The Woocommerce export to a Google Spreadsheet with the code below works. Except the format of the order total shows "99.95" instead of "99,95". This results in some faults in further processing the data. Is there a solution to fix…
I am trying to write a Google Sheets script to copy the display values from one sheet on a workbook to another sheet on a workbook. However, I am receiving the following error message, "Exception: The number of rows in…
Hoping to get some help on a rather interesting formula! Column A = Start Date Column B = End Date Column C = # Sales Goal: create a calculator on the same sheet that allows me to input two dates…
I have a database that has columns of RGB values and I wanted to display the color on anther column. I will have a custom function on the cell where I passed in the RGB values from the other columns.…
I have developed a serverless application using next.js, Vercel, and Google Sheets. I am using Google sheets to save customer contact data. My application logic works fine locally during production. I am receiving the data successfully in my google sheet…
I want to automatically produce a PDF of my invoices. The worksheet (master) where I generate the invoices has several tabs which I do not want to print. My thoughts were to create a single tab sheet and print from…
How to make .map() ignore values in array. In script below values in column B and C of dstSheet are erased when running script. I want to keep it. How to modify this script? function dorozliczenia() { const ss =…