I have a Google Form that contains a simple question that can be answered "Yes" or "No". The responses are being filled in a Google Sheet. How can i identify wh
I need to calculate the percentile using an if condition to calculate it by group of conditions, but Google Sheets doesn't provide PERCENTILEIF function. A nona
I have 3 sheets in a workbook - Sheet1, Sheet2, and Sheet3, every time I change to a Sheet there is a Popup message that will show up. What I
I've made a simple table in a one of many sheets in a google sheet file and I would like a cell range of a sheet to alway appear upper case no mater what user i
I'm working with Python on a movie database on google sheets. I want to build a query searching a list of names and surnames on three columns. I ask the users t
I am importing a Google Sheets document into Google Colab for data analysis using python. I would like to get formatting information from the Google Sheets docu
I am trying to setup a formula in one line that will calculate the proper date that a contract can be cancelled based on the Texas Addendum for Property Subject
Hi I'm very new to coding with Google Sheets and Excel. My goal is to move a row when it is checked off. The original sheet is called "School Assignments" and t
I am currently achieving the process of extracting unique years from a range of dates with the use of helper columns shown here: Is it possible to achieve the
I need to rename image files in a Google Drive folder I have a Google Sheet with 2 columns, old name and new name I would like to rename the files within the sa
In the following script I have to manually insert the email addresses. I rather get the list from the sheet to be able to update it without editing the script.
I have a table from "Lead rolling actors" from Wikipedia and I want to add some columns to the table with the dates of birth, years active etc for every actor.
Can I make it bigger the formula bar in google sheets? I would like to see the entire formula so as a workaround I'm unsing an online IDE to edit. Online IDE h
I have this script below that imports data automatically from several sheets via a master sheet that has a list of sheet IDs. I would like the data to be auto s
I'm using a query & importrange combo like this: =IFERROR(QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1EizWsVwZfUy1NDRwmmWEpj2OxTGvBjP9-YBbds9
I use a script that allows me to delete the empty rows in the middle of my table and also constantly adds rows at the bottom so that I can keep filling it. Ever
I'm looking to improve my array push inside loops but I noticed that every time my function is being called (in a loop manner) and executing this lines of code,
I have downloaded the data to csv via Postman. The problem is that I don't have a classic structure: id;name;country 1;Paul;USA 2;John;Germany but structure li
In google sheets what's the syntax to pull from another sheet, a line item that contains #N/A in a column? I am writing the script on tab1 and the data I am pul
I've been trying to save this macro but I get the error message at line 29. However, everything looks right to me? I cannot understand how to get rid of the err