1
vote
1answer
40 views

How to retrieve email address of current user?

In Google Spreadsheet I am having the following issue: I am using Session.getActiveUser().getUserLoginId() to fetch the current user's email id but other than creator of the spreadsheet it is ...
0
votes
0answers
289 views

Problems unlocking Google account due to incorrect phone number

I created a new Gmail account. When I tried to log in for the first time, it gave a message saying "Enter verification code sent to your mobile number". I then saw that I entered my cell number ...
0
votes
0answers
18 views

How to create regular automated backup of git database

I need to do regular automated backups of my git database in a secured AWS S3 bucket. Currently git is running in aws instance. GIT is installed from omnibus package.
2
votes
0answers
28 views

Disable Gmail “muting” feature to prevent accidental muting

Is there a way to disable muting in Gmail altogether? I recently muted a conversation by accident and thus didn't see replies to it, so I went back and found others via ...
3
votes
1answer
47 views

Adding a Month to a Date in a Google Spreadsheet with a Script

I'm trying to create a Google App Script that adds one month to a date already on a Google Spreadsheet. In the example below I was trying to take the date from cell B2 (1/1/16) and add one month and ...
2
votes
2answers
36 views

How to get definitions of Twitter's hashtags

When I look at the current Twitter trends for the United States, I find tags like: #SEAvsMIN #SundayFunday #IShouldNotBeAllowed #MakeAShowChildish When investigating further, one can find out, ...
2
votes
1answer
35 views

How to automatically wrap text to new responses from form?

I had a working Google Spreadsheet where when new responses were filled in on the form, they would automatically get textwrapped on the Form Responses sheet. Now recently I had to remake this ...
1
vote
1answer
55 views

How to remove hidden Google contacts

How can I remove people from the seemingly hidden contacts list Google keeps for me? For instance Google Play keeps showing me suggestions and reviews of apps from a person who is not in my contacts ...
0
votes
0answers
26 views

Permanently delete a Google Business Account

Let's say I have a business account attached to my main Google account. I know how to remove it, but the confirmation page made me really unconfident about the process. Basically, I need to know if ...
3
votes
1answer
37 views

Use a Google Form to update an existing Google Sheet

Is there a way to update an existing sheet in a Google spreadsheet using a Google form? I only see how to update to a new tab (sheet) on an existing spreadsheet.
0
votes
1answer
61 views

INDEX-formula throws random #REF!-errors due to [illogical] column value out of range

I have built a spreadsheet to help me keep track of my spending during my holidays. Whichever currency I buy in, it converts the raw amount into my local currency (Malaysian Ringgit MYR). Here is how ...
3
votes
2answers
62 views

How to display my timeline of only a particular month in the past?

I want to check everything I posted a particular month many years ago. I could scroll down all the way, but scrolling all these years takes forever and makes my browser really slow. How to show my ...
1
vote
0answers
18 views

Problem rendering MathJax with Weebly

Like many mathematics grad students, I have a professional website, which I built using Weebly because of its relative ease of use. In order to display mathematics nicely, I've been using MathJax ...
0
votes
0answers
33 views

Importrange() Error: “Results Too Large”, how to work around?

I'm trying to Importrange() from a range containing 240,000 cells (40 columns, 6000 rows). The Importrange() function is erroring out with "results too large". What are the limitations of ...
-6
votes
0answers
28 views

How do I retrieve my old email and password that is connected to my user name [duplicate]

I need a little help I can remember my user name in my Google Game center. But I do not remember which email I used. I probably do not remember the password to the email
-1
votes
2answers
56 views

Mutual friend in Facebook doesn't have the “add friend” option [closed]

I have a mutual friend and I want to send a friends request to him but his account doesn't have an “add friend” button. How this is possible?
4
votes
3answers
59 views

Split a column of strings with a single formula returning an array

I have a column of strings like this: +---------+ | a bb | | ccc d | | ee ffff | +---------+ (exactly one space in each string), which I'd like to split by the space into two columns: ...
1
vote
2answers
39 views

Function name to add rows in Google Sheets

Is it possible to add rows with a built-in function (such as MIN() or INDIRECT()) in Google Sheets? I would like to fill rows in the main sheet such as +---+----+--------+ | A | 18 | Atext1 | | A | ...
3
votes
1answer
24 views

How to turn a list of months string into a list of month numbers?

I have a table with month headers at the top: January | February | March | ... Is there a way with one formula that I can get a list of month numbers? January | February | March | ... ...
0
votes
0answers
7 views

How to delete a Windows Live account without the password

I used to use Windows 8, and then I switched to Ubuntu. However, I now need a Microsoft account again, and I don't know the password because the last time I used it was over a year ago. I've tried ...
2
votes
1answer
37 views

Insert current date to cell based on content in other cell

Background: I am trying to create a sheet which tracks my costs on daily basis. Instead of entering the current date everyday, I want the sheet to store the current day based on the content I enter ...
2
votes
1answer
15 views

What is the difference between the DELTA and EQ functions?

The new Google Sheets includes the DELTA function, which Compare[s] two numeric values, returning 1 if they're equal. How does this differ from the EQ? From what I can tell, the EQ function ...
3
votes
2answers
40 views

Sum a column if another column contains any of the values

I have the following data in a google spread sheet. ColumnA ColumnB ======================= Bus 205 Train 10 Train 10 Fruit 10 I want to sum all ...
1
vote
0answers
25 views

Facebook website widget to display images with most likes, most shared, etc? [closed]

Is there a code that will display a horizontal or vertical (whatever you choose) widget on your website on the most XX liked/shared/commented/etc images on a particular Facebook page?
1
vote
1answer
160 views

Gmail logout/login error

I am trying to log into my own Gmail account. However, I cannot logout of my daughter's account. Every time I put my own email address in it returns "wrong address". How do I log in as a different ...
1
vote
0answers
8 views

How to save a Project Gutenberg book to Pocket?

When I try to save http://www.gutenberg.org/files/7524/7524-h/7524-h.htm to Pocket using the Firefox extension or Android share feature, what ends up in my Pocket is the landing page, ...
2
votes
1answer
11 views

No applicable aggregate method “Sum” exists at character 22 in Cognito Forms

I have a form that will be used to collect info on conferences attended (one repeating box), and lectures attended (a repeating box within the first repeating box). I have calculated the number of ...
0
votes
2answers
19 views

How to sort spreadsheet by date+time column but with a modified hour column?

I have a spreadsheet generated by a google webform and it produces a standard spreadsheet with a full timestamp column that is two hours behind and a hour column (hh:mm am/pm) that the user fills in ...
1
vote
1answer
13 views

Drag and drop open csv in Google Sheets

The current process for opening a csv file in Google Sheets is cumbersome. Open Google Sheets > New Document > File > Import > Upload Tab > Drag in File > Select 'Replace current sheet' Would love ...
2
votes
0answers
19 views

How can I get an alert when a specific post appears in Facebook?

When The Hungarian Opera House has a new promo, a post appears on its page https://www.facebook.com/Operahaz/?ref=ts&fref=ts and the first 10-50 people who click and answer a simple question get ...
1
vote
1answer
15 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?
2
votes
0answers
13 views

Is there a way to get Google Search to give you definitions for words in languages other than English?

If I google perspicacious, Google Search correctly infers that I want a definition and just includes it at the top of the results. For more common words, like vanish, I would have to write define ...
2
votes
1answer
24 views

Google Spreadsheets: Sum values for each month

I would like to sum the values that match each month in a spreadsheet. The spreadsheet looks like this: 2015-12-10 15 2015-12-19 10 2016-01-02 15 2016-01-05 25 And I want to obtain this: ...
5
votes
0answers
42 views

How to post photo with website clickthrough on Facebook?

Is it possible to post a photo on Facebook that links to a website? Can this only be done with Facebook ads?
-2
votes
0answers
11 views

how can i send an email to all of my contacts at once? [duplicate]

How can I send an email to all my contacts at once? I have been working all day to make once group and add all of my contacts to one group and I do not know how. I tried to send an email to all of ...
2
votes
0answers
22 views

How to mark as done but keep resnooze until particular date in Inbox by Gmail?

Steps to reproduce the above example screenshot: Snooze a conversation This will make the conversation disappear from your inbox Let us assume the other person responds to this conversation while ...
1
vote
0answers
17 views

How to remove large quantities of fake Instagram followers?

My friend has a bunch of fake followers and he wants them gone. There are about 1000. They follow about 50 people but have 0 followers. Is there a way to report them all to Instagram to have the ...
1
vote
2answers
14 views

Set a formula for all cells in a column

I would like to use a same formula for cells in a column. Instead of writing it for all cells, is there a way to set it in a cell and tell to apply this formula to all cells in a column (or any set of ...
3
votes
1answer
30 views

How to change cell value, looping through a provided list and record result in Google Sheets

I have built a stock tracking worksheet on Google Sheets where if I enter XYZ symbol in a cell B1, the spreadsheet will pull in Google Finance data (sometimes very slow), do a series of calculations ...
1
vote
0answers
167 views

Converting Facebook profile to page, not all “likes” were transferred nor all “friends” converted to fans

A friend of mine asked me to convert his profile into a Facebook page. So I have initiated the migration process. And I have migrated the friends into Facebook page fans. He has around 4500+ friends ...
1
vote
1answer
20 views

How to use the OR modifier with excluded terms in a phrase in a Craigslist search

How do you reformulate the following craigslist search to avoid repeating the word "no" twice (in order to comply with a word limit in searches). -"no pets" -"no dogs" I have tried the following: ...
1
vote
0answers
18 views

Track unreleased movies in Netflix

When I search Netflix for movies that they don't have yet, it shows no result. How can I add unreleased movies to my Netflix list so that I know when they are available on Netflix? I was a customer ...
7
votes
1answer
59 views

Is there a link to compose a new message in the Inbox by Gmail interface?

The link to compose a new message in Gmail is as follows: https://mail.google.com/mail/?view=cm&tf=1&to={to}&cc={cc}&bcc={bcc}&su={subject}&body={body} Does the Inbox by ...
1
vote
1answer
5 views

Trello card permissions

Is it possible to limit permissions on the board? I want team members to upload documents to a card but not necessarily see the rest of the board. They should be able to track the card with the doc as ...
1
vote
0answers
15 views

Google Sheets - Named Ranges

I have a problem in that I am using named ranges in my G-Sheet and, although the named range is picking up the entire range, it only allows a selection down to "P" on the drop down list on the sheet. ...
0
votes
1answer
26 views

Trello fastest way to replace a checklist subtask by a separate linked task card

I often plan team's tasks using Checklist for big task/breakdown-able user story. And each item in that check list, I want it to be a separate task card so that I can put details to such subtask. ...
2
votes
1answer
27 views

How do I add friends in Send Anywhere?

I am using Send Anywhere for online file sharing on a desktop computer, and I can see no way of adding friends, either in my browser or in the desktop program. Is this possible? And, if so, how?
1
vote
0answers
6 views

Even after I press “Publish release”, Github release stays as Draft

Creating a Github release usually works well, but for one particular project I can't seem to be able to publish: The Draft stays a Draft and never gets published. Is it because that project is a ...
0
votes
0answers
33 views

Selecting and unselecting checkbox not updating response sheet

I have a Google Form and a response spreadsheet that is updated as soon as a recipient of the form answers and submits the form. I have several different types of field ( multiple choice, grid, ...
2
votes
1answer
65 views

YouTube channel search

It appears the YouTube channel search feature has been removed. Example page: http://youtube.com/channel/UClE2TcmrYlBn4L8WM_fnl_Q Previously on pages such as this, you would have a search box for ...

15 30 50 per page