All Questions

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I am confused by the technical differences. When to use what exactly? Appreciate any guidance!

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

Spouse changed everything for my Gmail account and now I can't get in

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

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?

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?

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

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

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

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

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