I have a spreadsheet like this - I can't figure out how to dynamically search for this. I want to find the MAX Score Value + output the related name (no worries
I have two columns, the first column (A) has names and the second column (B) has values. A B apple 10 orange 12 orange 14 apple 8 Is there a way to get only r
Master Data Group-Value pairs 1 | 1 1 | 2 1 | 3 2 | 5 2 | 8 3 | 10 3 | 12 Work Data Group-Value pairs + desired result 1 | 4 | 3 (3≤4, max in group 1)
I want to Delete a cell in my google sheet using the sheets API! I did with adding A1 Notation but I'm doing this in a no code application and I need to delete
Google sheet using columns A:M. Each day a new set of raw data (around 30 rows) is pasted on the next available row in column B manually. This raw data contains
I have a real estate office that uses google sheets to show address, buyer name, realtor name, and seller name. For the realtor name column I created a dropdown
I am working on an Android application that uses a Google Spreadsheet as a database. The application should GET, APPEND and UPDATE values in a spreadsheet, usi
I'm an absolute beginner when it comes to programming. I've been trying to import data table from "http://www.rotowire.com/daily/nba/value-report.htm" into goog
I'm currently having an issue with the date format. I have basically extracted the month and year from a standard dd/mm/yyyy date and wish this to be formatted
Using the code below, I am able to write the dataframe df1 to the default first sheet (starting at cell ‘B7’) of the Google Sheet workbook. In the s
I have a google sheet with a table card1 | card2 | card3 | card4 | card5 | card6 | card7 ------+-------+-------+-------+-------+-------+------ set3 | set1 |
I create google form 'on the fly' using data in spreadsheet. Also I install trigger on submit form event. ScriptApp.newTrigger('onSubmit') .forForm(form)
I've been working on this app script trying to automate data from a Google sheet to create events on Google Calendar. I've tried changing the Quotation marks fr
I found code to list the names of all the sheets in Google Sheets (from here): function SheetNames() { // Usage as custom function: =SheetNames( GoogleClock() )
I have a spreadsheet with data in columns A:Z. In column AA is the name of a sheet in the workbook. I'm trying to copy the data in A:Z to th
So I'm attempting to take a sheet from a Google Spreadsheet and save it as a .CSV file just like you can manually do. It is working fairly well, but I've ran in
There is a case where test is given to a certain student. The student can only work with the answer for the test before a given period. Here is the sample case:
I have two sheets that I want to link using a "primary key". At the moment, I have imported from sheet1 into sheet2 some columns using the function =Sheet1!A1
I want create a simple custom sum formula in google Spreadsheets using google app Script. function somaDias(range, days) { var sum = 0; for(i=0; i<d
I would like to know if there's a way to automatically trigger a script every time a specific sheet, inside a worksheet, is selected. Looking around I found the