Pages

▼
Friday, July 26, 2019

Google Sheets - Data Validation (Dynamic Dropdown) - using Google Apps Script

›
In Google Sheets, if you want to have the dynamic dropdown, that is data validation based on the some other (adjacent) cell, then it is poss...
5 comments:
Monday, June 3, 2019

Google Apps Script to delete all the filter views in a spreadsheet

›
If you have created lots of filter views in a Google Spreadsheet and find it hard to delete all of them one by one manually then you can use...
30 comments:
Friday, September 15, 2017

Convert ##m ##s formatted text to a number in seconds

›
Question: Hello! I'm hoping to find some way to convert this data into numbers so I can use those numbers for other formulas. I have c...
Saturday, August 5, 2017

Google Sheet Script to Navigate various HTML Pages

›
Here is the Google Sheet Script to Navigate various HTML Pages by passing the needed data via URL parameter. Screencast: F...
Monday, July 3, 2017

Google Sheet Script for border style

›
Question: I have columns and rows: D69:J79 filled with data, data in rows is changing on daily basis, one day it’s D69:J79, another it’s ...
Saturday, July 1, 2017

Google Sheet Script to extract URL from a Cell containing function HYPERLINK

›
In Google Sheet, if you have a cell or a range containing functions HYPERLINK and if you want to extract URL(s) from it then you can do it w...
Monday, February 20, 2017

Google Script to auto delete old files from a Google Drive Folder

›
If you are creating auto backup of any file in Google Drive using script ( either daily or on any edits ), so the number of back up file kee...
4 comments: