All Questions

0
votes
1answer
10 views

Can you auto update the range for a filter in Google Sheets?

I have a Google Sheet document with many rows in it. I have several filters set up to view different collections of rows. The problem is, this sheet has new rows automatically added to it several ...
0
votes
0answers
12 views

Generating unique 4 digit code as Google Form response

I want to generate a unique 4 digit code to send to submitter as an unique code validation. I work in an environment where customers inform us of their names but they interchange it between English ...
-2
votes
0answers
24 views

Can’t remember my email or password how can i log in [on hold]

I used the badoo app few years ago. But now I can’t remember my email or password. How can I login
0
votes
0answers
40 views

Gmail Search issues

I tried to locate a message based on a job number within, but will not find it. I can manually find the email. - When I try another job number it works. The only difference is the size of the ...
0
votes
0answers
6 views

Back reference in Wikipedia

Say an entry A has a cross-reference pointing to entry B. Is there any chance that given entry B, we can know it is referred by entry A (any probably other entries)?
0
votes
0answers
9 views

Mts meta info is not view able via Google Drive

The data is there, but Google Photos/Drive seems to ignore it. Is it not viewable in anyway?
0
votes
0answers
9 views

Can I colour code different labels in the CONTACT Gmail section?

I can see that you can emails into colour coded Labels but I want to colour code the Labels in the Contacts section but can't seem to find out how to do that. E.g. I want to have the Label called ...
0
votes
0answers
4 views

Is there a keyboard shortcut to add a non-breaking space in Chrome [migrated]

We have a number of staff/ clients using Chrome to manage various Content Management Systems (i.e. Squarespace, Shopify, Silverstripe, Wordpress etc.) In some cases the users want to add a non-...
0
votes
0answers
8 views

Amazon affiliation: link clicked on the same network on which is generated, but different users and machines

I have an account on Amazon affiliation. I generated a link to a product from my PC, and published on my website on intranet. Another user on another machine on the same network clicked my link and ...
1
vote
1answer
17 views

MIN and SUM functions in Google Sheets for Time

I'm trying to use the MIN and SUM function but the answer always comes back with either 0, ERROR or !DIV/0. The format I want to have for my times are for example: 0.03, 10.56, 1:13.00. =MIN example:...
0
votes
2answers
24 views

How can I delete my daughter's 3 Instagram accounts?

My daughter has three different accounts and I want to delete all of them. How can I do this?
0
votes
0answers
9 views

Google Data Studio only imports old Google Fit data

I have connected Google Fit to Google Data Studio to visualize my Google Fit data, but last 2 weeks is not in Data Studio, only in my Google Fit app in my mobile. Can it be fixed, so I get current ...
0
votes
1answer
16 views

How to output end task time base on start time, duration and working time in Google Sheets

I'm using a spreadsheet to perform calculations and I'd like to make a task management file. For example: Working Time: 8:00 ~ 17:00 Lunch Break: 12:00 ~ 13:00 +- Start Time -+- Duration -+- End ...
0
votes
0answers
11 views

Highlights connected to comments dissappeared

I have someone reviewing a document for me in Google Docs. All of a sudden her comments are there on the right, but the highlight over the text associated with that comment is gone. In other words, I ...
0
votes
1answer
13 views

How to upload a photo from mobile phone to Google Forms as an answer?

One can choose file upload to Google Forms, but when answering in form option only opens Google Drive upload dialog. Is there any way to upload photo from mobile phone as an answer? E.g. is it ...
0
votes
0answers
6 views

How do I set text to 'Normal Text' while keeping style in Google Docs

So in order for my table of content working properly, I want to set some of my texts to Normal Text (which removes them from the table of content) while keeping its styles. Is it possible to achieve ...
0
votes
1answer
197 views

How to login on Gmail without the phone? [duplicate]

My phone was stolen, I'm trying to login to Gmail, but since Gmail sends a code when you log in I can't get the code. I still know my password but it still asks for the code. I tried my recovery mail ...
-2
votes
0answers
16 views

Regain my Instagram account when codes sent seem to be invalid [on hold]

I can't gain access to my Instagram account. I've trying help with signing in and it's not working even after resetting my password. Kindly help.
1
vote
1answer
11 views

How to search within a Twitter user's likes

In Twitter, is there an operator that allows you to search within a user's likes? Perhaps something like likes:username or list:username/likes etc.?
1
vote
1answer
16 views

IMAGE from Google Drive in Google Sheets [duplicate]

I have the following image on a cell in my Google Sheets: https://drive.google.com/open?id=1C9KL2vEhnZOVdCe2qUG5MZomw3jpvCiX When I use the formula =IMAGE(A1), the cell with the image stays white... ...
-1
votes
0answers
46 views

Some websites won't load on Chrome Canary, ERR_CONNECTION_CLOSED [migrated]

Some websites' assets fail to load on Chrome Canary, i.e: GET https://abs.twimg.com/a/1547701933/css/t1/twitter_more_1.bundle.css net::ERR_CONNECTION_CLOSED Accessing https://abs.twimg.com/a/...
0
votes
1answer
16 views

Highlight cell border in Google Docs

I'm trying to create a table in Google Docs. I need a header row at the top and a similar column on the left side. To distinguish these from the rest of the table I am trying to embolden the line ...
1
vote
1answer
249 views

How can I change the Google Docs (Sheets, Slides) user interface design?

I have several Google accounts. I noticed that the user interface of G Suite Apps in my new account is different from the one in my old account. Could you please tell whether I can choose it and how ...
1
vote
1answer
9 views

LOOKUP for data from other sheet

So I have a drop-down menu in order sheet and I have an info sheet. In the info sheet, I have 2 columns, column A has the customer name, column B has the customer e-mail. So what I'd like to do is, ...
-1
votes
0answers
19 views

recover my gmail account [duplicate]

I remember my email ,but my password no. When the scree brings me to the uestion t send a code , they have a number that I don't have anymore. How can U change this part could you send thecodeto my ...
0
votes
1answer
27 views

How to print the first modified date of a cell

I would like to make a script that works like this script to print a timestamp when a cell was last updated but in this case I want to return when it was first updated, not last. Here is one attempt:...
1
vote
3answers
44 views

SUM columns from other sheets and group by month, but also show the individual sheets values before doing SUM

Currently, I have a spreadsheet which has a number of customer sheets, each with a pivot table showing the month in the row I and the total income for each month in row L. On a separate sheet I have ...
1
vote
1answer
21 views

How to view my sent tweets?

Why can't I see my tweets? My profile says I sent 46 (and I did), but when I click on Tweets, I cannot see them and Twitter says: Send your first Tweet! Why is that? (one of my tweets is from ...
-2
votes
0answers
24 views

Using OFFSET to skip columns with a certain header in Google Sheets

So this is a tad more complicated than the title suggests so try to follow along: On this sheet, I'm trying to get cells D4:G4 to show the most recent 4 weeks with data on my spreadsheet. My formula ...
-1
votes
0answers
18 views

Joining a group as a Facebook Page?

I've recently learnt that you can join a Facebook group as a page yourself, which is great for me as that means I can interact as the page rather from my personal account. However, when joining a page ...
0
votes
0answers
9 views

Rename Word Doc in Office 365

How do you rename a doc in Word (Office 365). Accidentally named a file in Word as "xxxxx 2018" Need to rename it to "xxxx 2019". I have tried to RC on the doc but drop down menu does not show ...
0
votes
0answers
8 views

Workable Equal Employment Opportunity Forms (EEO) forms?

I see a lot of companies are using Workable's "Equal Employment Opportunity Forms" ("EEO forms"). Does the employer actually see them, or are they just tracked by Workable? You can, not answer the ...
0
votes
1answer
7 views

Defining Value to Numbers and Text and then Adding them

I am comparing apartments and I have columns for features like bedroom, full bath, half bath, rent, pet friendly, balcony, laundry, utilities, parking, and bus access. Some of these have numbers like ...
0
votes
1answer
16 views

How to use the “Make a Copy” trick when sharing a Google Form?

I want to share a Google Forms file with customers and, when each one of them open it, I want the file to automatically ask them if they want a copy of the file in their own directory.
0
votes
2answers
19 views

Insert weight in kgs AND lbs in one cell?

Right now, a cell is showing the value: 10 I want it to show: 10 kg or 22 lbs And I want that to happen in the same cell. Also, that 10 is also a result of a calculation =B2-80 I ended up using ...
-1
votes
0answers
11 views

Day based Weekly Schedule for a particular date range

I would like my clients to specify a date range and then on a corresponding table or otherwise, specify the days of the week and the start and end times within this period they would like service. e....
1
vote
0answers
134 views

Retrieving mails from deleted/disabled Gmail work account?

Long story short: my employer disabled my work account and I need certain archived emails from that account. Unfortunately recovering the account via Google doesn't work, since I don't have the ...
0
votes
0answers
8 views

How do I circumvent the “Your connection is not private” error [migrated]

For school, I sometimes need to go to third party websites for audio books for class. A lot of the YouTube ones are restricted, so I try to find ones on third party sites. I then get an error saying "...
0
votes
1answer
9 views

Empty cell reference when “Loading…”

I want to do a calculation with imported data from an HTML link. The data is imported every minute. There is a loading time and this ensures that the cells are empty during loading. Because my formula ...
0
votes
1answer
26 views

Dynamically creating chart in Google Sheets

I'm looking for a way of automatically generating a graph based on a constantly expanding dataset. The number of columns is constantly expanding (a program create a new column with new datasets for ...
0
votes
1answer
19 views

Nested list in draw.io?

I am using an embedded draw.io diagram in Confluence, and I can't seem to find a way to create a nested list. In Confluence, you can add markup, which does the trick, but draw.io doesn't seem to ...
0
votes
1answer
14 views

Cell values ​do not update

I want to update every minute a cell with data from a HTML link. The problem is that the value does not update unless I manually empty the cell or make changes to the script. I tried to add NOW() to ...
0
votes
0answers
9 views

Can I use something like websocket connection instead of gRPC for GCP speech recognition [on hold]

I am starting with a project - speech recognition of streaming audio using Google speech recognition. The website says, "Streaming speech recognition is available via gRPC only". Well, I am new so I ...
2
votes
1answer
29 views

Current value of compound interest

How can I calculate the current value of a sum deposited in a past date, with a fixed interest rate? For example, if $1,000 were deposited on 1/1/2000 in an account which pays a 3% annual interest ...
1
vote
1answer
28 views

How to remove “read” notifications?

Last week (I think), the mark all as read button vanished from my GitHub notification page, maybe for a few days. It eventually came back. But now, read notifications just accumulate in a dedicated ...
0
votes
1answer
15 views

Lost phone number and PayPal need verify by phone number

My account was locked I can't log on my account and my recovery option was my email only but I made my account when I still had my old number, and have no way of accessing that number, and can't send ...
1
vote
0answers
10 views

How can I avoid Reddit cropping my picture when exhibiting it to a thumbnail?

Please see the screenshot beneath. Reddit has obviously cropped the thumbnails for the numbered posts. How ought the original pictures be sized or edited to forestall Reddit's cropping? I link to the ...
0
votes
2answers
15 views

How to round float to bigger integer?

In Google Sheet, we can use ROUND() to round float to the nearest. like 5.2 = 5 5.5 = 6. What if I want it: 5.2 = 6 5.5 = 6. If the number exceeds by a decimal, then rounded off to +1. Any idea?
-3
votes
0answers
11 views

What is the meaning of this symbol [on hold]

A symboly a want to know what it means .(https://i.stack.imgur.com/ls9U1.jpg)
0
votes
1answer
16 views

Move ROW upon selecting a specific option from drop down menu

I am looking to use Google Sheets to keep track of my jobs. I have a spreadsheet set up so the status of a job is indicated by a dropdown menu. When a job is completed I would select "Closed" from the ...

15 30 50 per page