All Questions

Filter by
Sorted by
Tagged with
3
votes
2answers
31k views

How do I control who can see my Friends List?

I don't want the entire world to see who I am friends with on Facebook. How do I control who can see my list of friends?
2
votes
5answers
11k views

How to make that a custom function update its result immediately

I'm using a custom function to read the sheet name (shown in the tab) and then return the name to the cell in the summary page. The script works, however it doesn't update when I change the name of ...
1
vote
1answer
3k views

How to create an auto updating Google spreadsheet with information from Steam?

How would I create an automatically updating Google spreadsheet containing information about Recently Played in Steam? Table must look like here: A2 taking information about account name from here: ...
0
votes
1answer
115 views

Google Apps Script Javascript compatibility error

I have successfully created some code to extract data from a 2D array using A1 notation. Handy to avoid multiple calls to GAS services whit ordinary getRange calls. While the code perfectly works in ...
0
votes
2answers
9k views

Google Sheets importxml() can't fetch from eoddata.com

I'm trying to fetch a piece of data using importxml() but it just fails with "Loading..." and never resolves. Other pages have no such problem at all, just this one and I don't know why. Here is the ...
114
votes
8answers
271k views

How to view the folder size in Google Drive?

In Google Drive, you can use Sort split-button and choose Quota Used to show the size of each file there. However, folder sizes are not shown. I guess it's really a basic requirement in order to ...
79
votes
31answers
314k views

How to send big files via email?

Gmail's maximum attachment size is 25 MB. How to send files bigger than that?
90
votes
5answers
149k views

How to use boolean AND and NOT operators in Gmail search

I'm trying to find mails that have one address in the recipients but another not in it. I'm trying things like from:address1@gmail.com and not from:address2@gmail.com and from:(address1@gmail.com and ...
66
votes
11answers
42k views

How to make a task repeat on the last day of each month in Google Calendar?

Pretty much the subject says it all. How can I make a task repeat on the end of each month in google calendar. Jan 31- repeated task Feb 28 - repeated task march 31 - repeated task april 30 - ...
88
votes
6answers
4k views

Is there any way to give more (or less) weight to words in a Google search?

Sometimes I may prefer results that have a certain term: resize image bookmarklet +chrome In this example, I want a bookmarklet to resize images. Preferably, I want one that works in chrome, ...
154
votes
2answers
336k views

How does one add a new line in a cell in a Google Spreadsheet?

I pressed return to make a new line in a cell of my Google Spreadsheet. That just moved the cursor to the next cell. How does one add a new line in a cell?
71
votes
11answers
145k views

Automatically open ICS files in Google Calendar

Lots of web sites have an option to export events as an ICS file that can then be imported into a desktop or web-based calendar (for example if you're invited to a Facebook event there will be an ...
38
votes
26answers
3k views

Online project management services [closed]

I need a user-friendly and cleverly designed web service to manage my projects and tasks. No matter if it's a free or paid service. Having a comment system and some game mechanics would be a big plus. ...
71
votes
10answers
62k views

Create a Gmail filter for Calendar Notifications

I'd like to create a Gmail filter to filter all of my Google Calendar notifications into a separate folder. Google Calendar notifications have headers that look like the following: Reply-To: Helen ...
57
votes
5answers
95k views

Sum values with same name

I have a Google Sheets with a long list of names and amounts. Many of the names are duplicates. For example: John | 10 Bill | 2 Susan | 3 Frank | 4 Sally | 10 John | 2 Susan | 2 John | 3 Is ...
46
votes
14answers
26k views

Is there a good equivalent to Mint.com for users outside the USA? [closed]

I'd love to use Mint.com but it's not available in the UK. Any idea when it might be available in the UK, or are there any recommended UK equivalents?
55
votes
6answers
29k views

How can I view Google Photos that are not in a Google Photos album?

Go to Google Photos Add a few photos to a photo album Go back to All Photos See all of the photos there, even ones you copied to the Album. No problem here, per se. At least not yet. What if you ...
33
votes
8answers
29k views

How to use Gmail's “Send Mail As” with another Gmail account through SMTP without “On Behalf Of”?

Related to this question, I want to remove the "On Behalf Of" when I send an email from another Gmail account via the web ui. So, as of now, my email is being shown as From emailA@gmail.com on behalf ...
27
votes
13answers
122k views

How can I get Google Sheets to auto-update a reference to another sheet?

I am using an external application to enter data into a Google Spreadsheet. This workbook is then referenced by a separate workbook (with the IMPORTRANGE(spreadsheet_key, range_string) function) that ...
30
votes
5answers
79k views

Gmail treats mails from my domain as spam. Why? How to avoid it?

Whenever I send a mail from myaccount@example.com to a Gmail account, Gmail treats it as spam. I'm talking about the one e-mail I send to a prospect after I've met him (it is surely non-spam mail). ...
20
votes
7answers
79k views

How do I mail merge from Google Spreadsheet to a Google Document?

With Microsoft Excel and Microsoft Word, it is easy to merge rows from a spreadsheet into pages in a Word file. This was traditionally used to make paper mailings. How can I do the same with Google ...
55
votes
3answers
32k views

How does Gmail decide to thread email messages?

Sometimes I'll notice false positives (includes an email that isn't part of the thread) and false negatives (misses an email that should have been part of the thread). How does Gmail decide which ...
57
votes
12answers
78k views

How to pass a range into a custom function in Google Spreadsheets?

I want to create a function which takes in a range... something like: function myFunction(range) { var firstColumn = range.getColumn(); // loop over the range } A cell would reference it using: ...
26
votes
8answers
92k views

How to link directly to a Google+ Hangout?

If I start a Google+ Hangout, is there anyway to send my friends a link directly to that Hangout post? I couldn't find any options. So I have to send people a link to my profile, and let them click ...
56
votes
4answers
34k views

How do I get Gmail to ask me to be a mailto handler again?

I noticed that when I open up Gmail on Google Chrome, a popup near the top asks me if I want to let Gmail be my "mailto:" handler. If I select "No," I'm assuming that Gmail will no longer ask me to ...
25
votes
7answers
36k views

Link to view PDF version of a Google Docs

I think there used to be a way to link to the PDF version of a Google Docs, but now I can only make a link that downloads the PDF instead of viewing it in the browser. Does anybody know if the old ...
18
votes
6answers
25k views

How do you find a Twitter RSS feed?

Given a Twitter username, where do you find the RSS feed for that user?
13
votes
2answers
57k views

Calculating shaded cells

I am using Google Spreadsheets to create a matrix (time/activity) as a daily schedule for staff to sign into. Is there a formula to calculate the number of cells in a column that are shaded (or not ...
21
votes
3answers
37k views

Concatenate several columns into one in Google Sheets

I want to concatenate/combine columns A, B and C into column D as displayed. The number of filled entries in A, B and C will vary over time, so absolute cell addresses cannot be used. What formula ...
19
votes
2answers
25k views

In Google Spreadsheet, finding what formulas reference a given value

I would like to find out which cells have formula dependencies in a large spreadsheet. I am looking for a way to do something like OpenOffice Tools>Detective>Trace dependents and Edit>Find &...
13
votes
4answers
15k views

Speed up YouTube Playback?

Is there a way to speed up YouTube playback?
35
votes
2answers
624k views

How do I delete all my mail from my Gmail account?

I want to clear my mail from my Gmail account, but don't feel like selecting every message (also the archived ones). Is there an easy way to delete all my mail from Gmail without having to delete my ...
21
votes
1answer
6k views

How to search something on across multiple sites with a single Google query?

I tried (search term site:stackoverflow.com) OR (search term site:superuser.com) OR (search term site:stackexchange.com) search term site:stackoverflow.com,superuser.com,stackexchange.com search term ...
13
votes
4answers
10k views

How do I delete attachments, in bulk, from messages in Gmail?

I'd like to free up some storage space and delete attachments from most/all the messages in my Gmail. I've long since downloaded and used any attachments I need or care to keep. How can I delete ...
11
votes
1answer
3k views

Can I translate Trello into other languages, specifically French?

Is there a way to translate Trello in other languages? I'm looking for French translation in particular. Or is it possible to do this translation myself?
10
votes
3answers
27k views

How to interpolate data in a range in Google Sheets

I have an array with data: X Y 3 50 5 60 9 120 11 130 18 90 20 150 The data is entirely non-linear. X is guaranteed to be sorted. Now for any given value,...
9
votes
8answers
11k views

Automated solution to delete certain Gmail messages older than n days

I need to delete certain Gmail messages older than n days (I can get the whole set though a search string). I know this is not possible directly within Gmail (see for instance this question) so I am ...
24
votes
2answers
84k views

Can I re-create deleted Gmail accounts?

A long time ago, I created a Google mail account. I fell for a trap that was common back then (not sure how it is nowadays) and ended up with two Google accounts—one for Gmail (using the Gmail email ...
24
votes
4answers
408k views

Is there a way to create a Yahoo! account without having a cell phone that can receive SMS messages?

I'd like to create a Yahoo! account. The signup page won't let me proceed without entering a cell phone number, and it won't recognize my Google Voice number as a valid cell phone number. Is there a ...
18
votes
4answers
3k views

Are there any good webapps that will convert an RSS feed to email? [closed]

I find that some RSS feeds are more useful if they were sent to me as email messages instead. Are there any good services that will monitor an RSS feed and send the new posts as email messages?
15
votes
3answers
9k views

How to filter by messages, not by conversation?

I have been emailing my Gmail account error messages from a project I am working on. I am trying to use Gmail filters/labels to sort out the class of errors. But because the subject line is ...
11
votes
1answer
70k views

Is there a way to find comments you made on YouTube? [duplicate]

I made a comment on YouTube and want to see if someone replied to it.
9
votes
4answers
28k views

How can I log out of Facebook chat?

About a week ago, Facebook was "upgraded" - don't know if it's a world wide issue - and the Facebook chat is always online. No matter I sign out. How can I disable / completely sign out of Facebook ...
6
votes
2answers
23k views

How do I implement a script that creates a unique ID for a Google form submission?

I need to create a unique ID upon submission of a form which will be used as a project number for tracking. The number needs to be unique but not based on rows or other changeable data because ...
32
votes
2answers
12k views

Show availability/busy status across multiple Google calendars

I'm currently connected to three Google calendars. One is my office calendar where I keep track of my work plans when I am focusing on certain projects and whatnot. Another is where I keep my ...
13
votes
2answers
45k views

Importing only certain rows between spreadsheet documents

Document 1 has many rows of data. How do I import into document 2 only those rows that have a certain value in column C?
5
votes
2answers
10k views

Show all combinations for a selection of columns

I have a sequence of letters, in Google Spreadsheets: | A B C D E F --|---------------------- 1 | U Y 0 4 X N 2 | H X Y 3 | W The first row contains a character ...
3
votes
2answers
2k views

Trying to use Google Sheets importHTML() to import a table. It forces content to a date format

I am trying to get a table into a sheet. The table contains data that looks like this: 4-0-2 This is wins-losses-ties. It comes in as a date. This is the command I use: IMPORTHTML("http://www....
14
votes
3answers
7k views

How do I change or update the email address used in Trello?

Where do you go in Trello to update or change your email address? The Account section only shows you this part in the avatar section: We're using eightballs@example.com. It may take time for ...
14
votes
1answer
13k views

Editing Subject in new Gmail

For Change subject line in new Gmail compose window, the answer given on 7 Feb about how to edit the subject line in the new format of Gmail does not work for me. There is no box on the left with a ...

15 30 50 per page
1 2 3
4
5
59