All Questions

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 ...

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 ...

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 ...

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 ...

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?

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 ...

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 ...

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 ...

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 ...

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 ...

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, ...

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 ...

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 ...

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, ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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. (...

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?

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=...

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 ...

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 ...

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 ...

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 ...

I don't want to stretch all rows and columns to make them more readable than they are by default...

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 ...

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 ...

And is it expensive to hire out one? I’m looking into doing it for a company I work for

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 ...

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 ...

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") ...

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 ...

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 ...

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 ...

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.

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.

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 ...

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 ...

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 ...

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 ...

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 ...

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?

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. ...

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 &...

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....

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 ...