All Questions

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

Select All Columns Where Cell In Columns Contain A Word - Google Sheets

I am looking for a query formula that will allow me to select all columns (entire column) that contain a specific word within the column. You can see a test sheet here: https://docs.google.com/...
2
votes
2answers
6 views

I was sent a google form (link) and can see the senders answers

I was just sent a link by a colleague to a google form. I can see that they ran a test of the form with "dummy' answers. Can the sender change this so that others don't see their responses in the form?...
1
vote
0answers
2 views

Loss of admin on our business page

The person who was listed as the admin on our FB business page left the company and is disgruntled. Is there any way for us to add someone as an admin without their their help?
2
votes
1answer
14 views

Google Sheets Query: Making the selected column depend on formula

I would like to use a normal QUERY with where operating in the usual way where A = 'Speed' but with the selected column being determined based on a formula. Specifically, I want to return only the ...
1
vote
1answer
14 views

Twitter For Websites : Full Profile Header

On an old website that I built I embedded my entire Twitter Profile Header ( cover / name / avatar / statistics ) into the footer of the page. I'd like to do the same but I have no idea how I did it ...
0
votes
0answers
13 views

Alternatives to Jira, free all in one app

Question Just question, is any good alternative to JIRA? I found this. https://www.workzone.com/blog/jira-alternatives/ But with these conditions. Possibility to install app on my own server. Web ...
0
votes
1answer
13 views

Google Apps Script slow applying sheet/range protection

I am building a set of spreadsheets using Google Apps Script. Each spreadsheet is being created with a set of 10 sheets. Now that the all seems working, I have added some code to protect ranges, ...
-1
votes
0answers
9 views

Google Script to delete responses based on specific URL the zapier will send

I'm new to this script thing. And honestly I don't have much of a background in coding. I'm looking for a script that will delete multiple rows based on the URL zapier will send to the googlesheet. ...
0
votes
0answers
45 views

Need help, please I need to recover my gmail account

I've tried and tried for the last 2 years to get into my old gmail account can someone please help
1
vote
2answers
21 views

How can I filter a list based on whether it contains any of a list of substrings?

I have a list of Japanese words. I want to produce a formula to filter that list, based on a filter list of substrings (kanji characters) which I'm looking for. So for example, say my filter list ...
2
votes
0answers
12 views

Why am I receiving access requests on my “Public on the web” Google drive folder?

I've linked a variety of Google Drive folders containing public documents to my organization's website for ease of updating. These are all set to "Public on the web" as seen here: So clearly not ...
1
vote
0answers
7 views

IMPORTRANGE, where range shifts often, to different spreadsheet

What I have: a client information spreadsheet that contains company information including their last order date following the status of their account (active/follow-up). What I need: the last order ...
2
votes
1answer
13 views

URL recording after the URI in google Analytics All Data view?

In my Google analytics account, All data view is recording URL after URI. When I click on the page it shows not found. Can anyone tell me how to fix it?
0
votes
0answers
12 views

How do I get to line for mobile pages

When you need to jump to line when writing the mobile page, click the button to jump to line
0
votes
1answer
15 views

Apply protection to multiple sheets in a Google Spreadsheet

Ive got a Google Spreadsheet with 50+ data tabs, and 5 Summary tabs at the end. The 50+ data tabs all have the same column headers. I want to apply protection to the all these data "data tabs" to ...
1
vote
1answer
22 views

How can I comment out parts of a formula in a Google Drive Spreadsheet?

How can I comment out parts of a formula in a Google Drive Spreadsheet? In PHP you can comment a line of code using a # what is the syntax to do the same in a Google Spreadsheet? I want to use this ...
0
votes
0answers
15 views

Google Sheets Array formula

=ArrayFormula(IF(ISBLANK(Input!$B4:$B)," ",(INDEX(Input!A4:A, SMALL(IF(COUNTIF($A$3,Input!$B4:$B), MATCH(ROW(Input!$B4:$B), ROW(Input!$B4:$B)), ""), ROWS(A6)), COLUMNS(Input!B4:B))))) The result is ...
1
vote
1answer
9 views

Select a value from range

I'm trying to put the category number (1..5) into E3 based on the value in F3 being in between the From (B) and To (C) range. For instance in the example below F3 contains 19.3 which is between 12.5 ...
1
vote
1answer
12 views

Google Calendar: Invited to recurring event, how to mark as free?

If I'm invited to an recurring event on Google Calendar, how can I mark myself as "free" for the whole series and not only for individual events? If I click on one event in the series and edit my ...
1
vote
0answers
25 views

Audit log for logins google account

Facebook provides a very useful audit log that shows login attempts made, 2 factor authentication confirmations and logins and logouts. Google's Myaccount screen shows logged in devices but does not ...
1
vote
1answer
9 views

Countunique if cell in same row in other column is not empty

Is there a way to calculate the amount of uniques you have in a column with respect to another value not beeing empty. For example: A 3 B X 5 Y A X 3 Y This should then result in the answer ...
1
vote
0answers
11 views

How to forward non-user emails to external gmail?

I have a contractor outside of my company that I'd like to forward emails to using an e-mail from my domain, but I don't want to create and pay for a user account under my G Suite domain. Therefore: ...
1
vote
0answers
6 views

How can I include ! in named ranges or change the cells in a named range easier in Google Sheets?

I'm not 100% sure what i'm doing here as I'm pretty new to this, however what I am trying to do is have ranges with the same name on different sheets where I get "SheetX!Range" as the name of the ...
0
votes
0answers
14 views

How can I manage responses showing up in my Gmail sent mail folder?

When I send an email using Gmail and the person responds, the response shows up in my sent mail, rather than my in box. How can I fix this?
0
votes
0answers
12 views

How do I force a Facebook post to show a large image rather than a thumbnail image?

Pulling my hair out over this one. I've got a Drupal 7 site and I add a link on facebook I would like images on facebook to be the size of the post rather than a thumbnail. Any suggestions? Using the ...
1
vote
0answers
13 views

Google wants my phone number. I don't have one

I'm trying to create a new google account and it wants a phone number. I don't have a mobile phone number. What should I do? I need an account and don't have the time to get a new phone and pay for it ...
0
votes
0answers
27 views

I have tried everything

I have been trying to get into my Facebook account and it keeps telling me that I have to have my second authorization code which I cannot access anymore so what do I need to do I have been sent ...
2
votes
1answer
24 views

Unable to send emails

I am getting the following error message when attempting to send emails: Error The address "essentialphysicaltherapy.net" in the "To" field was not recognized. Please make sure that all ...
1
vote
0answers
2 views

cognito forms Calendar calculation for every other wednesday

I a using Cognito forms to have people register for an event which occurs every other Wednesday. How can I get the calendar function to not allow registration for any other days of the week (Mon, ...
1
vote
0answers
8 views

How do I display a topic at the top of the messages in a google group?

How do I display a topic at the top of the messages in a google group? The action menu used to include an item for it.
0
votes
0answers
15 views

Google Sheets: Generating a table with vertically merged cells based on a categories and sub-cats

Given a table of Categories: ---------------------------------- Category | Type | SubType | ---------------------------------- cat1 | T1 | S1 | cat2 | T2 | S1 | cat4 | ...
0
votes
0answers
8 views

How to receive YouTube community notifications

Some YouTube channels have Community tab. But I don't receive notifications when creator makes new Community post. I turned on bell to receive all notifications. Is there some workaround for that? ...
0
votes
0answers
45 views

Downloading entire archive of past messages of a Yahoo Group

I am an owner of a now-defunct Yahoo Group. Apparently, it's been announced that Yahoo Groups is to remove all content December 14 2019 and I would like to save the archive of messages to that group....
0
votes
0answers
9 views

How to tell which are the newest notifications on YouTube?

I can click on the "Bell" icon on the YouTube page to see new notifications. Sometimes, however, it shows a "9+", meaning there are more than 9 new notifications. It could be 12, or could be 23. So ...
0
votes
0answers
12 views

Why does Gmail and Google Maps keep crashing in Chrome?

Everything that is run by Google just seems to keep crashing in Chrome, which is a little ironic when you think about it, because Chrome isn't crashing. Gmail crashes all the time and Google maps has ...
0
votes
0answers
4 views

Is there a way to always insert modulus/remainder into Google Calculator?

If I type 5 % 4 then it successfully outputs 1, however, it doesn't work for complicated inputs. If I insert (1264798654*2164987643) % (2^32) it treats the left side as a percentage and multiplies it ...
0
votes
1answer
10 views

How do you reference the entire google spreadsheet into another?

So, I have two workbooks, one with multiple sheets(W1) and one empty(W2) I want the empty one (W2) to have all the data (all strings, chars, and SHEETS) that (W1) has. IMPORTRANGE only takes data ...
0
votes
0answers
4 views

Youtube force language of auto-generated subtitles

It happens to me countless times. Just for an example, https://www.youtube.com/watch?v=djzGkEWzCwM the language options of the closed captions only have one auto-generated option, which is "Korean (...
0
votes
0answers
14 views

Loading Data Error Query with Importrange Gsheet

I am trying to use QUERY with importrange function to fetch custom data from another spreadsheet, it worked for a while but now it through loading data error consistently. if I refresh the sheet it ...
1
vote
1answer
18 views

Color or group the same kind of data in a Google Sheet graph

I have the following data: | Test Combination | C-Score | Memory | Reasoning | Verbal | |------------------|---------|--------|-----------|--------| | ABCD | 13.70 | 10.51 | 13.04 |...
0
votes
0answers
10 views

Delete Facebook acct COMPLETELY

My profile still shows up after I deleted Facebook acct., but not pics after using the same way my boyfriend used to delete his acct., and it worked 100% for him. And I'm still getting Facebook ...
0
votes
0answers
22 views

Reset the password for the Google account [duplicate]

I have forgot my password and now I want to recover my Google account, but I don't remember the old password, mobile number. How can I recover my Google account and how can I set new password? Please ...
0
votes
1answer
25 views

Google Sheet Humongous Bottleneck Caused by this FILTER function. How to fix?

I have identified by trial and error that this one FILTER function is causing a massive "Calculating Formulas..." delay in my Google Sheet. This is the ONLY cause of the delay I have tested it ...
0
votes
0answers
13 views

How can I make a auto sorter that has inputs and color changing?

I really wanna some sort of Google sheet auto sorter, lets say for example I have some information like a person name, and I want to input this data into the google sheet into lets say Cell A1, and ...
0
votes
0answers
5 views

Where can I view when an event was created in the Microsoft Outlook web interface (OWA)?

Where can I view when an event was created in the Microsoft Outlook web interface (OWA)?
0
votes
0answers
3 views

Youtube embeded webcam live streaming on website - same link

Is it possible to embeded a webcam live stream into a website using the same link? I mean that whenever I create a new webcam live stream, the same streaming url is activated. I know that this can ...
0
votes
1answer
6 views

What happens when multiple people edit a multi-page form?

Imagine I have a multi page Google form and the "edit after submit" option is enabled. Imagine we have a 3 page form with the following text questions: Q1 Q2 Q3 The form is submitted with blank ...
1
vote
0answers
5 views

Move the input caret to the search bar of Amazon without using mouse?

When I have navigated to amazon.com, is there anyway to move the input caret to the search bar without using the mouse, other than pressing the tab key six times?
0
votes
0answers
19 views

Query with sums and 2 columns on the left

I have problem with the query: =Query(Raw_Data!J$2:$BL,"Select J, Sum(U),Sum(V),Sum(W),Sum(X),Sum(Y),Sum(Z),Sum(AA),Sum(AB),Sum(AC),Sum(AD),Sum(AE),Sum(AF) where J contains 'CUS' and (AL='1-Revenues'...
0
votes
1answer
9 views

Adding elements to Mindmap/ Horizontal tree

This may be a basic question, but I could not figure it out even after spending a while on it and the documentation. How do I add new elements/nodes to a mindmap/horizontal tree? The blue arrow ...

15 30 50 per page