All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
5 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
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
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
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 ...
-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
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 ...
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 ...
-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?
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 ...
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 ...
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
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 ...
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 ...
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". ...
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. ...
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
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:
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
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
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
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 ...
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 ...
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
votes
1answer
51 views

How can I create a new password for my Gmail account?

How can I create a new password for my Gmail account?
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 ...
1
vote
1answer
10 views

Escape single quote in cell content in a QUERY

My Problem I have a Google Spreadsheet with two tabs - one containing regexes and values: And the other containing phrases which matches regex in the first tab, and a QUERY Formula that picks the ...
0
votes
0answers
10 views

Using Google Sheets Making Leaderboard System [on hold]

I'm looking to make a leaderboard where I can keep track of rankings for a game. Participants will play matches and the winner and loser will win/lose points based on a base amount +- the difference ...
0
votes
0answers
10 views

how to visualize time range data in google sheets

i have several thousand rows of data. Each row represents a task and includes the start time, end time, and data related to the task in the other columns. A task duration varies between 1 second to ...
0
votes
0answers
9 views

Unable to get comments on blogger [on hold]

I’m quite new to blogging stuff. I started using google blogger and did my first blog however, I’m not getting any comments. Even I tried myself to comment on it but neither I receive any emails nor ...
0
votes
0answers
12 views

How will Google Photos handle Apply Photos folder structure during sync?

I have over 200GB of photos stored on my mac and it's time to move everything to Google Photos. I have over 15 years of photos stored and many of the older images have little metadata associated with ...
-2
votes
0answers
9 views

Can I recover old chat of lost sim no. through same Gmail account [on hold]

I have lost old sim 9175899169. Now I want to recover old chat. I have same Gmail account. Can I do same
-3
votes
0answers
10 views

Code for a Python list programming [on hold]

In python list name contains these names: Name=["zam","tam","pam"] How to get an output like this: Zam Zam Zam Tam Tam Tam Pam Pam Pam And also like this: Zam Tam Pam Zam Tam Pam... without ...
-2
votes
0answers
13 views

Locked out due to “phishing”?

A week ago when I opened my Facebook app I was shocked to see that I have been “temporarily” locked out of it due to phishing. It says to click “continue” to verify that it’s really me and do the ...
-1
votes
0answers
16 views

Trying to calculate two time based intigers from same pool of resorces [on hold]

I have a pool of resources. Two time factors are eating into them, consumption & spoilage, i.e.: consumption 20 seconds for a unit Spoilage 15 minutes per unit in a stack (30 units per stack, ...
0
votes
0answers
19 views

Function GetRange not found in Google App Script

function importCSVFromGoogleDrive() { var file = DriveApp.getFilesByName("data.csv").next(); var csvData = Utilities.parseCsv(file.getBlob().getDataAsString()); var sheet = SpreadsheetApp....
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?
1
vote
1answer
17 views

Is there a way a normal user can view very old Wikipedia articles?

There is a deleted Wikipedia article I'm trying to see. It's not on the Wayback Machine or archive.is, and it was deleted 2006, before Deletionpedia started, so I can't find it there. Is there any ...
-2
votes
0answers
9 views

Help finding a group message

I am part of a group chat and the other members can see me, but I am unable to see any messages. In fact I cannot even find the group in my messenger. What needs to happen for me to see the messages?
2
votes
1answer
14 views

How to mass-share a selection of private videos on YouTube?

I have a lot of privated YouTube videos, the amount clocking in the hundreds. I would like to share all of them with one person, i.e. let only them be able to see all of those hundreds of videos. ...
0
votes
1answer
7 views

Sliding window average of last N non-empty non-blank cells in Google Sheets

Similar to this question: Average of last 7 non-empty non-blank cells in Google Sheets I'd like a formula to compute a sliding window average of the last N non-blank cells in a column. e.g. For N = ...
-3
votes
0answers
16 views

yahoo account with phone number workarund 2019? [on hold]

Lots of previous questions on this and the answers offering suggestions are WRONG or invalid as of 7/19. Suggestions? Wish Id known before wasting my time with temp mails sms and Twilight. Someone ...
0
votes
1answer
12 views

Assigning a value to a name from a list

I have items that I'm selling, and I've named these codes with the item I'm selling. I want to give these codes the price they should display. I've already got a formula to show the product of the ...
-1
votes
0answers
13 views

how to open google analytics report in new tab?

We have over 3000 content in our site , and we want to inspect our search report in google analytics(We have same problem with search console too). our problem is when navigate to Acquisition -> ...
0
votes
0answers
19 views

IMPORTFEED Convert date format

I have a Google sheet that imports an RSS feed using IMPORTFEED and also the date of each entry using "items created" =IMPORTFEED("url", "items created") The date is shown as Sat, 13 Jul 2019 03:17:...
0
votes
0answers
10 views

Does Facebook Group Social Learning really support up to 5 units only?

I've been creating a new Facebook Group with Social Learning Group Type after reading about it here. It's great for study group and discussion, however, it only supports up to 5 units only. You still ...
-1
votes
0answers
13 views

Google cloud - text to speech: increase Total characters per request [on hold]

The default is 5000 characters, which is really short. I need about 50k limit. Does anybody know how to request for an increase in limit? https://cloud.google.com/text-to-speech/quotas I see that I ...
0
votes
0answers
15 views

How to hide the right contacts panel in Google Voice

I like to run Google Voice in a tab within Rambox. How can I hide the right-panel? It takes up a lot of room, and there doesn't seem to be any toggle.
0
votes
1answer
41 views

How to send to a list of people by bcc in Gmail, but Salutation begin with their first names

In Gmail --- How to: send to a list of people by bcc (blind carbon copy), but in the Salutation, writing Dear ... with their first names. For example, in Bcc: N1, N2, N3, ..., Nj, ... ...

15 30 50 per page