Category "google-sheets"

How can I output the values I want by using TEXT() version of TODAY() and FIND() in an IF() formula?

I would like to output "Yes" or "" in column B by using the text version of today's date (e.g. Fri) and finding Fri in column A with values like Tue, Fri, Sun

Difficulties using ArrayFormula

I am trying to use ArrayFormula to populate row data. I have the following formula that work perfect when I drag down, however I am unable to figure out how I s

Delete Rows a day after the date has passed

I am still fairly new at script writing and am trying a write a script that deletes a row one day after the date which is in column L. The data is in range A133

Use calculated fields in a Google Sheets pivot table to count rows where a field equals a specific value

I have a sample sheet at https://docs.google.com/spreadsheets/d/1Of8JhSnFziFcxSqb4C4eRnZnob1ZuxAnqQOCGdzqvqI/copy. I have a sheet/tab with data: Sheet1. I have

Is there a single Apps Script function equivalent to MATCH() with TRUE?

I need to write some functions that involve the same function as the Sheets function MATCH() with parameter 'sort type' set to TRUE or 1, so that a search for 3

Filling up an empty cell with adjacent cell's value

I am looking for a simple script which can turn this into this As you can see I have manually copied and pasted those empty cells in E column with the corresp

Google Sheets Split function with Array

I have a table of current work hours in column A. Column B has newly assigned work hours. Column C just sums up the first two columns to show the new work hours

GSheets Forumula Stalls on Tie Score Number

Background Information I am trying to setup a 1st, 2nd and 3rd rank/scoring system on Google Sheets. The sheet is setup by row and once a week a new row is adde

Google Sheets Batch Update payload Limits

So I'm doing a batchUpdate for a lot of data. Personally, I'd love to upload all of it in one shot. However, I suspect there might be some limitations as to the

Regexextract multiple <a> links from HTML

I have an extract from a description off a webpage which contains multiple links to other pages the whole string is in a single cell. The string below is along

How do I sum the last 10 rows of column "D". with the result in a cell in column "F"?

I have been using this and it works, but everyday I add a new row and have to insert a row above this formula, that's why I want it to display in column "F" som

Asycn interation in python loop with spreadsheets

__Hello! I'm using Google API. And I have a dictionary with, for example, 10 keys. And I have 12 columns, which two of them are empty. I created a loop (for key

If cell contains a certain text, return a specific drop down list item (Google Sheets)

I've created a quote form, and in one cell (C6:H9) I enter the address with the city name. In another cell (C31:F31), I have a drop down list with different cit

ultimate short custom number formatting - K, M, B, T, etc., Q, D, Googol

is there a way how to custom format ridiculously large numbers (at least up to 10^100 in both ways) in google sheets: thousands > K millions

Retrieve the deals from Hubspot using its APIs

I'm trying to integrate the Hubspot Deals to Google spreadsheets, I'm following a tutorial https://medium.com/how-to-lean-startup/create-a-hubspot-custom-dashbo

Prevent IMPORTDATA from refreshing

I have a script runing which uses IMPORTDATA to capture data from a website. Every hour it goes to the website, and captures a price value, and pasts it into a

Python dataframe to Google Sheet: Freeze rows and sketch vertical lines around a sets of columns

I have a dataframe df_final (it is a time series data) as shown in attached photo. I am able to write this dataframe to the Google Sheet using the code below. Q

setValues Exception: Service error: Spreadsheets How to fix range errors?

function chk(){ //PDD data setting var today=new Date(); var Date = Utilities.formatDate(new Date(today.getFullYear(),today.getMonth(),today.getDate()), S

Filtering google sheets import data before import

I have a script that imports data from a google sheet. Before importing the data into the new sheet I would like to filter it. In Column2 are our Cost centers l

Data Formulation

I am hoping to get some help formulating an array to more concisely view my data coming in from a google form. Is this something someone can help me with? I'm s

Other Categories