All Questions

7,015 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
20 views

Can a Dropbox folder be removed by people its been shared with?

If someone shares a Dropbox folder, can the person it's shared with remove the files or will they remain on Dropbox for the person who shared them?
0
votes
1answer
127 views

Google Sheets Conditional Formatting For Dates and a Blank Row

In Google Sheets I am trying to use conditional formatting to change the format of a column of cells if the date in that column it more that 14 days before today, AND if a separate column is blank. ...
0
votes
0answers
37 views

Another user is using the same Gmail id

I am using my Gmail since long time but I received emails which I not registered to while reviewing the emails another user is also using the same email account. What should I do about it?
0
votes
0answers
616 views

Can't find all my starred mail

If I use the search keyword is:starred Gmail shows me only the recently starred emails not the ancient ones. Using the keyword has: (e.g.: has:orange-star) doesn't find them either. How can I find ...
0
votes
0answers
235 views

Values of a sheet not updating

I'm trying to send data to another spreadsheet. To do it, I wrote a code which I've been using for months, but I'm trying to use the same code with another spreadsheet and suddenly the code stop to ...
0
votes
0answers
33 views

Google Sheets Script Apply update function to only the sheet names “Analyses”

I want to apply the script below to only the sheet called "Analyses" function onEdit() { var sheetName = "Analyses"; var s = SpreadsheetApp.getActiveSheet(); // Get spreadsheet name var ...
0
votes
0answers
27 views

Google Sheets: Get the user to draw in a box

So, it's kinda difficult to explain what I actually need here. I'm trying to create an electronic register for the school I work with, but they require some specific things. I added the date picker ...
0
votes
1answer
49 views

How to set a cell is a formula equal to another cell?

I have a sheet of formulas, and I want to duplicate it several times for different data set. If I use ='Sheet1'!A1 in A1 of Sheet2, it will copy the value but the formula. Is there a way to copy ...
0
votes
1answer
19 views

Syntax to for phrase match whilst excluding domains for search results

I'm trying to search Google for: "Alpha Beta" + "Charlie Delta" -excluding(pinterest.com), -excluding(facebook.com) What I'm trying to achieve here is to find results that contain the phrase "Alpha ...
0
votes
1answer
947 views

Gmail Older/Newer arrow buttons do nothing

When I'm in my Gmail inbox, I click the "Older"/"Newer" arrows in the upper-right of Gmail, in order to look at emails further back than 50, but nothing happens. It just says "loading" at the top for ...
0
votes
1answer
26 views

Alternate to nested if statements (alternate posing of question)

Sample Data Sheet: https://docs.google.com/spreadsheets/d/1EIQcpzwdaoNSKEPu-F1NCUOtEjS6Ez0P73dmotClT7Q/edit?usp=sharing The end goal is to have a Month + Year show up in a single cell, based on the ...
0
votes
1answer
117 views

Alternate to Nested IF statements

Goal here is to have the sheets search a row, then once it finds the first instance of >=0, return the cell value that contains the month+concatenate the value in the cell next to it (or any other ...
0
votes
1answer
44 views

How to express a range of values with nested if loops

This is a nested if loop I wrote in Google Sheets: Whenever I enter a value for B5 between 0 and 1, like 0.5, it says there is "no match". I think there is something wrong with the last section of ...
0
votes
1answer
77 views

Where to find a list of Google search operators?

I heard once that there are some search keywords or operators that google could use to enhance the search results. One of them was "NEAR"... Say if I search "make" NEAR "great again" it would ...
0
votes
2answers
445 views

How to remove duplicate rows based on a column (leaving first one out) in Google Spreadsheets

I am trying to remove duplicates from my Google spreadsheet file. Here is an initial table example A B C D HelloWorld1 2 6 41 HelloWorld1 4 3 5 HelloWorld2 6 46 6 ...
0
votes
0answers
44 views

Active Date Counter (Google Spreadsheets)

This is a weird request, but I wanted to see if anyone knew if what I'm asking is possible, and if so how to do it. If you take a look at the image below, you will see the following columns: Steam ...
0
votes
0answers
12 views

How to list all shared items?

Is there a way, a search string maybe, for Google Keep to list all my shared items (either shared by me or shared with me)?
0
votes
0answers
977 views

Data Validation Custom Formula

I'm trying to create a drop-down menu that is dependent on a previous cell in a row. The data coming in from a DB is M or F. Male or female. Then from what is displayed there I want the next column ...
0
votes
1answer
566 views

Arrayformula and Sum queries. Possible alternatives

I am using a sheet to list and summarise teachers absences and substitutions. Here's the worksheet Basically in the sheet "Substitutions" all absences and substituions are stored record by record: ...
0
votes
2answers
1k views

Is it possible to see Outlook from Office 365 in my Google Calendar?

I use Google Calendar as my main calendar but I'm now working at a company that uses the Microsoft Office 365 suit of apps. I like seeing all my calendars into one place so I can see whether I'm busy ...
0
votes
0answers
7k views

How to stop Facebook Messenger from nudging people to respond

On Facebook Messenger, sometimes the conversation is over and there is no need for the other person to respond. Still. I do get the following notification: We've let ____ know that you're waiting ...
0
votes
1answer
168 views

How to stop Google Docs from accidentally switching user accounts

I have been using Google Docs and Google Sheets for years together with the co-director of our company - switching between her account and my account when needed. Within the last couple of months I've ...
0
votes
1answer
410 views

Google Groups sends valid emails to spam / moderation from within our domain

How can I adjust the settings so all the users within our google groups domain have their messages approved to go through? Recently it seems the spam/moderation filter has been much more aggressive, ...
0
votes
1answer
53 views

Multiplication Sums across cells?

I know this isn't very professional but i'm very very new to google sheets and spreadsheets in general. So if I know that Tier 4.3 leather is worth 6 points in the contest, someone brings me 739 of ...
0
votes
1answer
1k views

Incorrect birthday in Facebook

How can I change/correct my birthday on my Facebook profile after it was set incorrectly? It's showing You can choose from one of the previous birthday you listed on your profile/timeline. But I ...
0
votes
0answers
65 views

YouTube subtitle auto translation

How to auto translate subtitles into another language for all videos, if the subtitles are available from sound auto detection? I know how to do it manually video by video, but I want a once and for ...
0
votes
0answers
61 views

No color in Vim while using Google Cloud Shell

I have recently just got started using Google Cloud Machine Learning. I want to use Vim as my editor and it's there alright but after installing my .vimrc which enables syntax highlighting I'm stuck ...
0
votes
2answers
114 views

A formula for importing specific data into another sheet

I need a function for column K of Sheet1, that says: "If the row of Sheet2 contains the same RID number as a row in Sheet1, then fill Sheet1 with the email address located in column K of Sheet2" ...
0
votes
1answer
223 views

Is it true that when I “add an account” in Google or Gmail, I can potentially increase the security risk a lot?

For example, if my main account uses a very secure password, and I never sign in using this user name and password inside of a game or mobile phone app. However, if I have a less secure account on ...
0
votes
2answers
438 views

Google Sheets Lookup For Nth Value

I am working on a spreadsheet that seeks to collate scores to a team. There is an input table where team and score start next to each other (see the example sheet linked below) into a table with each ...
0
votes
1answer
31 views

How can I view comments I have made to various posts from the one Facebook page?

I want to look back at comments I have made to a specific Facebook page for the past 3 years. It is a business's page, not a group. None of the efforts I have made searching the Activity Log have ...
0
votes
1answer
473 views

How to group certain data in a chart in Google Sheets

I'm creating a chart of a number of items (website traffic sources) and want to find a way to merge any rows that contain 'Facebook' in the chart. Here's the raw data: (direct) 67 192.com 0 bing ...
0
votes
1answer
21 views

Adding a cell in a sheet with a specific column number requirement that pushes cells to the beginning of the next line

I have a sheet that I need to only be 5 columns. I use this as a teaching calendar. Sometimes I need to add a cell in the middle if there is an activity that will add an extra day into my calendar (...
0
votes
1answer
495 views

How to filter and label messages as “INTERNAL-ONLY” and "EXTERNAL

I'd like to create a pair of labels. One would be "INTERNAL-ONLY". This label should match email threads that only include senders and receivers on the thread whose mail domain, @example.com, match ...
0
votes
0answers
42 views

Diverse fonts within a single draw.io UML entity

In the Entity Relation | Entity shape it is possible to mix in different fonts/styles within the same entity: The text style (CMD-E) is: strokeWidth=2;rounded=1;arcSize=10;whiteSpace=wrap;html=1;...
0
votes
1answer
954 views

How to set cell value based on 2 conditions of 2 other cells?

I've got a spreadsheet where people enter in values into columns A through H with I being a checkbox. On another sheet, it keeps a running total of all of the values of column E based on the values of ...
0
votes
0answers
28 views

Selecting relevant data in a large sample Google Sheets

I have 8 sheets with data from an experiment, each sheet has 2500 measurements. I want to select only 50 measures from each sheet to make a relevant analysis. Considering the values measured in each ...
0
votes
1answer
95 views

How to change email in Facebook account which is already in use with other account

Have a Facebook account for several years. Have a new email address and never changed it. On my phone I forgot my password and I opened a new Facebook account with my new email. Here's the problem, I ...
0
votes
1answer
146 views

Auto update field exclude header row

In Google Sheets I have a column that needs to be updated with the current date & time every time another cell in the same row is updated, but skip the top row which is the header. I found this ...
0
votes
1answer
2k views

In Google sheets, how to calculate elapsed duration between two cells, each containing date and time and display as days and hours

There is a built-in duration format, but Elapsed days is not an option. I want to display "2 days, 3 hours"
0
votes
2answers
50 views

Suming values in a column if value in cell next to it matches another cell

I'm trying to create a sheet to maintain a small inventory of servers. I created a segment where each type of component will be listed at the top. Below it is a series of copy-pasted chunks which ...
0
votes
0answers
14 views

Everyone in my organization call see *all* of my Google Sheets (spreadsheet) documents. How do I prevent default access from within my organization?

A few minutes ago, I hopped on a co-workers computer who was working with Excel for inventory tracking, trying to get her to use Google Sheets instead. After logging her in, I was (very) surprised to ...
0
votes
1answer
1k views

Facebook declined friend request wanted back

I accidentally hit the remove button on a friend’s request to Facebook and now he cannot add me again and I cannot even bring him up at all. What did I do? What can I do?
0
votes
1answer
4k views

Google Sheets macro for printing

I wrote the next macro, but isn't working. For example: I have a button on the sheet (invoerblad) for printing, the button must print the sheet (Printblad), and when the print action is finished, it ...
0
votes
1answer
94 views

Fine tuning a find and replace code

I have this code that works to find the word “Yes” and replace it with a 1. How do I also add in a line for it to find “No” and replace it with a 0? function fandr() { var ss=SpreadsheetApp....
0
votes
1answer
2k views

How to prevent duplicate entry in google sheets per row

So using the example data below, how can I prevent a duplicate entry with an informative message. The duplicate entry should be based on the row and not the whole sheet. So, if I was to add a second ...
0
votes
0answers
138 views

Search tweets and filter by maximum number of replies

I'm searching popular recent tweets with some keywords and I want to filter out the noisy ones (those with a lot of drama). Matching tweets with a lot of replies or by verified users tend to be ...
0
votes
1answer
33 views

How can you share a CRM-like phone book with Google Contacts?

We'd like to share contacts stored in Google Contacts with the entire company. We have 1,000+ client records and phone numbers that we'd like everyone in the company to have access to. We've been ...
0
votes
1answer
1k views

Archived emails still taking up space in Outlook

I am having some problem with the archive option in Outlook. My mailbox is almost full and I am archiving all the emails which are one year old. But, archiving is also taking up space. Do you know ...
0
votes
1answer
67 views

Need to trigger form submit when data is already populated in Google Sheet from another source

We have tried many thing to do a job basically we have a Google Sheet to collect information from Google Form once the form is submitted the data get inserted into the sheet and document studio start ...

15 30 50 per page
1
117 118
119
120 121
141