Hot answers tagged

5

Is it at all possible to use column headers like this? Yes, it is possible. First, you need to use MATCH to get the column number of the column whose value matches 'Name'. Then you need to use ADDRESS to get the cell reference. Finally, you need to use SUBSTITUTE to remove the row number from the cell reference. =QUERY(Sheet1!A1:C,"SELECT A, B, C where ...


4

Without asking Google, there's really no way to know for sure. However, aside from the user agent, they could be looking for certain commonly used HTTP headers that are routinely sent by web browsers but normally omitted in curl requests. This may include, but not be limited to: cookies - saved cookies, which may include session or login credentials ...


2

The message is pretty clear: you are invoking the service too often. This is discussed in Google URL Shortener 403 Rate Limit Exceeded which indicates that the acceptable rate is somewhere between 1 and 10 requests per second. Use the method Utilities.sleep to slow down the requests. For example, Utilities.sleep(1000) within the loop will ensure a 1-second ...


2

Google Docs help gives good instruction on how to make Conditional formatting, for your case Custom formula is: =$k2<today()-7


2

A Google spreadsheet URL looks like the following https://docs.google.com/spreadsheets/d/1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-Y/edit Just replace 1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-Y by your own spreadsheet-key. An alternative is to use https://drive.google.com/open?id=1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-Y The same apply, just ...


1

Google Spreadsheets and the other Google Docs editors doesn't allow to upload fonts. Try choosing one of the available fonts offered by Google. For further details on how to change the font, see Change the font in your file


1

No. For security reasons Google will always show the people a sheet is shared with. Your only other alternative would be to set it to public, but that would negate the option of "Specific people can access".


1

This requires a script, using DriveApp service to access files by name. The following function fetches the spreadsheet key of the spreadsheet with today's date (in format 2016-04-29) as the name, and places it in cell A1. (You may want to change the cell, and the timezone which is GMT in the script). Set the script to run daily, using Resources > This ...


1

onEdit can be written to take an event parameter that among other things contains the range that was edited. Changing the function declaration to take a parameter 'event' and changing r to be event.range instead of the activecell gets the exact behavior I believe you want. function onEdit(event) { var s = SpreadsheetApp.getActiveSheet(); if( ...



Only top voted, non community-wiki answers of a minimum length are eligible