Gang Of Coders
Home
About Us
Contact Us
All Google Sheets Solutions on Gang of Coders
Total of 65 Google Sheets Solutions
How to utilize date add function in Google spreadsheet?
Google Sheets
Formula
Google spreadsheet API, 400 error bad request : unable to parse range
Java
Google Sheets
Google Api-Client
Concatenate a range of cells with a comma
Google Sheets
Hidden field in a Google Form
Google Apps-Script
Google Sheets
Google Forms
Create a new sheet in a Google Sheets with Google Apps Script
Google Apps-Script
Google Sheets
Stacking multiple columns on to one?
Google Sheets
How to create custom keyboard shortcuts for google app script functions?
Google Apps-Script
Google Sheets
Keyboard Shortcuts
Suppress #N/A returned by Google Sheets vlookup
Google Sheets
How to highlight cell if value duplicate in same column for google spreadsheet?
Google Sheets
Gs Conditional-Formatting
Number of days between past date and current date in Google spreadsheet
Date
Google Sheets
Datediff
ArrayFormula and "AND" Formula in Google Sheets
Google Sheets
Array Formulas
Get Sheet By Name
Google Apps-Script
Google Sheets
On Google Spreadsheet how can you query 'GoogleFinance' for a past exchange rate?
Google Sheets
Google Docs
Currency Exchange-Rates
Count occurrences of given character per cell
Google Sheets
Count cells that contain any text
Google Sheets
Google Sheets-Formula
Get the last non-empty cell in a column in Google Sheets
Google Sheets
Worksheet Function
Google Sheets-Formula
Import data into Google Colaboratory
Google Sheets
Google Colaboratory
How to debug Google Apps Script (aka where does Logger.log log to?)
Debugging
Google Apps-Script
Google Sheets
Triggers
Google Sheets API returns "The caller does not have permission" when using server key
Google Api
Google Sheets
Google Sheets-Api
How can I do time/hours arithmetic in Google Spreadsheet?
Time
Google Sheets
Datetime Format
Date Arithmetic
How to get the correct range to set the value to a cell?
Google Apps-Script
Google Sheets
Get first item from Split()
Google Sheets
Google Docs
Apply formula to the entire column
Google Sheets
Array Formulas
Google Sheets-Formula
Count rows with not empty value
Google Sheets
Google Sheets-Formula
Google SpreadSheet Query: Can I remove column header?
Google Sheets
Formulas
Google Sheets-Query
Google Query-Language
Check cell for a specific letter or set of letters
Google Sheets
Displaying Lakhs and Crores in Google Sheets
Google Sheets
Refresh data retrieved by a custom function in Google Sheet
Google Apps-Script
Google Sheets
Custom Function
Convert column index into corresponding column letter
Javascript
Google Apps-Script
Indexing
Google Sheets
Conditional formatting based on another cell's value
Google Sheets
Google Sheets-Formula
Conditional Formatting
Selecting the last value of a column
Google Apps-Script
Google Sheets
Google Sheets-Formula
Array Formulas
Custom Function
Accessing Google Spreadsheets with C# using Google Data API
C#
Google Sheets
Google Api-Dotnet-Client
Google Data-Api
Google Sheets-Api
Download link for Google Spreadsheets CSV export - with Multiple Sheets
Google Sheets
Google Visualization
Google Sheets-Export-Url
How to union ranges in google spreadsheets
Arrays
Google Apps-Script
Google Sheets
Google Sheets-Formula
How do I avoid the "#DIV/0!" error in Google docs spreadsheet?
Google Sheets
Divide by-Zero
How to negate 'isblank' function
Google Sheets
count distinct values in spreadsheet
Count
Google Sheets
Distinct
Determining the last row in a single column
Google Apps-Script
Google Sheets
Convert Unix Epoch Time to Date in Google Sheets
Javascript
Datetime
Google Apps-Script
Google Sheets
Epoch
ISO-8601 String to Date in Google Sheets cell
Datetime
Google Sheets
Google Sheets-Formula
Iso8601
How can I copy a conditional formatting from one document to another?
Google Sheets
Gs Conditional-Formatting
Get value from the cell above
Reference
Google Sheets
Relative Path
Selecting Multiple Values from a Dropdown List in Google Spreadsheet
Google Sheets
Google Spreadsheet-Api
Google spreadsheet "=QUERY" join() equivalent function?
Sql
Google Sheets
Google Query-Language
Google Spreadsheet, Count IF contains a string
Google Sheets
Wildcard
Using A Cell To Reference The Name Of Sheet In A Formula For Google Sheets
Google Sheets
Is it possible to 'prefill' a google form using data from a google spreadsheet?
Google Apps-Script
Google Sheets
Google Forms
Is there a Google Sheets formula to put the name of the sheet into a cell?
Google Sheets
How do I access (read, write) Google Sheets spreadsheets with Python?
Python
Google Sheets
Google Api
Google Api-Python-Client
Google Sheets-Api
How do you add UI inside cells in a google spreadsheet using app script?
User Interface
Google Apps-Script
Google Sheets
How to address the current cell in conditional format custom formula?
Google Sheets
Gs Conditional-Formatting
Getting Google Spreadsheet CSV into A Pandas Dataframe
Python
Pandas
Google Sheets
Google Drive-Api
Google Apps
Count number of cells with any value (string or number) in a column in Google Docs Spreadsheet
Google Sheets
Google Docs
How do I add formulas to Google Sheets using Google Apps Script?
Google Apps-Script
Google Sheets
Google Docs
How to format a duration as HH:mm in the new Google sheets
Time
Google Sheets
Duration
Formulas
Iterate over range, append string to each
Google Apps-Script
Google Sheets
How to do I locate a Google SpreadSheet ID?
Java
Google Apps-Script
Google Sheets
QUERY syntax using cell reference
Google Sheets
Google Sheets-Query
Conditional Formatting from another sheet
Google Sheets
Gs Conditional-Formatting
Faster way to find the first empty row in a Google Sheet column
Performance
Google Apps-Script
Google Sheets
Hash of a cell text in Google Spreadsheet
Google Sheets
Google Search-Api
Google Spreadsheet Formula to Use Current Row in Function
Google Sheets
How to define global variable in Google Apps Script
Google Apps-Script
Google Sheets
Global Variables
Google Docs
Script to Change Row Color when a cell changes text
Google Apps-Script
Google Sheets
Gs Conditional-Formatting
Importing data into R from google spreadsheet
R
Google Sheets