All Questions

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

How do I Google a range of numbers in a link?

How do I Google - which books on Toronto Public Library's website fitting my selected criteria, have 50-100 copies? Inputting 50..100 copies site:torontopubliclibrary.ca/search.jsp?Ntt=introduction+...
-1
votes
0answers
36 views

Google Gmail account [duplicate]

I had to factory reset my phone, I do not have the phone number that I originally set it up with nor do I remember my password. How do I recover this email account?
0
votes
1answer
13 views

Will sub-folder contents be restored under respective sub-folders?

My wife's hard drive crashed recently with a bunch of pictures in sub-folders under the Pictures Library. IF they had been backed up with Google Drive, would they have restored with all pix in ...
0
votes
1answer
26 views

Finding a Google Doc that was accessed through a link

I found a useful Google Doc online, but I accidentally deleted the document from my Google Drive, and now I can't find it anywhere. The Doc doesn't show up in Trash, it doesn't show that I ever opened ...
0
votes
1answer
12 views

Google Sheets countif range with date/timestamp

I have a lot of requests coming in with the following timestamp (Created time Column) and I would like to quickly be able to count how many requests came in during each hour. I found I can get a code ...
1
vote
1answer
104 views

How to export and import my block list in the 2019 “New Twitter” UI?

Twitter recently rolled out a redesign of their desktop website interface, and the ability to export and import my block list seems to have been removed. Exporting/importing my block list was useful ...
0
votes
0answers
14 views

Google Sheets Form Response Split Multiple Responses

I've created a form for my staff to enter metrics about their job so I can track how new operations affect their output. For the ease of my staff, I'm hoping that they can submit multiple responses ...
0
votes
0answers
5 views

How can I create conditional formatting based on a reference table?

I'm trying to format rows in my spreadsheet based on a single column (S), which is fine BUT S contains both the category and the status of the item in each row. I want to color the row based on the ...
0
votes
1answer
25 views

Force the *legacy* (old mobile) version of Twitter?

Twitter.com currently has more than one version. There's a new unified desktop/mobile version, and more than one "older" version for "unsupported" browsers. If I disable Javascript for twitter.com, ...
0
votes
0answers
2 views

Query to transpose data with col 2 offset for column headers

DATA: Col 1 = Job numbers Col 2 = Task numbers Col 3 = Date I would like to have: Col 1 = Job numbers All other Col = Dates with Col 2 as headers transposed So something like: query(DATA,"select * ...
0
votes
0answers
9 views

How can I see all Oculus Quest applications?

I'm trying to use the Oculus Quest Store online web app to find games that I might be interested in. However, there are some apps that don't show up in the store unless I search for them. For example,...
0
votes
0answers
3 views

I want to use ArrayFormula to sum and automatically expand the results vertically with start and date range

I want to use ArrayFormula to sum and automatically expand the results vertically with start and date range. Currently I have this so far: I want to use only one formula to sum and automatically ...
0
votes
1answer
9 views

How to compare values in two columns?

If I have the following two columns with values: A B 2 3 4 1 7 10 8 1 9 5 How do I create a count for column B that shows values greater than the same row in column A? In this ...
2
votes
1answer
24 views

Pasting text without interpreting as formula

I'm trying to copy a table of data from a website into Google Sheets. The table includes a column whose numbers are preceded by +/-, e.g., +/- 33. Excel works just fine, allowing me to paste in the ...
0
votes
1answer
25 views

Need to get a list of Drive files several subfolders deep

I need to get a list of all the files in my Drive with all of the nested folder names where the files reside. I found this very helpful answer which is almost exactly what I need: Get a list of ...
0
votes
0answers
9 views

How to search a GitHub repo's commit history

I would like to search for the word "foo" in specific folders in a single GitHub repo. I want to see a list of historical commits to files containing this word. This way I can try and track down where ...
-1
votes
0answers
25 views

Google Search font 10% bigger

Is it just me, or in some instances in the past week or so, the font for Google Search is 10% bigger? I find myself turning the page to 90% zoom, which feels like the old setting. Is a Google intern ...
0
votes
1answer
37 views

Can indirectly shared Google Docs be monitored by admins?

My Google Drive (company provided: example@examplecompany.com) is getting pretty full, and I've been going through it and deleting files. I came across a rather inappropriate Doc someone sent to me. ...
0
votes
2answers
39 views

How to wait for Google Spreadsheet calculations to update before retrieving cell data in Apps Script web app?

I am creating a Google Apps Script web app that uses Google Sheets as its backend. This web app basically allows users to track their work time (clock in for the day, clock out for lunch, clock in ...
0
votes
1answer
9 views

Checkbox that can display a checkmark or an X

Trying to make a checkbox that with one click it displays a check and with two clicks it will display an "x". is this possible? I've been looking for a way but the only thing I can find is a drop-...
1
vote
0answers
11 views

Google Data Studio and Slack integration

How Can I connect my Google Data Studio reports, or parts of them with slack? I would like that each day appear in slack some report that I will customize in Google Data Studio. And if I want to do ...
0
votes
1answer
18 views

How can I extract specific information from the cells

How can I extract just the: Brand, Showroom Only Product, etc.
-1
votes
0answers
20 views

Facebook: person X can message me but person Y can't (and how can I fix that?) [closed]

Facebook: person X can message me but person Y can't although both are not friends and not friends of friends (and how can I fix that?)
0
votes
1answer
20 views

The YouTube option “open transcript” is not working

I have a problem in my Chrome browser (not in other browsers): The YouTube option "open transcript" stopped working. It's showing an empty box without content like there were no captions at all. ...
0
votes
0answers
38 views

Share your Facebook photo album with non-Facebook users

In the 2000s (before 2010) Facebook would allow you to get a direct URL to one's own Facebook album that could be emailed and shared with non-Facebook users. People have asked this question before ...
0
votes
1answer
9 views

Custom side menu question & active sheet

I am trying to create a custom side menu that changes depending on what sheet I am on so the side menu is relevant to what I am on. I've attempted doing some code to do a tactic where depending on ...
0
votes
1answer
16 views

Having trouble outputting GOOGLEFINANCE data

My wish is to create a table in Google sheets looking something like this: price day A B C D ... Z 1997-01-02 132.54 . . . . 1997-01-...
0
votes
0answers
8 views

Is it possible to retain your own folder hierarchy structure for your ebooks when uploading them to Google Books?

I can see that Google Books offers shelves but I'd really like MY OWN structure for organising my books, not how Google thinks I should. Is this possible?
1
vote
1answer
14 views

Is it possible to have different URLs for edit and view of the same Google Drive folder?

I'd like to share the same Google Drive folder with a group of people and within that group, some have edit access. However, when I share that link to the folder to view, if I go back to that folder ...
0
votes
0answers
30 views

Facebook page messages encryption

When starting a conversation with a Facebook page, there is no indication as to if the conversation is end-to-end encrypted. For users you can start a "secret conversation" which I assume will then ...
0
votes
1answer
11 views

Google Sheets Scatter chart: multiple data points at same X location

I have a dataset where I have on each row data associated with an item that has a name (alpha, beta, gamma in the example), as follows: I now want to create a scatter plot where the X axis ...
-2
votes
0answers
20 views

Facebook friends except option is visible to new friends?

If I posted smth last week and made a group of my friends unable to see it by "friends except option", will new friends that I accept will be able to see it ? My new friend is not excluded from seeing ...
0
votes
1answer
24 views

How can I reply to a tweet and show that to my followers?

How should I comment on someone else's tweet to make my comment visible to the original tweeter and other users looking at the original tweet replies and my own followers? I've noticed that if I "...
0
votes
0answers
27 views

Is it possible to make Gmail show addresses instead of contact names?

For example, if I receive an email from John Doe, Gmail will show in the Inbox preview "John". The problem is that if I receive email from a dozen Johns, all of them will just show up as "John", so I ...
-1
votes
0answers
13 views

Is it possible to follow a public facebook group I'm not in?

I want to follow (i.e see in my feed) a public group that I'm not in - is it possible? Joining the group is not an option, since the acceptance is restricted, but the discussions there are ...
0
votes
2answers
26 views

Is it possible to have Google Sheets query function that accepts a dynamic query argument instead of hard coding?

I have a long OR query function that I will be reusing many times in many contexts and that may change frequently. Following the principles of DRY design, I would like to write this query once and ...
0
votes
0answers
8 views

Background Image in full size [migrated]

I am new to web development, to practice a little bit I have downloaded a theme online to play with it, however I am having a hard time keeping the background image in full display, as soon as I ...
1
vote
1answer
13 views

Total Spent Formula in Google Sheets

So with my sheet, I am currently in the process of adding more stats in, I have looked into adding these stats by using Index & Match however it will only match to the first correct match it has ...
0
votes
0answers
5 views

Google Calendar Remove vs Unsubscribe

Google Calendars (as of July 2019) have an option to "Unsubscribe" or to "Remove" them. If a calendar is shared with multiple users, the difference is obvious: "Unsubscribe" removes it only for me, "...
0
votes
1answer
14 views

Google Sheet Calculation Only Updates on Return

I am using the formula below. It will only update when I go into the cell and push "enter" to leave the cell. I think it is due to the iferror function. It is calculating correcting but I have to hit ...
0
votes
0answers
10 views

What happens if an user turns 30 while using subscription on Tinder?

Tinder uses an age-discrimination model for its subscribers. After a lawsuit they ditched the discrimination model, but it seems to be only in California, according to the link. So I wonder what ...
0
votes
1answer
9 views

Unable to join new slack group

If you see from the snapshot, I am not able to join the new slack group. I tried the same email and password separately to login into slack.com and it worked. Not sure why it is telling me username ...
1
vote
1answer
46 views

Get last value entered past a specific row

I have been on this a couple of days and I cannot get my head around this ... I use a spreadsheet to track the number of miles traveled by drivers and I want to work out how many miles a driver has ...
1
vote
1answer
10 views

Conditional Output on cell based on 2 different “IF(REGEXMATCH” functions

First of all sorry if I am not clear. it is my first question. I am trying to make a cell give an output with IF(REGEXMATCH on the cell A1 for example =IF(RegExMatch(A2,"YES"),"Good" I also need ...
0
votes
1answer
19 views

Have script ignore first row [duplicate]

I am using this script to add in a date whenever a row is edited. I want it to ignore the first row. Thoughts on how to do this? function onEdit() { var s = SpreadsheetApp.getActiveSheet(); // ...
1
vote
0answers
18 views

Numbered list with Cyrillic letters

In Google Docs, I would like to have a numbered list using Cyrillic letters, such as: а б в г д The regular choices for numbered lists offer the options of Arabic numerals, Latin lowercase,...
0
votes
2answers
27 views

If cell y contains any word from range x:x, mark cell y green

In Google Sheets, I have three columns (with different lengths!) Column1 contains firm names (50) Column2 containts firm names (100) I would like to mark a cell in Column1 green (or with a number in ...
0
votes
1answer
11 views

Does Google Docs support sequential fields?

In MS Word, you can have sequential form fields, for instance, a document could have a field like Chapter {N}, where the actual number increases sequentially, incrementing after each occurence. This ...
1
vote
2answers
19 views

Formula for getting the Left most cell value from a 'Range of cells'

Need your support in finding a solution for an issue which I am facing now. Formula for Column A... Data Range from B to D Have values in a range of spreadsheet cells (From column B to D) Value ...
1
vote
1answer
9 views

Google Sheets forumla help

With my sheet, I need it so that if the job is any type of "Repair" then it minuses 1000 from the business profit but if it's anything else it doesn't minus the 1000 from the business profit. I have ...

15 30 50 per page