All Questions

Filter by
Sorted by
Tagged with
23
votes
11answers
100k 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 ...
20
votes
7answers
78k 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 ...
53
votes
3answers
29k views

Is there a way to use Trello offline?

Sometimes I work on a bus or in places, where I can't use internet. Is there a way to use Trello offline?
55
votes
12answers
68k 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: ...
25
votes
8answers
84k 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 ...
22
votes
5answers
47k views

Is it possible to setup a filter in Gmail to delete message older than one month? [duplicate]

Possible Duplicate: Webapp to delete certain Gmail messages older than n days? The reason I need that is because I need to subscribe to some open source project mail list and I don't need to ...
57
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 ...
27
votes
2answers
68k views

How to receive email notification of new Facebook messages?

I would like to receive an email when someone sends me a message on Facebook. This used to happen by default. Is it still possible to set it up somehow? Update (Dec/12): Mehper C. Palavuzlar's ...
18
votes
6answers
24k views

How do you find a Twitter RSS feed?

Given a Twitter username, where do you find the RSS feed for that user?
36
votes
11answers
50k views

How to calculate weighted averages in Google Sheets?

I have a Google Sheets where products are listed as rows and attributes as columns. Each product's attribute is rated on a scale of 1-10. My last column is an average of these values (i.e. =Average(B2:...
24
votes
7answers
31k 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 ...
12
votes
2answers
55k 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 ...
16
votes
1answer
5k views

How do I work around labels being applied to individual messages and not conversations in Gmail?

There are numerous reports of issues with Gmail labels, stars, unreads, message counts, and generally searching or counting combinations of these. Many of these seem to come from a common cause. I ...
13
votes
4answers
13k views

Speed up YouTube Playback?

Is there a way to speed up YouTube playback?
9
votes
1answer
28k views

Can I protect the formatting of a Google Sheets?

I’ve got a Google Sheets that has lots of formatting and formulas, in various columns, some columns are formula driven, and some columns that are user input driven. The spreadsheet is shared with ...
2
votes
2answers
1k views

Prevent Gmail right-click from opening a New Message panel

If an email message contains an email address in the body, Gmail automatically converts it into a mailto: link, which is helpful. And many times each day I've enjoyed being able to right-click a ...
35
votes
2answers
611k 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
9k 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
3answers
9k views

Is there a way to avoid “+canned.response” in the email address using Gmail's canned response feature

If I set up a filter and send it a canned response, Gmail appends +canned.response to my username in the reply. For example, given the filter "from:foo@example.com to:me@example.com" set up to send a ...
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?
24
votes
2answers
79k 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
394k 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
8k 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 ...
12
votes
4answers
24k views

Lock the formula of a cell, even if the cells it references change

I have this, in D1: =sum(D3:D) I want D1 to always be the sum of the rest of column D (D2 is a header) I sometimes move a row, from eg 8 to 3, and that causes D1 to change to sum(d4:d). I want ...
10
votes
3answers
22k 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
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 ...
5
votes
2answers
19k 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 ...
4
votes
3answers
5k views

Forms Data Manipulation In Google Sheets

I'm trying to develop a solution using Google Forms with Google Sheets that will collect Google Forms data and then automatically divide that one form submission's data into multiple rows of data in ...
12
votes
2answers
41k 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?
11
votes
3answers
32k views

In Google Spreadshets, how can you loop through all available sheets not knowing the total count?

I'm keeping stats for my daughter's baseball team. I have a sheet for each game, each one identical in structure. I want to create a summary sheet that totals numbers from the other sheets. How ...
10
votes
1answer
65k views

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

I made a comment on YouTube and want to see if someone replied to it.
9
votes
1answer
89k views

How to make subquestions in Google Forms?

I want to make form with different length dependent on some previous responses. For example: Q1: Do you like cats? Yes/No Q2 (Q1=Yes): Which kind of cat do you like most? Q2 (Q1=No): Why do you ...
8
votes
3answers
681k views

How can I delete Facebook messages sent to other users?

How can I delete Facebook messages I've sent to other Facebook users from their inbox? I have had a conversation with my friend but now I want to delete my messages from that conversation. Can I have ...
6
votes
2answers
33k views

Get share link of multiple files in Google Drive to put in spreadsheet

I've got 200+ jpegs in a folder and need shareable links for each jpeg in a spreadsheet. Is there a way to do this without doing the right clicking thing for each image individually?
5
votes
2answers
8k 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 ...
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 ...
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 ...
13
votes
2answers
35k views

How can I create custom keyboard shortcuts in Google Docs?

When studying biology and mechanisms, it's very useful to take notes with arrows that illustrate a stepwise process: A --> B --> C and up/down arrows to denote increase/decrease. This is very ...
12
votes
7answers
33k views

How to stop NOW function from auto-updating?

I'm using Google Spreadsheet's NOW() function as a shortcut to insert the current timestamp now. However, the value in the cell changes whenever the spreadsheet is modified in any way, even when the ...
9
votes
3answers
1k views

In Gmail, how can I have customized signatures based on the From: address?

In Gmail, I have a number of accounts that I can choose to send from. (Old e-mail address, one used just for gaming, one for my blog, etc.) How can I have a unique signature for each depending on ...
9
votes
3answers
2k views

Forced words in Google search query are being ignored, plus no longer working as explicit inclusion

How do I force including a word in Google search if the plus (+) operator doesn't work anymore? Here's an example search. +("os x" OR "osx") +temperature +(console OR "command line") I expected ...
8
votes
2answers
34k views

I need to hide/show a group of columns in Google Sheets in a simple way

I need to hide and show in a easy way a group of columns in Google Sheets. In Excel I used a Macro with a button, but in Sheets I cannot put a button. How can I add buttons with custom functions in ...
7
votes
3answers
14k views

Colorize a cell in Google Sheets based on cell data

I'd like to colorize a cell based on its contents. 0 = red, 100 = green, and linearly interpolated between. function LinInt(x){ var ss = SpreadsheetApp.getActiveSheet(); var cell = ss....
17
votes
3answers
8k views

Gmail filters/labels: Force email to stay in Inbox?

I receive email to these addresses: my-team@example.com : This is my team's primary method of communication. I want all of this email to go to my Inbox. other-team@example.com : This belongs to ...
17
votes
1answer
5k views

Can I archive only certain messages within a conversation?

I have a long conversation with many recipients (I'm organising an event), in amongst the replies I have 3 or 4 mail delivery failed messages, which I'd like to Archive (so that they're not messing up ...
16
votes
3answers
13k views

how can I mark an email message as “not spam” in Google Inbox?

There is a newsletter I receive that Gmail insists should go into the spam folder. How can I mark it as not spam and move it to the inbox? I know how to do it in Gmail, but not in Inbox. How can ...
11
votes
6answers
43k views

Deleting a channel on slack.com

I created two channels on my Slack team with a typo. I want to delete them but it seems there is no way?

15 30 50 per page
1 2 3
4
5
54