__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
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
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
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
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
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
function chk(){ //PDD data setting var today=new Date(); var Date = Utilities.formatDate(new Date(today.getFullYear(),today.getMonth(),today.getDate()), S
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
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
If column C has the word "Matured", and D has a valid date, then formula in column E should automatically generate a serial no., one higher than the previously
I'm new to using apps script and I'm just trying this out. I want to convert zeros to blanks. This is the code I've managed to create, but it doesn't work and I
I am a beginner programmer. I am trying to make a website that does the following: Displays a map using Google Maps API Displays a form with checkboxes that lin
I've scoured the forums but can't find an answer. And this is the 2nd time I've had to write this! I have a google workbook where "Sheet1" gets its data from a
When clicking "button1" I would like the code to check the First Cell (Column A) of Rows 38-58 and hide the Row if the corresponding cell is empty and show if i
I need to extract each word (phrase) within a cell in google sheets and put each one under the other in a column (row for each one). I have a regex code that w
I got responses from Google form into Google Spreadsheet. I want to filter out the "Weekend" and "Workday". For the "Weekend" days, I only want to select the co
Google Sheets has the following IF Function: IF(logical_expression, value_if_true, value_if_false) Is it possible to have multiple 'values_if_true' where the fo
How to RegexReplace but only for number. I tried this formula, but it didn't go as I expected: =REGEXREPLACE(A2, ":<BR CLASS="""">[0-9]", ": [0-9]") Th
I have cells containing data in google spreadsheet as quantity of some entity and I wish to extract only that string which is after the quantity value (number).
I cannot work this out: In Google sheet, I'm trying to unpivot a wide and long table by using this formula: =ARRAYFORMULA((SPLIT(FLATTEN(sheet1!$J$3:$J&"//"