All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
4 views

Is it possible to create a share link to a specific location in a Word Online document?

I would like to be able to send a link to a colleague, which will take him to a specific location in the document when the document opens in the Word Online web application. For example, a programmer ...
0
votes
0answers
3 views

Process visualization based on data

I am trying to use a google spreadsheet to visualize a customer journey. I am trying to create the following graphic: I have created the following example spreadsheet: https://docs.google.com/...
0
votes
1answer
18 views

Google Sites: How to create Blog-like sites [on hold]

I'd like to create an internal sites for my company, in which we can post articles that can be tagged in multiple categories of tagging. For example, we have two categories "Country" and "Topics". ...
1
vote
2answers
3k 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 ...
4
votes
2answers
9k views

Password protect a Google Sheets

Is there a way to secure a Google Sheets?
1
vote
1answer
14 views

Array formula for adding letters after duplicate numbers in order

The below formula adds a letter after a sequential number, A, B, C, D, etc for the same number until it finds a new number, then it starts again from A. I need help on turning this into an array ...
18
votes
8answers
87k views

How to Fill a Column with Sequential Dates in Google Sheets

In Excel you can right-click drag a date downwards to fill a column with the next dates in the sequence. For example if you enter 9/1/2014, select that cell, then right-click drag down over the cells ...
0
votes
1answer
71 views

How can I check my storage on my OneDrive for business account?

How can I check my storage on my OneDrive for a business account? https://faq.oit.gatech.edu/content/how-do-i-check-my-storage-usage-onedrive-business says: but I don't have the "site settings" ...
0
votes
2answers
82 views

Are WordPress Jetpack stats accurate?

I have a blog on WordPress running for a few months now, and is a free subscription. It has only the default Jetpack Analytics which shows Page views, visitors and the same by country. This is a tech ...
1
vote
0answers
6 views

Conditional Formatting formula for alternating checkerboard with Merged Cells?

I wrote a formula that attempts to create a checkerboard pattern via conditional formatting, that should even work with Merged Cells. However, it seems to fail in an almost undebuggable manner with ...
0
votes
1answer
4 views

How to reference a local cell in QUERY?

I just about have formula 100% perfect. Just one issue: Formula (Works): =QUERY( ImportRange( "https://docs.google.com/spreadsheets/d/1Lf4r_b0fmFh6fClZsGmfZmo8ZD87qf8N_0f-Jaoyu-g/edit#gid=0", "...
0
votes
1answer
16 views

Simplify multiple OR statements in a QUERY using IMPORTRANGE

I am trying to query values from a different sheet using a range from the current sheet. Is there a way to simplify the formula and get rid of all the ORs? Like maybe using a FOR loop? =QUERY(...
1
vote
4answers
7k views

Formulas in Google Sheets won't execute

I can't seem to get formulas to execute in a Google spreadsheet. Whenever I input a formula, it does not return any output, but rather leaves the cell blank. I have tried the following troubleshooting:...
37
votes
8answers
30k views

Automatically sync Meetup events with Google Calendar [duplicate]

Is there anyway to automatically have my Meetup event calendar sync up with Google Calendar, or even Outlook? Update I want to do this for all of my groups at once (not each individual group)
0
votes
1answer
12 views

Google Maps grey dotted lines identified location

I clicked to search for directions on a place on Google and it redirected to Maps. Google was able to precisely identify my location The map displayed several thick grey dotted curves all converging ...
0
votes
1answer
33 views

Repeat formula n number of times in Google Sheets

Apologies, I'm very new to Google Sheets and spreadsheets in general. I'm trying to fill some cells with repeating data, and then analyze it. The data is pulled from another large spreadsheet and has ...
-1
votes
1answer
716 views

Sync two cells value

Is there a way to way to link two cells so when one is altered the other is altered also? Like this: I alter `A1` to 1, `B1` is now 1 I alter `B1` to -1, `A1` is now -1
1
vote
2answers
917 views

YouTube - 4k 60fps - Dropping frames (Stutter/Lag/Freezes)

I'm trying to watch 2160p (4k 60fps) content on YouTube, however, I experience large amounts of dropped frames... i.e. the video freezes/stutters completely (the sound is fine). The YouTube example I ...
0
votes
1answer
12 views

How do I filter news articles out of my google search?

I'm trying to google a topic which has a lot of heavy media coverage. I'm looking for technical details though, not any media coverage. The problem is the most combinations of search queries end up ...
0
votes
1answer
3k views

How to report impersonation of Hangout account

Someone is trying to impersonate me and has created a Google+ account and Hangouts. The Google+ account has a picture of me and I reported the impersonation of it and it was removed by Google. But the ...
1
vote
1answer
18 views

How to extract the first rows that have a unique value in specific column in Google Sheets?

The unique items in D are: 4,3,2. I wish to extract 3 rows for each D value, For each row, provide the first row that this D value appears. I tried using =query but it doesn't support grouping or ...
0
votes
0answers
13 views

Excel Online can't see other people's selections

I found this on microsoft's website: Why can’t I see other people’s selections? You can see other people's selections in different colors, but only if you and other people are using Excel for ...
-1
votes
0answers
3 views

Google Form Drop-Down List questions based on previous drop-down list select

The majority of questions that I have found regarding Google Forms referencing the drop-down listing based upon another drop-down list selection (cascading), is directed to the Google sheets, or it is ...
0
votes
0answers
9 views

How to getFullName()

I would Like a code example how I can get getFullName(), in google sheets. Basically, I have multiple users using Google sheets and would want that every time they edit I cell in the Sheet, there ...
1
vote
1answer
23 views

In gmail, how to filter messages to support@mycompany.com but not if they are also sent to me@mycompany.com

I'm receiving quite a lot of emails for support in my inbox that I want to filter out. A couple of weeks per year I'm on stand-by. In those weeks I need to be able to receive those emails sent to ...
3
votes
2answers
656 views

Can a Slackbot create emoji?

The only emoji command I can find is https://api.slack.com/methods/emoji.list Is there a way to programatically create custom emoji? Or is the only way via manual process - https://get.slack.help/hc/...
1
vote
1answer
15 views

How to get cell's parent ID?

Firstly thank you for helping me out. I'm in the construction industry and don't have any clue how to best do this - not my forte! I'm trying to bulk add a bunch of building product categories to my ...
2
votes
1answer
10 views

Google Sheets date conditional formatting

I have dates in column D in Google Sheets. I want the cells to highlight red if 30 days have passed and there is not a comment date in column F. Example: Column D: Submittal Date 6/29/2019 ...
1
vote
1answer
745 views

I cannot transfer ownership in Facebook

My bosses recently have decided to part their ways, so we removed the first boss from the Facebook, yet it shows, that he is the owner of it, as in it is owned by his business. And since he is not so ...
0
votes
1answer
29 views

Fetch value of a cell based on dropdown menu items results on another sheet

I have 2 Sheets named as Sheet1 and Sheet2... Sheet1: Contains Drop down list on B4 Column. Based on the selection of an item, it pulls the result of the open price shown on D4 column. Sheet2: ...
10
votes
4answers
16k views

How to calculate the next Monday after a given date?

I am looking for a formula that can look at a cell value that contains a date and return the first Monday to occur after that date. Examples (MM/dd/yyyy format): 10/22/2013 (Tuesday) would return 10/...
-2
votes
0answers
11 views

How to block a seller [on hold]

I've had a bad experience with a seller and want to be sure I don't give them repeat business in the future. Is there a way to block a seller?
6
votes
2answers
15k views

How do I hide events in Facebook?

Sometimes I will be invited to an event that I don't care about. In these cases, I would like to hide the event from my event list. In some older version of the site, I could do this. I just can't ...
0
votes
0answers
31 views

Migrating accounts in Gmail

My school is quite annoying in that they want to delete all email accounts once you graduate. Having graduated I now have to move everything from one email to another, but the thing is that email is ...
90
votes
27answers
12k views

How do I download a YouTube video?

How do I download a YouTube video? I have used various solutions in the past that do not seem to work any longer (KeepVid and various Greasemonkey scripts). Is this just no longer possible?
1
vote
1answer
80 views

How to enable two factor authentication in Office 365?

The two factor authentication option cannot be found when the settings button has been clicked.
1
vote
1answer
12 views

Adding mm:ss times when expressed as TEXT

I have a series of numbers that, for a reason out of my control I can not change, are expressed as plain text strings on google sheets. The numbers are supposed to be minute second. mm:ss. For the ...
0
votes
2answers
13 views

How to extract email link text from Google Sheets hyperlink? [on hold]

Can you extract the copy email address text from a hyperlink? See example:
1
vote
1answer
9 views

Which filename extensions are NOT safe to move outside of a syncing Google Drive folder? (because the corresponding Google Docs will be deleted)

When syncing Google Drive to your computer, the following SHORTCUT files will be synced, which link to the online web-based Google Docs documents... .gdoc .gslides .gsheet .gdraw .gtable .gform ...
0
votes
1answer
9 views

Replies to my comments

So I comment on a video, and someone replies, the little notification pops up and I can read about half of the comment. There's no 'read more', so I click and it goes to the video in question but not ...
0
votes
2answers
15 views

Format Cells if greater than “value of the cell”

Values of K11–K13 are variables. On the Conditional formatting, I want to use the output from those cells in the "Greater than" function. Typing =k11 doesn't work. I'm not really sure on how to do it. ...
0
votes
0answers
25 views

Split Master Sheet into Multiple sheets

I have a master sheet where the data is like this: Would it be possible to split this into multiple spreadsheets so it can look like: and the sheets are divided into Weeks? Scripts or formulae are ...
1
vote
1answer
25 views

How do I tweet a thread of tweets at someone?

If I want to tweet something to someone on Twitter, but what I need to say will take up more than one tweet, how do I tweet it at the person in a way where the tweets will be nicely threaded when the ...
3
votes
4answers
2k views

Is it possible to use IMPORTHTML to return only certain cells?

I'm currently using IMPORTHTML to import tables from a website that have five columns and three rows. But, I only need three cells from each of these tables. Is there a way to import just these ...
0
votes
0answers
12 views

How to move row in Google Sheets after checking a check box?

I'd like to be able to move an entire row from one sheet to another after a check box is checked. In this spreadsheet I'd like to be able to check the "Letter Sent to Client" checkbox and have the ...
0
votes
0answers
6 views

Google groups show unread counts is not longer working for me

Google groups is failing to display the number of unread messages in each group next to the group. This feature stopped working for me a few months ago. I thought perhaps I had met some limit on ...
1
vote
2answers
41 views

How to make sequential list of months?

I want to fill column names with a sequential list of the last day of each month. For example, 3/31/2018, 4/30/2018, 5/31/2018, etc. Is there a formula that can do this? If cell B1 = 3/31/2018, I ...
1
vote
0answers
9 views

Google Sheets' IMPORTXML pulling from the wrong region

I'm using IMPORTXML to get the price of an electronics component from Mouser: If the prices are refreshed as a result of me editing the spreadsheet, it requests from my computer, and results in the ...
0
votes
0answers
3 views

How to disable suggestions in Google docs

I've written a doc and I keep getting suggestions on it it's unreadable. How do I turn comments off?
0
votes
0answers
32 views

Some Twitter GIFs don’t work in PC browsers, do work in mobile browsers

I could really use some help figuring out this very weird issue I have with Twitter GIFs. Some Twitter animated GIFs (which Twitter converts to MP4s, but I’ll refer to them as GIFs for simplicity’s ...

15 30 50 per page