All Questions
31,152
questions
1
vote
1answer
659 views
Chart labels disappear (stays outside the graph area) Google sheets
Really count on your help here, as it seems like I tried everything already.
Take a look at the graph: the last value label disappears (the location is right on the inner border of the graph, so the ...
3
votes
1answer
1k views
How to show all my private Google Photos on a map?
Sometimes I remember places but not the time when I have taken a photo. Thus it would be super helpful to have all my Google Photos available on a map with location.
Then I could go to a certain ...
0
votes
1answer
32 views
Aggregate data with Sheets pivot table or graph
Please have a look at this google sheet here.
It has a pivot table with 3 columns:
A period (for example: 2016/01), a category and a number. I would like to do a chart that looks like this:
For ...
0
votes
1answer
19 views
Stop Instagram Group Message Requests Spam
Instagram has a huge spam problem.
My "Message Requests" inbox is continually filled with requests to join Group Messages, sent by fake "sexy women" profiles.
The only options are ...
1
vote
0answers
10 views
Adding together two amounts from different sheets on Google Sheets
I have a Google Spreadsheet, which has two sheets within.
I want to take an £ amount from Sheet 1, and a £ amount from Sheet 2, and add them together in Sheet 3.
Is this possible?
1
vote
1answer
364 views
How to combine dynamic columns in Google Sheets while retaining data in other rows?
I have a Google Form that asks people to fill out their name, gender, and then their size preference for shirts and pants. The form automatically outputs the 2 sizes in separate columns.
I want to ...
0
votes
0answers
58 views
How do I create a checklist in a slack message?
I'm trying to create a task list for myself in a private chat with my supervisor on Slack. I'm pretty familiar with markdown, and I thought that Slack supported it too. On GitHub, you can create tasks ...
2
votes
1answer
25 views
What is an account verification method suitable for a Gmail account used by more than one person?
Like many people, I have created a Gmail account that is used by a not-for-profit group I am associated with. I need to access this account regularly (even though most incoming mail is bounced ...
3
votes
2answers
2k views
How can I compare my local folder to the Google Drive Copy?
I'm having weird stuff happen where my local copy of my Google Drive folders seems out of synchronisation (despite G Drive saying it's sync'd). For example, the folder names are different and changing ...
0
votes
0answers
6 views
Questions about Office 365 Microsoft 365 Personal [closed]
I want to use the Microsoft 365 Personal from this link @ compare-all-microsoft-office-products-d.. but i have the following questions:-
From where i need to download the setup file for the Office ...
2
votes
1answer
10k views
Instagram notification: “X, who you may know, is on Instagram. Would you like to follow them?”
For the last month or so, Instagram has been frequently sending me the following push notifications:
USER, who you may know, is on Instagram. Would you like to follow them?
USER, who you might know, ...
0
votes
2answers
35 views
Filtering on gathered statistics adds dummy empty rows and fails anyway
I have a simple data set:
Pupil A Teacher A pass
Pupil B Teacher A fail
Pupil B Teacher B pass
And want to compute the following statistics:
Teacher pass rate
Teacher A 50%
Teacher B ...
0
votes
0answers
5 views
Business Admin account
We setup a Facebook business account in 2016 with a company email for a client and gave our client admin access to the account. We no longer have access to the email that setup the account. As ...
1
vote
0answers
3 views
Google Calendar meeting to alternate on specific days
Is there a way to make a meeting on (Windows Web Platform) Google Calendar be on Mondays, Wednesdays, and Fridays one week, then Tuesdays and Thursdays next week, then the following week back to MWF, ...
0
votes
0answers
4 views
News feed - mutual friends only?
If I become friends with someone on Facebook, and both of us only allow mutual friend to be seen, will only mutual friends get a notification on their news feed that we've become friends? I doubt ...
1
vote
0answers
9 views
Count number of times duplicates appear
I'm struggling with this one.
Column A has a students name.
Column B has the name of the exam they took.
If they fail the exam they will need to take it again.
I would like to know which exams are ...
1
vote
2answers
356 views
How does one set the default locale for each new spreedsheet in Google Sheets?
To change a spreadsheets locale one selects File > Spreadsheet Settings > Locale
There is a problem here in that one must make that change for each new spreadsheet created and not doing so causes ...
65
votes
17answers
132k views
How to prevent cut and paste data changing references in formulas?
Google Sheets has a feature where if you have a reference to a data cell in a formula, and you cut the data from that cell and paste it in a new location, the reference in the formula is updated to ...
0
votes
1answer
588 views
How do I set up this checkbox formula in google sheets? I'm getting #N/A error
I have a list of players in my league and next to each name is a checkbox to show if they are active or not. I set up a formula that checks each of the 12 weeks of game play to see if a player ...
4
votes
3answers
13k views
WhatsApp Web constantly disconnecting since I moved to new phone?
I got a new phone (OnepLus 5T) and since that on my home PC, WhatsApp Web constantly disconnects. No problem on my work PC. I use WhatsApp Web constantly and I find myself typing away but the messages ...
1
vote
1answer
21 views
Google Sheets formula working in only some cells
https://docs.google.com/spreadsheets/d/1nmMw2cfJkD5EgPHFjFYdO4PhJ822PfQhCcl3MYYnYJ0/edit?usp=sharing
I'm using a formula to search for a term within a cell and populate the correlating name into a ...
0
votes
1answer
36 views
Limit discount code to once per person
I've created a referral discount code, I will personally hand out the discount code when someone refers someone else and that person orders. I Only want that person to be able to use that code once. (...
0
votes
1answer
113 views
Show blank cell result if a cell is empty
I am trying to create a social media keyphrase strategy using keywords. I would like to know if Google Sheets could return a blank cell if one of the cells in the concatenate formula is blank?
5
votes
1answer
486 views
Show original links in Outlook 365
In the Outlook component of Microsoft Office 365, when reading an email that contains a link, the link is shown as https://<server>.outlook.com/owa/redir.aspx?C=<alphanumeric key>.&URL=...
0
votes
1answer
39 views
How can I migrate from Hangouts to the new Chat?
Some of my contacts have migrated to the new Google Chat which means now I need it installed. Some of my conversations were automatically migrated to Chat but some were not and others have trickled ...
0
votes
1answer
457 views
Script to copy range transposed to another sheet
I need to copy a range from the sheet 'Source' to the sheet 'Database' but transposed. It should be the range B1:T9, not the whole sheet. I need to do it with a script as it is going to be a database ...
0
votes
0answers
17 views
Remove duplicates but keep data based on several criterias
I have a database with thousands of rows and want to remove duplicates but also keep records from earlier in certain conditions.
Here is my problem:
Column A will have unique numbers for referals in ...
0
votes
1answer
26 views
Conditional Formatting based on table data
I'm having a table (in this example) everyone should write their name behind the Fruit he likes most.
I'm creating a dropdown box based on all people who wrote their names anywhere.
Based on the Name ...
33
votes
13answers
99k views
Can I change cell padding in Google Spreadsheets?
I don't want to stretch all rows and columns to make them more readable than they are by default...
4
votes
1answer
264 views
How to create multilingual posts in Facebook's new UI?
Facebook offers a language setting both for personal accounts and pages that allows writing posts in multiple languages.
In the new (now forced) UI, is there any way to actually use it while creating ...
1
vote
1answer
111 views
Gmail forwarded email that can be readily replied to the original sender?
A sends an email to B who finds the email is meant for C. So B forwarded the A's email to C by Gmail forwarding.
C receives A's email from B, types something and clicks reply. Now B receives C's ...
0
votes
0answers
3 views
Do those scroll down animations that Apple does of their products require powerful servers [closed]
And is it expensive to hire out one? I’m looking into doing it for a company I work for
0
votes
0answers
7 views
How to combine multiple ranges with getRange in order to clear the contents of specific cells?
https://docs.google.com/spreadsheets/d/1VsEvt2KnYGnlN_qHjkjPohVHF5MUqfyHD7tSk0VpkqA/edit#gid=1418057437
I use this sheet to enter data of patients in (Data_Entry) tab. Specific rows are titles and ...
0
votes
1answer
24 views
Can we use signed in email address of the user to auto fill the email text box in Google Forms?
I am creating a Google Form in which people will enter their names and email address and other details. I have done this previously but have noticed that most of the people uses their wrong email ...
0
votes
2answers
26 views
How do i use the query in google sheets to return N results from each tab
How do I use the query in Google Sheets to return N results from each tab.
So I have this formula:
=QUERY({sheet1!A2:D;sheet2!A2:D}; "select * where Col4>=65 order by Col4 desc Limit 3")
...
1
vote
0answers
6 views
How to calculate a conversion goal value for a large sample size?
I need to assign a conversion goal value for user actions made on a website.
I have already processed the data for a sample size of 210 paid invoices. The statistical analysis of the income values can ...
0
votes
1answer
29 views
Automatically update inserted sheets cells in Google Docs
I have a Google Doc which has linked cells to Google Sheets. I want to type a Script that automatically updates the document whenever the cells in Google Sheets are changed (it receives answers from a ...
0
votes
2answers
27 views
How to make the cells of query function results with borders that are dynamic according to rows/column numbers?
https://docs.google.com/spreadsheets/d/1VsEvt2KnYGnlN_qHjkjPohVHF5MUqfyHD7tSk0VpkqA/edit?usp=sharing
I would like to make the cells that have query results in All_Patients tab with borders instead of ...
7
votes
3answers
18k views
Automatically add borders around nonempty cells
I'm looking to have cell borders automatically applied when a cell is not empty. I thought I could use conditional formatting for this, but it doesn't seem to be an option.
0
votes
0answers
9 views
draw.io downloads file on every save
While creating a diagram in draw.io, pressing ctrl+S keeps downloading the file multiple times, how to set it so that it saves the work but does not download the file on every save.
0
votes
1answer
24 views
How do I advance the column instead of the row when I copy/paste a formula?
So pretty simple thing I am doing, pulling data from a form and putting it in a template.
=('Form Responses 1'!B3)
is what I am doing, which works fine for my needs, however when I copy and past ...
1
vote
1answer
3k views
Google sheets, scatter plot, multiple datasets, with datapoint labels
I want to create a scatterplot in Google sheets with multiple datasets, and yet still be able to add data labels for each data point. Additionally, it's two independent axis, which means some X values ...
0
votes
0answers
7 views
Jump to cell address mentioned in other cell
A1 shows address of last cell un a column (e.g. A572 or A577). Every time address will change if adding new row (there can be blank rows in between of rows with data).
I need a link in B1 to click and ...
0
votes
0answers
9 views
Database of Login URL's [closed]
I am looking for a method to extract or a database of Login URLs for popular websites. An example would be Nextdoor:
Base URL: https://www.nextdoor.com
Login URL: https://www.nextdoor.com/login
For ...
6
votes
9answers
79k views
How to use Google Sheets checkboxes with logic?
As of April 2018, checkboxes have been added to Google Sheets. They are utilized by going to Insert->Checkbox, which converts the cell(s) to checkbox form. When unchecked, by default the value becomes ...
0
votes
1answer
15 views
How do I save a Google Form?
I created a registration form on a Google Form and emailed it to be filled out. Now I want to save the form and the answers to the questions. How do I do that?
0
votes
0answers
6 views
One month ago we switched service providers and after that I was unable to be recognized by Google. How do I access my old account? [duplicate]
Last month we changed service providers for the internet. I believe they also changed the modem/router at the same time.
As a result Google no longer recognizes me and I can not access my old account. ...
0
votes
0answers
7 views
How to search Twitter but exclude hits on usernames?
When you search in Twitter from the web UI, tweets are shown if they match tweet content or usernames. So if I search for tweets about "fish" I'll find not only tweets that contain the word &...
0
votes
0answers
8 views
How to add exception to ClearContent in Google app script?
I am running this script to clear contents in selective cells but not the titles. But I had an idea to clear all contents of cells that don't contains specific value .
var sheet = SpreadsheetApp....
0
votes
1answer
15 views
Google Sheets - value in cell different from text
Within one cell, I would like the value of the cell to be treated differently from the text inside that cell. For example, I would like the cell to display "$148 (123 euros)", but the value ...