Category "google-sheets"

getValue() of cell with time returns incongruent data

I'm trying to extract the time stated on a cell of a sheets file and use it on a function, but I'm struggling to understand what happens: On B2, I've simply inp

Modifying equations that use INDIRECT() inside ARRAYFORMULA()

From what I have read, it appears that INDIRECT() does not function with ARRAYFORMULA(), however have seen some custom workaround solutions fo

how to get a row number in a column if a cell in another column has some data using google apps script?

i have a sheet that have 5 columns (date , id , name , number ,row number) and i want the fifth column(row number) to be auto filled with the row number when i

Google Sheets - Fill in date from another cell if empty

Thanks in advance for your help! Our team has a Google Sheet that is used to manage projects. There is a Start Date (Column E) and a **Due Date **(Column F) tha

Two Way Sync of Specific Ranges Across Two Separate Files In Google Sheets via Apps Script [duplicate]

Apologies if this is a somewhat long post - I can further clarify anything here if needed. I basically have an Apps script question in regards

Google sheets- script to copy and paste cell contents to cell using VLOOKUP type of action

I would like to create a script that I can assign to a button in Google Sheets that will copy and paste cell contents in a given column to a cell in that same c

Generate unique URL for sharing Google Forms?

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

PERCENTILE IF using ARRAYFORMULA for a set of conditions

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

How do I show Popup Message everytime I go to another Sheet using Google Sheet/Apps Script? [duplicate]

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

How to uppercase a cell range even if user type or paste lowercase with no warning in Google Sheet

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

Python and spreadsheet: given the user input, expand the list of results using regex

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

How do I get a cell's color from a Google Sheets doc in Colab (python) without Google API?

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

Getting #ERROR! Message when combining valid formulas

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

Move row to a different sheet when box is checked

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

List unique years from a set of dates in google sheets

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

Bulk rename file names in Drive Folder with Google Sheets

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

Google App Script. Retrieve emails list from the sheet

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.

Get specific information from wikipedia on google spreadsheet (not the entire table)

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.

Formula Bar to tiny google sheets

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 to google apps script that I want to have the data sorted automatically

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

Other Categories