All Questions

Filter by
Sorted by
Tagged with
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 ...
1
vote
1answer
877 views

Wildcards in Google advanced search

I have been using Google advanced search operators like intext:, inurl, intitle, etc. And I know that when search in Google we can use * as a wildcard operator. But I have tried to used * as the ...
1
vote
1answer
605 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
93 views

How to add a date to a cell next to an cell with an imported value

In column A I have a value added each day from the tab/cell TOTAL/A1 by this script: function dailyLog() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sourceSheet = ss.getSheetByName('...
1
vote
1answer
142 views

Prevent section links from breaking when a section name is changed

On Wikipedia, is it possible to find all links to a specific section? I've noticed that changing the name of a section on a Wikipedia article will often break a large number of links and redirect ...
1
vote
2answers
525 views

Google App Script - changeType “REMOVE_GRID”

I'm using a Google spreadsheet. I'm attempting to create an onChange trigger that will activate a script when any sheet is added or deleted. I was able to get the script to work when a new sheet is ...
1
vote
0answers
523 views

Split contents of comma separated cell and send to new row(s) with adjacent cell values [duplicate]

*Question is unique from Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries) in that the parse is required in three separate columns rather than just one. I have a ...
1
vote
1answer
142 views

Set from address based on sender to address

I've got a number of email addresses forwarding to my gmail. I've also set up in my gmail so that I can select my "from" address to be these email address which forward to gmail. However, sometimes I ...
1
vote
1answer
8k views

Google Docs Spreadsheet - Parse Error

Not sure why this formula does not work. I just want the value to be zero if 60-D15 is negative =MAX(60-D15,0) also tried =MAX(D15,0) =MAXA(D15,0) Any clues?
1
vote
2answers
90 views

How to sort incrementally in Google Sheets

Background I'm making a spreadsheet that will plan out attendees for a wedding. There will be separate halls for men and women, and we are debating which age groups should be invited. Right now I ...
1
vote
1answer
2k views

Google Spreadsheet: Count values from last 30 days

Here is a sample spreadsheet you can view and edit: https://docs.google.com/spreadsheet/ccc?key=0AnWwBCPp8kISdGc4bExyYV8xOTVRbnRkaXNQSzBWalE&usp=sharing. How can I count the number of successes ...
1
vote
2answers
5k views

Image beside text in Gmail signature?

I found here how to copy an HTML signature to a Gmail address: Insert HTML markup into Gmail signature I would like to get something like this:(image is hosted on a server): However, I did not ...
1
vote
3answers
13k views

How to keep emails that I put in my folders while deleting them from my inbox in Gmail

How can I keep my messages I put into my folders I created in Gmail? In my Yahoo account, I have lots of folders where I keep receipts, medical records, etc. and they do not appear in my inbox after I ...
1
vote
2answers
1k views

Print all Gmail messages between specific dates

Is there a way to print (or export, or save as PDF) all mail messages between specific dates in Gmail? I realize I could probably do it through an email client, but I would rather be able to through ...
1
vote
1answer
280 views

Run a Script When Tab Programmatically added to a Google Spreadsheet

I'm trying to pull data from an Adwords report to a Google Sheet through an Adwords script. This will be done on a daily basis. Every time the Adwords script runs, a new tab is created (and an old one ...
1
vote
3answers
635 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
2answers
3k views

Formula that displays the last non-zero value cell

I have a report that is able to pull/display values based on yesterday's values. Is there a way I can modify the formula to ignore cells that contain zeros "0s" and to continue to reference/pull the ...
1
vote
1answer
110 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
620 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

Only show certain SurveyMonkey questions based on answers in checkbox selection

How can I show users limited question sets based on what they select in a certain checkbox? Example: Do you like: [checkbox] ice cream soda Pizza and then only ask them about why and how much they ...
1
vote
1answer
81 views

What does the Cognito Forms “entry limit” cover?

Is the entry limit on logins/plans based on numbers per form, or total numbers across all forms?
1
vote
1answer
2k views

How to delete an active domain from a Google Apps account?

I'm trying to delete an active domain from a Google Apps account so that I can create a new Apps account with that domain (long story, I was using one Apps account as a stand-in while waiting for an ...
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.
0
votes
0answers
28 views

Instagram Sign Up Errors Leading to Wrongful Account Violation Notice

I've NEVER been a member of Instagram, but I need an account for following certain people in niche industries that I work with. So ( using Windows 10 ) I go to the sign up page and enter my details: ...
0
votes
0answers
20 views

Print First Modified TimeStamp of edited Cell in a Column range [duplicate]

This code by @Ruben prints out the timestamp for the first modification for A1 into B1. How to do the same but for the whole column so A2:A printing results into B2:B? // Global variables var origin =...
0
votes
0answers
8 views

Is there a way to restore Google Chrome's browsing history after clearing cache without logging out of Chrome?

My chrome browsing history was deleted because I cleared the cache and missed the small print which said to log out before clearing the cache. To clear browsing data from this device only, while ...
0
votes
1answer
147 views

Gmail account storage full

I am having a Gmail account and this account is configured with window service.This window service read mails with attachments from inbox and send update back to user after particular interval. ...
0
votes
1answer
896 views

Restrict the valid values in one cell, based on the value in another cells

I am trying to prevent a date being entered into a cell if the date precedes the date in another cell.
0
votes
1answer
6k views

How do I delete all contacts in Google apps permanently?

When you have synced your contacts on your Android phone with Google contacts and decide to withdraw them from Google, how can you permanently delete them? I went to Gmail->Contacts and there I could ...
0
votes
1answer
19 views

How can i add search bar above dropdown menu on Google Forms?

There are around 550+ items on the dropdown list, is it possible to filter them out?
0
votes
1answer
47 views

Aggregate Formula in Google Sheet using wildcards

I'm trying to copy and paste an excel formula I use to categorize data into Google Sheets and struggle as the formula doesn't work. I have two sheets: The Referral sheet contains all the referral ...
0
votes
1answer
24 views

Possible for users to have unique instances of the same document? (not downloaded copies)

My Google sheet consists of a locked list of items and a single cell that can be edited. This cell acts as a search box to filter the list. I want multiple users to be able to search at the same ...
0
votes
1answer
14 views

Optimize Google Sheets to process/summarize large amounts of data [duplicate]

I have a Google Sheet where data is uploaded from a Google Form in one page and workers input data directly in another page. The data is combined into one table via scripts. I am trying to create a ...
0
votes
1answer
29 views

Incorrect and somewhat strange results when using COUNTIFs with Arrayformula

I have three functions responsible for checking if I own a stock (by seeing that the column F is not empty) Then I want to check column AB to see what market the stock is from. In the first case I ...
0
votes
1answer
118 views

How can regular non admin users see who is their G Suite admin?

For regular non admin users, is there a way to see who is their admin for their G Suite account?
0
votes
1answer
4k views

How to move a row into another sheet?

In Google Sheets, I need to hide rows if column H says, "Completed" My preference would be to cut and copy the row to a new sheet if column F reads "Completed", but sounds more difficult. If you ...
0
votes
0answers
119 views

Unable to set nickname/change name of Google account

I am trying to change the name in my google account at https://aboutme.google.com/. I get the following error. Trouble updating your information. Please try again later.
0
votes
0answers
28 views

Trouble copying cards [duplicate]

How do I copy a card? I keep reading that I have to tap the side bar on the back of the card. I'm assuming the side bar is those little grey lines... But they don't respond to tapping. I know I am ...
0
votes
1answer
1k views

How to remove the name of a recipient

GMail has recently rolled out a new method of composing a message: the composition appears as a popup stable at the bottom of the screen, and one can look at other mail for reference, say, while ...
0
votes
2answers
181k views

Change back to Hotmail from Outlook.com [duplicate]

I have been changed from Hotmail to Outlook.com and I am not satisfied with the new webmail system. Is there any way that I can switch back to Hotmail from this new Outlook.com service?
0
votes
3answers
1k views

Where do I download Instagram for use on a PC?

Where do I go to download Instagram on a PC and how much data is it gonna take? How much does it cost?
0
votes
2answers
1k views

Create chart with total for each score

I have a column within a Google Spreadsheet with values like this: 96 97 96 100 97 97 100 97 95 95 96 I'd like to add a bar chart where each bar represents one of the values and the height of the ...
0
votes
1answer
289 views

Inverse of Google Sheets GetSpreadsheetNameById

This post Display sheet name in Google Spreadsheets shows how to get the name of a Google sheet, given its URL. I have the opposite problem. I know the Spreadsheet name, but I want the URL to use in ...
0
votes
1answer
1k views

Titles of a playlist in YouTube

How to get the titles of all videos in a playlist (either through a program or any other means) in order to sort it offline? I need this to put a vote among friends to sort it.
0
votes
1answer
2k views

How to redirect mail from Gmail account to Google group mail [duplicate]

Is it possible to redirect mail from one Gmail account to Google group mail id. If possible then how? I had seen these type of problem but all I found are unsolved: Automatic Forwarding: Gmail to ...
0
votes
2answers
254 views

IMPORTRANGE connect sheets

When using IMPORTRANGE on Google Sheets, one has to "connect sheets" as follows: Where can I check which sheets are connected, and what exactly (what access rights etc.) this "connection" implies?
0
votes
1answer
62 views

Migrate Google Chats from One Google Account to Another

I have two Google accounts - an old one that I used for a while as a kid, and a new one I opened when I became a working professional and needed a professional-looking personal email address. It's ...
0
votes
2answers
2k views

Twitter no longer posts to Facebook page

I have 2 Twitter accounts and 2 Facebook pages. Everything was working fine all my tweets was posted to each Facebook page automatically until around 11 April 2013. Is there anything Facebook ...
0
votes
2answers
3k views

Sign out one at a time from multiple Gmail accounts in Chrome

Anyone has solution how to sign out one account at a time instead of signing out all at one time in Gmail? Because, for example, I use Gmail account A to Sync my whole data, like Chrome, Google Keep,...
0
votes
1answer
2k views

How to zip two columns together in a Google Sheets [duplicate]

For example columns are setup as: A | B ----- 1 | a 2 | b 3 | c 4 | d 5 | e I want to be able to make column C be like this: C --- 1 2 3 4 5 a b c d e via formula. The two columns will ...

15 30 50 per page