David Metcalfe
  • Member for 10 years, 7 months
  • Last seen more than a month ago
Toggle named range window with a button?
2 votes

Per @Rubén's comment, it doesn't appear possible to call up interface items in the way you describe. However, you can make use of the native keyboard shortcuts. To get to Named Ranges on a PC: In ...

View answer
Is there a way to use Trello offline?
Accepted answer
2 votes

As of January 27 2017, the Trello app for iOS and Android now works offline natively. Different locales are seeing this roll out in a staggered manner but it should be available to you soon if it ...

View answer
Can I get my Google calendar info into a shareable/printable format?
2 votes

Depending on your OS choice, Google calendar in apps like Mac OS X's iCal allow for greater detail when printing.

View answer
Compose and send HTML emails with Google Gmail?
2 votes

From a client, it's no problem...from the Gmail website, I only know of people having luck with copy/paste of HTML and typically having to embed it inside a signature.

View answer
Blinking cell in Google Sheets depending on cell content
1 votes

This will get you up and running, but you'll probably want to either reduce the loop time or insert a check for if/when the cell is changed to something other than "Red", otherwise it'll just keep ...

View answer
How can I change Google Sheets ownership in bulk?
1 votes

As Ruben already outlined, the quickest solution should be bulk share and changing ownership of the files. Share the spreadsheets in bulk to this new account of yours. Modify the owner of these ...

View answer
Sorting on a web-published Google Spreadsheet
1 votes

To date, this is still not possible with Google Spreadsheets.

View answer
Automatically add rows based on condition of existing rows
1 votes

Something like this perhaps? function conditionalNewRow() { var ss = SpreadsheetApp.getActive(); var sh = ss.getActiveSheet(); var headerRow = 1; var firstRow = headerRow + 1; var range = ...

View answer
Script for GoogleSheets that inserts date, time, and user names of everyone entering text in a specified cell?
0 votes

I suppose the easiest would be appending a newline and the text. function myFunction() { var worksheet = SpreadsheetApp.getActiveSheet(); var placeholder = worksheet.getRange(1,1).getValue(); ...

View answer
How to change Google Sheets hyperlinks into HTML "a href" links?
0 votes

It's fairly rudimentary, but a Google Apps Script solution could be as follows: function createHref(url, title){ /* Create the URL and return it. */ return '<a href=' + url + '>' + title + '&...

View answer
Upgrade existing Google spreadsheet to New Google Sheet
0 votes

I spoke to Eric Koleda about this, and his response was as follows: "There aren't any more old Google Sheets left, they've all been upgraded to new Google Sheets by now." So it appears the old ...

View answer