All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
15 views

Split choice grid or multiple choices in several rows on sheet

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 ...
1
vote
1answer
48 views

How to filter blanks in a table using ARRAYFORMULA

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 ...
1
vote
1answer
10 views

In Gmail auto remove label when email is opened

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. ...
2
votes
1answer
27 views

Searching cells and pulling values in Google Sheets?

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 ...
-1
votes
0answers
18 views

How to make the a checkbox of a cell undeletable?

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/...
0
votes
0answers
16 views

Searching at DuckDuckGo on a phrase wrapped in inverted commas

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 ...
1
vote
0answers
21 views

Google Sheets conditional formatting adapt to value

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 ...
0
votes
0answers
24 views

How to actively duplicate Facebook group to another group?

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 ...
1
vote
0answers
16 views

Change the text string of a cell based on whether or not previous cells are filled

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 ...
0
votes
0answers
12 views

Array formula-ing this formula breaks it…any ideas why?

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 ...
0
votes
0answers
8 views

Creating graphs from own formula

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-...
0
votes
0answers
44 views

Find average number of ranges including current date over a period

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 ...
-2
votes
1answer
70 views

Why can't I create a new account? [duplicate]

Screen Shot 1 These are the screen shots of the issue I am having. Google please fix this issue.
0
votes
0answers
14 views

How to import data when Google Sheet address changes each time the source data is updated

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 ...
0
votes
0answers
10 views

How can I delete a pivot table in Google Spreadsheets? [closed]

Is it possible to delete a pivot tablet without deleting the complete tab?
-1
votes
0answers
6 views

Cancel LinkedIn account [duplicate]

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 ...
0
votes
1answer
37 views

Facebook blocked person - can they see my reactions to posts?

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 ...
0
votes
0answers
34 views

Can I add multiple moderators in a Google Meet call?

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 ...
0
votes
1answer
31 views

Gmail dark mode

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 ...
1
vote
1answer
21 views

Pull Order Data from AliExpress

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 ...
1
vote
0answers
10 views

Restrict editors to only able fill today's date in data validation date - Google Sheet

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 ...
0
votes
1answer
32 views

Google sheets: summing cells in a column where the cell above contains a string

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 ...
0
votes
1answer
24 views

Google Sheets script not working if new script made for new sheet?

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?
1
vote
1answer
15 views

Nesting if statements

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&...
3
votes
0answers
21 views

“You have reached your limit of named versions” when naming a version

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 ...
1
vote
1answer
54 views

How to combine these formulas in one conditional formatting rule

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: =...
0
votes
0answers
3 views

Geolocation in firefox does not work [migrated]

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 ...
0
votes
1answer
25 views

Query using starts with

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**) ...
0
votes
0answers
7 views

Can I prevent Google Tasks from redirecting in Chrome?

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 ...
0
votes
0answers
5 views

Google Docs table of content, ported to word, then exported as pdf

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 ...
0
votes
1answer
18 views

IF, THEN formulas in Google Sheets

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 ...
0
votes
0answers
12 views

In Google Docs, can I hide other users' from the other users?

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?
0
votes
0answers
17 views

Setting up multiple validation criteria in Google Sheets

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 ...
0
votes
1answer
15 views

How do I see an event in different time zones in Google Calendar?

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 ...
1
vote
0answers
12 views

What happens to my laptop after adding Google Play?

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.
0
votes
0answers
5 views

Background-size: cover; leaves a blank space at the bottom of the page [migrated]

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 ...
-1
votes
0answers
7 views

Getting an error on Importrange function while importing data that contain around 900,000 cell

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

Is it possible that Google Docs does not show page breaks on the screen?

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?...
0
votes
0answers
16 views

Is it possible to search ONLY INBOX by default?

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 ...
0
votes
0answers
11 views

Can I search MARC records on the Internet Archive?

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 ...
0
votes
0answers
23 views

Script For Google Sheet With Changing Names

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 ...
0
votes
0answers
7 views

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?

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?
0
votes
0answers
20 views

Gmail calendar invites from autoforwarded email

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 ...
0
votes
0answers
9 views

Google service account: Delegate Domain-Wide Delegation of Authority to impersonate only ONE user [migrated]

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 ...
1
vote
1answer
14 views

Gmail threads that skipped inbox come back to it

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 ...
0
votes
0answers
24 views

Split rows into separate columns

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/...
1
vote
0answers
63 views

How to use unofficial features in Facebook group post editor?

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. ...
0
votes
0answers
5 views

Does Google Scholar give personalized results?

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 ...
1
vote
0answers
13 views

Is it possible to view reddit as normal forum website?

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. ...
0
votes
1answer
24 views

What data is collected by YouTube after pausing watch and search history?

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

15 30 50 per page
1
3 4
5
6 7
622