All Questions

Filter by
Sorted by
Tagged with
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 ...

15 30 50 per page