All Questions

Filter by
Sorted by
Tagged with
2
votes
1answer
36 views

How to count Hours and Minutes in one cell

I want to count # of hours worked by subtracting the Start & end time in 1 cell (as per my comp template) ( 9am - 6pm) .( No I can't alter the template to put start & end in different cells/...
0
votes
2answers
30 views

Google Sheets interpreting dates from CSV in a weird way

I'm opening a csv report in Google Sheets. The Google Drive preview shows the dates like this: When I open this file in Google Sheets the dates now look like this: And if I try and convert the date ...
0
votes
1answer
14 views

How to prevent accidentally deletion of spreadsheets

I am using google drive sheets every day and today i deleted a folder by mistake so please share me the ways how to prevent the sheet deleting it
-1
votes
1answer
48 views

Software that would convert Google documents to .docx

Is there a way to convert a Document that you create in Google Docs to .docx or .odt? Edit: To be more specific, I am looking for a software that would be able to archive this.
0
votes
0answers
15 views

Import button greyed out in Google Sheets menu for unknown reason

I'm trying to import a .csv file into my Google Sheet like I've done myriad times. However, occasionally, the Import button in the menu is greyed out (see screenshot). Reloading the document doesn't ...
0
votes
1answer
14 views

New users vs returning users never decrease

You would expect that the number of 'new users' would decrease over time, and the number of 'returning users' would accumulate. This should be the case because in our marketing we only target 'known' ...
1
vote
0answers
56 views

remove all my gmail contacts that not delivered

i sent numbers of emails for all my gmail contacts and my friends this is google message that i recieved for some of them that old or not exist yet: The email account that you tried to reach does ...
0
votes
0answers
13 views

2 questions about multiple groups of rows

there's two small things I'd like to do, but can't seem to wrap my head around. I've succeeded before but in an "unsophisticated way" and I know there must be a better way to do this. I have a ...
0
votes
1answer
24 views

How to make Checkbox=TRUE if SUM of cells in its row are more than a specific value

I have a row of numbers and those in columns C through F are added together in G. I want H to be a checkbox that is TRUE if the SUM in G is greater than 29. I think I use the SUMIF formula but couldn'...
0
votes
0answers
7 views

Randomly distribute the sum of a number between cells in Google Sheets

I'm planning out a Kickstarter campaign and I'm making a sample tier list in google sheets to see if I can get the funding needed with minimal backing. I've randomly added in numbers to the estimated ...
0
votes
0answers
12 views

How do I search inside of text file and have output on Google Drive?

Let's say I have a text file named Names.txt, it contains that lines: John Jane ohio mark newzelland mark zucherberg hell When I search "mark" or just mark it tells me it is inside of Names.txt. ...
0
votes
0answers
23 views

Google app script on how to create a pdf from the data received from an html form of its spreadsheet and send the pdf file via email

Google app script on how to create a pdf from the data received from an html form of your spreadsheet and send the pdf file via email - I would like to create a pdf file from the data recorded on the ...
1
vote
1answer
30 views

How can I trim white-space and replace trimmed space with a semicolon?

I am working on a project where there are hundreds of eCommerce product features separated by white-space. The number of spaces differs from row to row. I need to reformat all these cells with ...
1
vote
1answer
30 views

Google Sheets - Identify if one of many matches any in an array

I am trying to determine if an array of values in Google Sheets has any matches within another array of values. The data set is constantly expanding, so I want to use an Arrayformula to handle it. ...
0
votes
0answers
8 views

Unable to add new users in Google Ad Manager (ex:DFP)

All, as the administrator I'm unable to add a new user under the Admin > Access & Authorization tab in Google Ad Manager (ex: DFP). (Role > Partner Portal user). I have this error: Unable to save....
0
votes
0answers
10 views

How can I calculate the remaining loan amount at a given year in a single formula?

If I have a loan like the one in the "Amortization Schedule" here where the following is the load terms: interest_rate 4.5% NPER 24 PV 50000 ...
1
vote
0answers
18 views

Google sheets increases the height of a cell after return key is pressed to exit a cell

As the following image demonstrates, pressing the return key on a cell, after entering content, randomly increases the cell height. Sometimes this does occur (1 in 10ish) and sometimes it doesn't. ...
0
votes
0answers
15 views

Google Sheets: Filter Row if it does not contains HYPERLINK

I have a sheet which has a column where most cells contain a hyperlink, I am looking for a way to find cells which do not contain a hyperlink and delete those rows. Filter by condition -> Text ...
0
votes
0answers
14 views

Multiple formulas (?) in one cell

I'm putting together a Google Sheet for my daughter's Girl Scout cookie sales. I have a cell for "Proceeds per box". If she sells 250 or less, her proceeds are $0.75 and for 251+ the proceeds are $0....
0
votes
0answers
16 views

Change the colour of a cell based on if the checkbox below an identically named cell on another sheet is true (Google Sheets)

This is something I've been struggling with for a little bit and don't know if its even possible. I would expect this to take likely hundreds of separate condition formatting rules but wanted to see ...
0
votes
1answer
22 views

Why is this custom formula conditional formatting rule triggering wrongly?

In this (partially redacted) sheet I want to set rules based on the Q column: Q is date-formatted but clearly is not blank, so why is the formatting being applied? I've tried other rules like exact ...
0
votes
0answers
19 views

Combined Columns into single

Very new to Google Sheets and i was wondering whether its possible to achieve this. I have a data set displayed as such: Want it presented in the following format: Any help on this would me much ...
0
votes
0answers
41 views

Email everyone in a google group except myself

We have a group of techs in our company. As the list grows it becomes harder and harder to remember who to add. We want a group of emails (e.g. techs@mycompany.org). Whenever one of us wants to send ...
0
votes
0answers
20 views

What's the difference between an album, animation, collage & photo book?

I am confused by the technical differences. When to use what exactly? Appreciate any guidance!
0
votes
0answers
21 views

Copy sheet to new spreadsheet folder in selected folder

I know that I'm asking a simple question, but surprisingly, I haven't been able to find where my exact question has been asked before. Here's the situation: (This is method 1) I've got a sheet within ...
0
votes
1answer
36 views

Facebook feature: Help people start a conversation with your Page

The Facebook feature in Settings/Messenger called "Help people start a conversation with your Page" is no longer there, so I can't turn it on or off. But when people visit my page, the Messenger pop ...
0
votes
0answers
11 views

How do I get Chrome (or Firefox) to autofill Saved Passwords?

I have my college password saved in both Chrome and Firefox, but when the login page appears, it doesn't autofill. I have to click the password box (or the username box on Firefox) and then my ...
0
votes
0answers
16 views

How to see how many videos I liked on YouTube, if I have more than 5000

I want to know how many videos I liked on YouTube. I don't want to see what I liked exactly, only the total of all liked videos. The problem is when I go to "Liked videos" I see that is has 5000 ...
0
votes
0answers
6 views

Can't post to any subreddit, not even r/help

On Reddit, I cannot post anywhere, not even r/help. When I click on the post button it loads for about 15 seconds and then goes to my profile's previous posts page here. I can still post comments, ...
0
votes
1answer
17 views

Synchronize headers and footers across multiple documents

We have a number of templates in Google Docs that all use the exact same header and footer. Every time we update the header and footer, we have to manually go through each template and update its ...
2
votes
0answers
44 views

Spotify: How to get truly random playback using playlist shuffle?

When playing Spotify playlists in shuffle mode (currently the only available mode for free accounts, while as a paying premium customer I can play in the original playlist order or in a pseudo-...
0
votes
1answer
25 views

How do I report a scam on Hangouts?

A so-called Army orthopedic physician scammed me out of a large sum of money on Hangouts. His original email was usarmydavid1234@gmail.com. He said he needed help sending his consignment box from ...
-1
votes
0answers
151 views

Why do Gmail developers not allow blocking email addresses?

In Gmail it is possible to "block" an email address by automatically transferring all their emails into SPAM folder (the emails won't get deleted). For me, this is not blocking. I ran various search ...
0
votes
0answers
11 views

Facebook page Post comments are not diverting to messenger?

Whenever I am trying to do private message of any facebook page post comment, i am getting this error, anyone else facing the same issue?
1
vote
0answers
19 views

How can I add a thick borderline after a certain text in Google Sheets?

I'm trying to modify my Working Hours Spreadsheet; What I want to do is add a thick borderline after each Sunday, so I can better identify each individual Week of the Month. Here's the Masterfile ...
0
votes
0answers
14 views

How to only get results containing exact matches of my search terms on google?

I'm trying to search for results related to my research technique called "Hi-C". My current search term is "T cell" +"Hi-C" the plus sign and quoting should force an exact search, but still many pages ...
0
votes
0answers
16 views

Google Sheets Work Schedule

On a protected sheet can permission be given to individual cells across ranges, for example allow Sheet1!A3;Sheet1!D3;Sheet1!G3 etc.? to be edited by John and Sheet1!B3;Sheet1!E3;Sheet1!H3 to be ...
0
votes
1answer
43 views

How can I prune attachments out of gmail to save space?

Example: I sent a music track to my sister. I don't want it using my Gmail quota which is getting close to max. One option is to delete the thread. Less than useful. One option is to delete just ...
0
votes
0answers
101 views

Why has Google Docs' grammar check suddenly become so wonky?

I've used Google Docs for journalling for the past year, and never really noticed issues. Recently however, I've noticed that it's been bringing up blue lines under the strangest things. Of course, I ...
1
vote
1answer
11 views

Google Sheets - Include a Comparison Trend Line

I am using google sheets to record sales data and have a separate worksheet for each calendar year. For each calendar year I include a couple of charts which illustrate things like track dollar value ...
0
votes
1answer
14 views

Public vs private tweets on Twitter

Is it true that if I tweet to @user1 and @user2 then this tweet is public? But if I go to @user1's profile page and click "Tweet" to the user, then it is a private tweet? What if I go to @user1's ...
0
votes
0answers
241 views

Spouse linked my gmail address to his and when i try to recover my username google cant find account

Spouse changed everything for my Gmail account and now I can't get in
1
vote
1answer
36 views

How to populate column with every unique instance in another column

I have a bunch of data on users and the user's name will be in Column A. The user's will always be unique, but they may show up more than once. I want to have another 2 columns (say E and F) that ...
-1
votes
0answers
28 views

Automatic backup on Google Drive folder on same account

I've added an account on Google Drive with a folder used as a server for our documents. Is there a way to make a scheduled backup/sync of that folder in another in the same account?
0
votes
0answers
14 views

Repeat event x days after y-th day every month in calendar

Let’s say a credit card bill is generated at 20th of every month, and due 19 days after. Is there any way to create a repeat event of the due day?
0
votes
0answers
10 views

Onlyoffice document server substitute

Is there an ARM supported substitute for OnlyOffice Document Server? (Word, Powerpoint + Excel functionality delivered through a web browser)
0
votes
0answers
13 views

How to remove the VIDEO TAB on my FB Business Page?

Can someone please tell me how to REMOVE THE VIDEO TAB on the FACEBOOK BUSINESS PAGE? I am not using videos for the next while so it seems senseless and can be annoying to my customers if I leave it ...
0
votes
0answers
51 views

Facebook page still showing

My account is deactivated but my Facebook page is still showing on Google Search. Could you kindly remove the page permanently?
0
votes
0answers
9 views

Why none of my mp3's purchased from Amazon play correctly on my Samsung Phone using the Google Play app? How to Fix?

How do I get my Google play music app to play my mp3's purchased from Amazon correctly? There is a continued skip throughout all the songs. Very annoying. Music that I have not purchased from Amazon ...
0
votes
0answers
20 views

How to convert channelid to username

I created a YouTube channel about 3 months ago and now I forgot my Gmail account username for that channel. Is it possible to convert the YouTube channel id to username/userid? I do remember my ...

15 30 50 per page