All Questions

Filter by
Sorted by
Tagged with
1
vote
1answer
3k views

Trying to send email from Google Sheets with image attachment

I'm trying to send an email from within Google Sheets and then format it via some joins to send to an address for my Blogger account. I need to attach the image file apparently as the image isn't ...
1
vote
2answers
99 views

Google spreadsheet: reformat event data (several dates on one row/event) to create a .csv file (one date per row/event)

I currently have a list of several recurrent events, with dates of recurrence on the same row. I hope to create a .csv file for importing into calendars, so would like to have each recurrent date on a ...
1
vote
4answers
445 views

Google storage is out of space

I deleted all my photos from Google+ Photo, but it still don't show space is free. I also deleted all from my recycle bin in Google Drive, GMail and Photos recycle. How can I to fix this issue? May ...
1
vote
1answer
310 views

How to get most frequent terms from a set of lists?

I have a list on Google Spreadsheets. Each line is a mission, and one of the columns indicates who I've worked together on the mission (which is between 1 and 3 people). The format is "Aquaman, Batman,...
1
vote
3answers
130 views

Google Sheets issue with literal constants in functions [duplicate]

When attempting to use any literal strings in formulas I get a Formula parse error and #ERROR! in the column with the formula. For example: =IF(D43=“x”,MULTIPLY(E42,2)). I’ve been told that ...
1
vote
1answer
1k views

Is there any way to identify a user in Google Apps Script?

I have a spreadsheet in Google Sheets that is shared with five people. Only a few columns are edited; all of the other columns are locked. We need the ability to track changes to these editable ...
1
vote
1answer
428 views

How to use user-defined functions for custom formatting?

I’m writing a simple Google spreadsheet to list every account number which could come in handy to our non-profit in the future. Of course, one can expect some typo will get in some point in the future....
1
vote
1answer
605 views

Why is OkCupid showing me matches who live more than 5 kilometers away?

I'm using OkCupid, an online-dating and friend-matching site. I have set the site to show only matches within 5 kilometers of me. Unfortunately, the site seems to be showing me lots of matches who ...
1
vote
1answer
2k views

Google Keep won't load properly in Firefox

Google Keep will not function for me anymore in Firefox. When I go to http://keep.google.com, as soon as the page finishes loading I get a little dialog that says You've been signed out. Please ...
1
vote
2answers
1k views

Using an email address with two different names in Gmail? (as two aliases) [duplicate]

I've setup Gmail to use my own email address, like info@mycompany.com. When using this address as from-address, sometimes I want it to prefix with my personal name, and sometimes my company name. I ...
1
vote
1answer
5k views

Mail merge from Google Sheets to a Google Docs [duplicate]

I want to print out tests for a class I teach, but I want each to be identical except for the name of the student at the top. I want this to be drawn from a Google spreadsheet that I've created that ...
1
vote
2answers
3k views

What does “X people talking about this mean”?

If you use Facebook, you can see on a page's wall, it is written for example: 272 likes. 8 people talking about this The number of likes is understandable, but what does "8 people talking about ...
1
vote
1answer
100 views

How do I scroll horizontally by more than one column at a time?

I have made a weekly planner: on the left is a frozen column with a list of times and then four-column blocks to represent each day. The first of every four columns has a date at the top. I would ...
1
vote
1answer
3k views

FB private messages from email

Given that I know user's email address (full name, address and some more info) and I know that this user used his email to register on FB. Is it possible to send private message to the user in ...
1
vote
1answer
311 views

How to color an adjacent cell based on a 6-digit hex number without adding the “#”

I've looked at a few things (this link, WA's Colorize a cell in Google Spreadsheets based on cell data, and this link), but haven't been able to quite get the behaviour I want in Google Sheets. What I ...
1
vote
1answer
36 views

Identifying Defunct YouTube links

Suppose we have stored a YouTube link in our favorites or folder, without anything to identify what the link might have been, as the link at YouTube has now removed/unavailable after some unknown ...
1
vote
3answers
2k views

Is it possible that I could see the mobile number of Facebook friends [duplicate]

Is it possible that I could see the mobile number of Facebook friends? I saw the following post, but I did not find it because Facebook has changed. How do I get the phone numbers of my Facebook ...
1
vote
1answer
1k views

Embed Creative Commons attribution on YouTube

I have a video on YouTube which includes music from Free Music Archive. The track I use allows commercial use and remixing/adapting, but needs to have attribution. According to the official Creative ...
1
vote
2answers
875 views

Convert all links to images in a Google Document with actual images

I've got a few Google Docs that contain some paragraphs of text and multiple Drive links in the following format: https://drive.google.com/open?id=XXXX How can I use a script to replace all the ...
1
vote
1answer
596 views

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

How would I create an automatically updating Google spreadsheet containing information about Recent Activity in Steam? Table must look like here: But the hours column must automatically updating ...
1
vote
1answer
1k views

Stop lines in GDocs chart overlapping/obscuring other lines

How can I stop lines in GDocs chart overlapping/obscuring other lines? See for example the green line in the graph below, which starts up high, butthen goes behind other lines such as the yellow one.
1
vote
1answer
196 views

How can I share posts from GoogleReader to Google+ [duplicate]

Possible Duplicate: Send to Google Plus from Reader How can I add Google+ to the custom "Share" items in GoogleReader? According to this question and lack of resolution, it is not possible? ...
1
vote
1answer
64 views

Summarize the best options in another table

I need help to create a sheet for a game. I am providing the INPUT, and I would like to create the OUTPUT in another tab (do not consider the colors, its just for ease of understanding): Mainly, the ...
1
vote
2answers
71k views

How can I disable comments and likes on my profile picture on Facebook

I want people to be able to see my profile picture without feeling the need to like it and comment about it.
1
vote
2answers
829 views

Why are some Gmail accounts listed as “googlemail.com”?

I use a number of Gmail accounts for different purposes (eg. family, games-related, etc). All except one is listed as gmail.com but one is listed as googlemail.com. Have tried removing and re-adding ...
1
vote
1answer
1k views

Iterative sums in google sheets

Continuation of my previous question. I would like to calculate an average item cost for a trading log, using only the most recent number of items equal to the number in stock. Currently, I'm only ...
1
vote
1answer
489 views

Return cell reference containing closest value

I'm trying to get a spreadsheet to tell me which cell(s) contain values closest to a value I provide. Without going into too much detail it's for a golf game I play, and I've done some data collection ...
1
vote
1answer
1k views

Select the 'earliest n' or 'latest n' entries of a subset in google spreadsheets

I'm trying to make a trading log for Eve Online and I need to keep track of average sale prices for arbitrary items. I do a sum of FILTER results to find the total cost of all of a particular item ...
1
vote
0answers
136 views

Importing online docs into SkyDrive

I hate to download-upload. It is stupid. The acceptable approach is the one we have to insert images into SE posts: there is an option to choose between "from my computer" and URL. Now, I want to know ...
1
vote
0answers
464 views

Migrating Facebook app from a personal account to a corporate account [duplicate]

I have an app on Facebook that is currently associated with my personal account. I want to move this app over to some sort of "entity"/corporate account. To better explain the situation: I'm working ...
1
vote
1answer
64 views

FILTER() Is not returning consistent results

I'm having some issues with FILTER() not returning consistent results, below is an image detailing the inconsistencies. When filtering for 3:30 PM I only get 2 results instead of 3. When filtering ...
1
vote
1answer
5k views

How do I filter the array returned by a filter or other formula?

I want to filter an array returned by a filter to remove blank columns. Here is a picture of an example sheet: Here is the example sheet. I am filtering the large table by the rows that are of type ...
1
vote
1answer
316 views

Can I avoid using Gmail's category tabs and revert to the old interface?

Is it possible for me to return to the old Gmail screen without the categories tabs? Would my only option be to move to another email provider? I cannot understand most of the computer "language", ...
1
vote
1answer
459 views

Create incrementing number field in Cognito Form

Is there a way to have forms create an ongoing numbering field. I want to have my forms numbered automatically when they are filled in by a user. Any ideas?
1
vote
1answer
2k views

Why is Facebook complaining about my company email address?

When I try to add an email address to Facebook, it says 'invalid'. But it's not! minus http://i.minus.com/ibd3lFKGnq5s4x.png
1
vote
1answer
3k views

How to pass multidimensional array to a custom function in Spreadsheets

I want to pass a multidimensional array to a custom function. I do it like this: =customFunction({{"a1v1"; "a1v2"};{"a2v1"; "a2v2"; "a2v3"};{"a3v1"}}) However, I don't get the expected behavior ...
1
vote
3answers
586 views

Find the closest value within a range of cells and output cell reference

There are values from F column to AJ column in row 30. My input would be available in C column in row 30. As given in the picture, my input would be 118.45, I would like to find the closest value to ...
1
vote
1answer
101 views

Is it possible to use the contents of a cell in a custom conditional formatting rule in Google Sheets?

For example, given the sheet below: I'd like the background colours of columns B-D to change automatically when I update the values in column A Is that possible? I'm looking for a solution that will ...
1
vote
0answers
175 views

How to move emails between Gmail accounts?

I have a couple of Gmail accounts (one personal Gmail and a couple of work Google Apps accounts) and sometimes, I mistakenly send an email and start a conversation from the wrong account. What is the ...
1
vote
1answer
201 views

Remove old emails from Gmail matching criteria automatically

I want to delete the following emails: from:(reply@abc.com) subject:(for sale) older_than:1d It seems in the old Gmail interface it was possible to create filters to delete these messages. I am ...
1
vote
3answers
14k views

How can I re-add a friends posts to my newsfeed?

A while ago I removed one of my friend's posts from my Facebook news feed. I'd like to add them back to the feed, but can't find any way of doing this. I suppose I could un-friend & re-friend them ...
1
vote
1answer
950 views

Sharing Google Spreadsheets Privately

If I share an interactive Google Spreadsheet using File > Publish to the web... does this spreadsheet include any personal information from my Google Account (eg. Full Name?) If it does (somewhere ...
1
vote
1answer
39 views

Problem inserting a column and cell reference/link

I have a sort of summary in my Google sheet. In the second column, I refer to the sub tables further in the sheet with e.g. this content: https://docs.google.com/spreadsheets/d/1J- ...
1
vote
1answer
558 views

How do I close my AdSense account?

I need to close my AdSense account to change my status from individual to business. As per this AdSense help article, the instructions are: "In the “Account information” section, click cancel ...
1
vote
1answer
233 views

Organizing and filtering Twitter data [closed]

I follow a lot of people on Twitter, normally I use the web interface. I used to follow a lot more, but a few months ago, I organized my follows into lists. I ran into two problems, I ran out of ...
1
vote
1answer
2k views

Whitelist email address for a Google Group

We are a free and open source software project. We set-up a Google Group for build results from services like Travis, AppVeyor, CodeFresh and Coverity. The list does not allow Public to post since we ...
1
vote
1answer
641 views

Can the ip of the submitter be recorded in form data in Cognito Forms?

Need to record the ip on signature forms for added legality. Is this possible?
1
vote
1answer
262 views

Conditional formatting based on comparison with today's date and also with a future date

I'd like to conditionally format cells that will go red if it's past its expiration, go yellow if it's within 3 months of expiring, to remain green if date is clear of expiry. For example: today's ...
1
vote
0answers
2k views

In TweetDeck, is it possible to disable retweets in a list?

I've set up a Twitter List and when viewing the list directly on twitter.com, list member retweets are not shown. This is my expectation for a list. However, when using Tweetdeck (either web....
1
vote
1answer
2k views

How do I select unread messages in Gmail without having to click on the arrow next to the checkbox and then click unread?

A lot of the time the unread messages in my Inbox just need to be archived and I'd rather have a 'quick' way to do it that doesn't require hitting that small arrow next to the master checkbox and then ...

15 30 50 per page