I have a google sheet that i am trying to search, match, and then auto-populate some data to. Here is the google sheet layout Here is the lookup table layout I wrote some javascript code to try to search cell…
Apologies in advance if this has been asked already. With Mint shuttering and forcing us to Credit Karma, I'm hoping to build a semi-automated budget and spending tracker in Google Sheets, and would love if someone could help me figure…
I would like to use a script to convert the column B2:B (text format) into minutes and seconds (mm:ss). I can do this with a formula (=B2/86400), but it should be implemented with a script: COLUMN B (COLUMN B) 244…
I'm creating an onEdit(e) script to highlight cells in a Google spreadsheet (in a specific column) after a specified user has edited them. Thing is, I need this to apply to all spreadsheets with a specific naming convention, and all…
I have ZERO php experience, so my code/problem is purely based off Googling. I apologize in advance if you all cringe at my code. I have created a php script which I run via cron every 5min to get data…
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…