All Questions

I have a form that I want to work as follows: The person will answer a question (text box) with an ID and another question (which can be a choice of multiple answers or a multiple choice grid). What I ...

I want to copy down filter formula using Arrayformula. I also gave a hand to copy down add-on but it's not giving required result. Here is a picture of an example sheet: I am filtering the non blank ...

I would like to create a "unread email" label to filter what has been unread vs read. I am successful in creating the filter; however the unread label sticks with the message indefinitely. ...

sorry for the vague title but I'm not sure how exactly to describe this. I've created a spreadsheet and used the Coinmarketcap API to pull lots of data, here's the relevant part: From another sheet I ...

Is there a way to make checkbox undeletable.. you can check/uncheck but you cannot delete. Or show check box whenever a specific cell is not empty. I found this post https://stackoverflow.com/...

At DuckDuckGo, inverted commas are advised when you need to search on an exact phrase. But if the engine can find few or no pages that contain the phrase, it tries to "help" you by bringing ...

I'm currently working on a Google Sheet which tracks hourly performance, the layout is basic which is hours against units completed. The conditional format I already have in place works for a time ...

I'm a member of Facebook Group 1, and I would like to duplicate (archive) all the posts (including videos, units, images) to another group automatically as and when new posts are given. Is there an ...

I am working on a spreadsheet that tracks the overall pipeline for video production for a group of volunteer filmers and editors. Being on as a volunteer manager myself, I wanted to create a ...

I have a spreadsheet with SheetA and SheetB. I'm trying to pull into SheetA some of the columns of each row in SheetB where the date in Column I of SheetB is earlier than today. This formula on a ...

We are all familiar with the Y=mx+b Now I have the following values that I want to use in this formula to create a graph in Google Sheets: m = slope k = exponent b = y-intercept (vertical shift) c = x-...

I take notes in Google Sheets of the dates when I buy and sell stocks. I would like to know the average number of companies I own stock in on a day. I have one column for the buy date, and another ...

Screen Shot 1 These are the screen shots of the issue I am having. Google please fix this issue.

I can export data from my ERP system to Google Drive. But each time that I export the data a new sheet is created with the same name. For example I export a "purchase report" in January, and ...

Is it possible to delete a pivot tablet without deleting the complete tab?

My LinkedIn account was created using my work email address and I left there 3 years ago. Of course I no longer have that email to use nor can I remember the password either. How can I cancel my ...

If I block someone on Facebook he cannot see my posts, I can't see his and we cannot message each other, but what about my posts/comments/reactions on other people's posts or pages? Is the block ...

I created an event using Google Meet. Can I add someone else as a moderator to the event (I will be the presenter and I am the event owner)? I could not find any way. I am not sure if this feature is ...

Is there a way to read the body of an email (in Gmail) in dark mode? I am not referring to Gmail themes, where it makes the background dark, but want the body of all emails dark. My eyes get strained ...

I'm looking to pull purchase details of an order using the order number or other identifying order characteristics (such as phone number) without requiring the end user to login to (or provide ...

I have used the data validation date > 'valid date' so that in the range of cells I want, will already show the calendar drop down. However, would like to ask for guidance on how I can restrict the ...

I'd like to sum the cells in a column where the cell above contains a string. For example, sum all the cells where the cell directly above contains the string "Transport". For example, in ...

I already have a script which is working fine in on sheet. But when I want a similar script working in another sheet. It won't work. Has anyone experienced such a thing before?

I'm trying to nest the following IF statements. In order to have a different word returned according to what word is in the other cell. =(IF((D2 = "Your Spouse / Partner"), "my partner&...

I didn't realize this, but Google Sheets (and I'm guessing Google Docs) as well seems have a limit on the number of named versions you can save? The bigger issue is that I'm not able to find any ...

I am checking if column S is empty & Column Q="Consultation" then I need to set a rule in a cell to make conditional formatting in cell A1. So these are my steps: Step 1: in X column: =...

This service, thanks to which website can tell from where are you browsing… this stopped working for me. Since a month I have almost constant problems with geolocation. It worked for couple of days ...

A little help to do the following: I am good with Queries however, can't find if it is possible to do the following: =Query(range, "Select * where B begins with (**want a range from A to Can**) ...

I have been using the embed URL suggestion provided in this question: How to use Google Tasks on the web standalone? However, when I re-launch the tasks "app" the URL no longer contains the ...

So I downloaded a report template from Google Docs and it has a table of content shown below. The problem is that when I export the file from my word to a pdf, it turns to this monstrosity, How do I ...

I have a table with grade levels of students in column C and the total duration of time earned (sum of D3:F3) in column H. In column J, I want to calculate a percentage of the total time earned based ...

I want to share a Google Doc with a team for editing, at the same time I want to hide their emails and names from each other (they all don't know each other, freelancers). Is there a way I can do so?

I have a list of metrics that I want users to prioritise by ranking their top 20 ensuring that there are no duplicates. There might be a simpler way to do this, but what I've come up with is to use ...

I have an event in my Google Calendar. I'm using the web version and the app on my Android phone. It has a start time and an end time in my time zone. I would like to see this event in different time ...

According to this Google link, one can add Google Play to his/her desktop/laptop. Could someone tell me what happens after adding? I checked my laptop and didn't notice anything different.

So I am a beginner at coding with HTML, CSS and JavaScript. The problem I have is only CSS I believe. So I have a background image and I want it to cover the whole page. So I set the CSS property ...

I have data around 900,000 cells and when I trying to import using importrange function it showing me an error "RESULT TOO LARGE"

I use Google Docs to keep some notes, and would 99% or 100% not print it out ever. So I hope to see the pages on the screen just as one continuous scroll, or without the page breaks. Is that possible?...

I know that I can use in:inbox to search only emails in my inbox. I am migrating from Outlook and I find it extremely frustrating to constantly have to type "in:inbox". Is it possible so set ...

I noticed that some books on the Internet Archive have a MARCXML record. MARC records usually have subject headings. Is there any way to search them? I tried putting some things in the custom field ...

We have a Google Sheet and the names of the Sheets will change based on the date. So, we will have a string of Mon 2.15 Tue 2.16 Wed 2.17 Etc... The sheets are copied and then a new name given to ...

Created a route on My Maps. Like to use it with Google Maps to get a turn-by-turn voice navigation as I drive. How?

I have two email accounts, one on Gmail and one on Outlook. My Outlook email is auto-forwarded to my Gmail account. When I receive a calendar invite email sent to my Gmail address, the event is ...

We need to access Google Calendar API with server application to create the events and invite the attendees. Google recommends to use service account for the applications. The main problem here with ...

I have set up a number of Gmail filters to skip inbox, mark as read, and apply a label, but while they generally work I regularly find threads matching the condition in my inbox and unread. How do I ...

I have data in one column as follows: website.com/US/x=abc website.com/US/x=pqr website.com/BO/x=avgdf website.com/BO/x=jeid website.com/RO/x=klhg website.com/RO/x=dfg website.com/CA/x=rfd website.com/...

Recently formatted text cannot be pasted into Facebook group post editor. It will be converted to plain text. This is inconvenient if you have a well formatted text, and now have to reformat it again. ...

More specifically, would any two Google Scholar search results entered at the same time with the same search criteria return the same results in the same order? If not, where can I learn more about ...

Reddit has a horrible design as a website. I do not understand how it became so popular then. But it often happens that Google searches leads to some reddit thread which looks very relevant for me. ...

Well I know YouTube collects a lot of my data from what content I played to when and where I played but my question is what data does YouTube collect when I have paused watch and search history? I ...