All Questions

Filter by
Sorted by
Tagged with
0
votes
2answers
266 views

How to escape the Google Adsense login loop

I am trying to get Google Adsense for my blog. I complete the form and click "Save and Continue" and it goes back to the homepage. I click "sign in" and it asks for my email and... surprise surprise......
0
votes
0answers
4 views

Aliases in Google Groups

Can I create aliases and em addresses in plain Google Groups (without using the G Suite) If not, how can I achieve the same objective of creating em addresses for "help", "support" or "info" ...
0
votes
3answers
52 views

Migrating from flickr to google photos

With flickr putting the kibosh on unlimited photos with the free account I'm wondering if there is a known automated way to migrate thousands of photos from my flickr account to google photos. I've ...
0
votes
0answers
4 views

is the string 'TRUE' can cause a problem in a query?

I am getting information from a external workbook whit the following query. =QUERY(IMPORTRANGE("1eOxqZX9078WcGlR-vxVs4njjHrM9U7cH0TDxGTp60Tw","core!A:E"),"Select Col1, Col2 where Col5 ='TRUE'",0) I ...
0
votes
1answer
15 views

Conditional formatting skipping colors after the same large value

Looks like the conditional formatting skipping large formula because of the same large values. Help me please how can I get the order what is on the picture in the column "What I would like".
12
votes
4answers
47k views

How can I clear the channel history in Slack?

How can I clear the channel history? The channel in question is a private channel created by me and is not (yet) archived.
0
votes
0answers
12 views

Visualize Data that updates dynamically

TLDR: How can I create a bar chart that updates the x-axis daily? The end goal is to have a chart that shows a side by side comparison of goal completions performance for each source of traffic. Here ...
0
votes
1answer
8 views

Conditional formatting for passed dates

I need the formula to highlight a cell if the date in that cell has passed. Cell U3 had 6/29/19 today is 7/1/19 - I want to have the cell turn red after 6/29 to alert me to follow up.
0
votes
1answer
17 views

How to set a cell is a formula equal to another cell?

I have a sheet of formulas, and I want to duplicate it several times for different data set. If I use ='Sheet1'!A1 in A1 of Sheet2, it will copy the value but the formula. Is there a way to copy ...
0
votes
1answer
12 views

Table of contents has one page wrong

I have a large (92) page document in Google Docs. The entire document (including the table of contents) has page numbers. The Table of Contents is showing the first heading (letter of intent) as to ...
0
votes
0answers
3 views

Facebook Business Manager Active Request not showing up

When I request to access a Facebook Page it states: "Your Business Manager Already has an active request on this Page. You'll see a notification if the request is accepted." But then when I go to my ...
0
votes
0answers
7 views

Is there a code i can input into my url that will allow my you tube video to continuously play without timing out? like auto refresh or auto reload

when trying to run a live video for display purposes using you tube it times out overnight. Is there a code i can input into the url that will allow the video to play continuously without stopping? ...
0
votes
0answers
111 views

Google Drive not indexing searchable PDF

I have a fully searchable PDF. The PDF was scanned and then converted to text by Fujitsu's ScanSnap Manager #iX500 (W). For those who want all the details, here's the info from Document Properties: ...
0
votes
0answers
5 views

Remove Count column by repeating rows in Google Sheets

I have a worksheet, 'wi', in a Google Sheet such that: Count | Entry | Description -------|-------|----------------- 2 | Foo | yada yada 3 | Bar | blah blah blah On ...
0
votes
1answer
120 views

ImportRange not pulling in Dates from first sheet in correct format

I'm trying to pull in a date cell from one sheet to another with an importrange function: =iferror(query(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UClhpev01z-...
2
votes
1answer
603 views

Combining data from two columns to one (in separate rows - not comma separated) and removing blank lines

I have a Google Sheet which receives information from a google form. I would like to collate some of this data in a separate sheet (within the same document). I would like the new sheet to combine ...
0
votes
2answers
29 views

View only few non-continuous columns

=FILTER(Matrice_data;Matrice_nom=G2) Pretty straight forward. I type a name in G2 and I get all rows with this name. My problem is this one: the "matrice_data" contains many columns, like 30. I want ...
3
votes
2answers
4k views

Summing top three values in a column from a Google sheet

I have a Google Sheet with a variable number of data rows. I would like to sum the three highest values from a certain column, but they won't necessarily be in the top three cells. An empty cell ...
4
votes
1answer
2k views

Display the contents of a named range elsewhere in the sheet

I have a sheet like so: A B 1 W X 2 Y Z I have the range A1:A2 named as "Column1". I want to display that range elsewhere. Now if I wanted to display it as a row, I know =TRANSPOSE(Column1) works. ...
0
votes
1answer
5 views

How to view a list of comments on a pdf in Google Drive

I am trying to view a list of all comments, including the resolved comments, in Google Drive. For Google Docs, there is a button to view all of the comments, including resolved ones (https://...
0
votes
1answer
11 views

Consolidate columns from a dynamic range into a single column in Google Sheets

How can Google Sheets take a range of multiple columns and rows and stack or consolidate all the non-empty cells into one column? For this case I want non-unique cells. Also, each cell in the range is ...
9
votes
3answers
12k views

Can you do a UNION SELECT in a Google Sheet?

I've got a Google Sheet linked to a form which collects replies from three different people on the same subject using the same form and editing three times. This creates a sheet which contains three ...
1
vote
1answer
25 views

How 'AND' and 'OR' can be combined in advanced twitter search operators?

I want to find tweets including one of these three possibility in search results: "AAAA" and "BBBB" or "AAAA" and "CCCC" or "AAAA" and "BBBB" and "CCCC" I mean that AAAA should be in tweets ...
0
votes
0answers
2 views

How to avoid invitations from my own calendars in Google Calendar?

I have added a separate calendar (not separate account) in Google Calendar to manage children's events. Now, when I create an event there, I receive an invitation to this very account. It makes very ...
1
vote
1answer
62 views

How to manage images in Gmail signatures centrally

We use Gmail for business. We'd like the same image to appear in all staff email signatures. From time to time, we need to change the image: We'd like to be able to update the image once, centrally;...
0
votes
0answers
5 views

Mark all line if checkbox is true

I will give an example: I have checkboxes in B3:G3. This is a checklist, I want to change the background color to green for A3:H3 if B3:G3 boxes are checked. Can someone please tell me how to do ...
0
votes
1answer
198 views

How do I show all channels I am part of from multiple Slack workspaces?

We have 2+ workspaces in Slack Enterprise, and I see the shared organizational channels on the two tabs I have open to Slack. However in each tab I see the workspace-specific channels. I know it's ...
0
votes
0answers
7 views

Showing top 5 most frequent values and counts of each from a data range

I have a google sheet with text strings listed down columns D through G. I want to, on another sheet, display a list of the top, say, 5 most frequent unique values from the first sheet in descending ...
0
votes
1answer
173 views

Is it possible to link one calendar to another inside the same form?

For example I am creating a form for a custom media production order for a radio station. I have figured out how to get the calendar to skip to three days ahead (the earliest a customer's audio could ...
0
votes
1answer
91 views

How do I make my PayPal account have the features of a credit card processor and not just a PayPal button?

How do I make my PayPal account have the features of a credit card processor and not just a PayPal button?
-2
votes
0answers
11 views

Tool to extract data [on hold]

I'm doing an application using Vue.js and Laravel. I want to extract data (comments and star reputation) from a website like eBay or Amazon, as Fakespot does. Does anyone have an idea of a tool that ...
0
votes
0answers
2 views

Copy a page from one space to another

If a confluence page is copied from one space to another then will the Space owner or page owner will know about it via notification?
0
votes
1answer
17 views

Create case sensitive vlookup with array based search key

I have the following case sensitive vlookup formula however search_key must be a single value here, and I need to search an array of keys. =ArrayFormula(INDEX(return_array, MATCH (TRUE, EXACT(...
0
votes
1answer
12 views

How to playback 4K Youtube videos in 4K quality in Google Chrome on a 4K display?

I have Chrome, version 76 as of writing this, on Windows 10, all updates installed. I have 2x 4K displays, one Asus MG28U and one Samsung U28E590. I have set my Nvidia 1060 graphics card to display ...
0
votes
1answer
9 views

How to hide placeholder events for invitations not replied to on a google calendar I'm subscribed to

I'm subscribed to my wife's google calendar. She got some spam calendar invitations, and she reported them as spam, however, the invitations are still showing up for me as placeholder events on her ...
3
votes
1answer
2k views

Facebook account that only redirects to Facebook for Business

I have a similar question to this one: Facebook opens "Ads Page" instead of regular homepage after login And I'm asking again because the solutions mentioned in that question no longer ...
2
votes
2answers
14 views

Multiple IF-statements in a single cell - checking long list of results

I have a Google Sheets where I enter all the results of my beer pong matches with friends. I'd like to see my amount of wins/losses with certain friends. This can be done with =IF(AND(B2="Won",E2="...
1
vote
1answer
2k views

Validate age (>18) Google Forms?

I working on this form that has to be filled only by those over 18 years old. I was wondering if is possible to ask for the date of birth or the age in the first question and if is over 18 then the ...
-1
votes
1answer
11 views

What is the bot in Facebook for Developers' Object Debugger? [on hold]

Do you know what bot that read websites' metadata from Facebook for Developers' Object Debugger? Perhaps the name is shown in wireshark, but since I have no root access to any server, I'm unable to ...
-1
votes
1answer
29 views

Does search engines like Google or Bing search through all web pages for a single query every time?

Here is what I imagine would happen when I type in a search query in Google or Bing: The search query is converted into a vector through some pre-trained machine learning models. The vector captures ...
0
votes
0answers
19 views

YouTube watch hour policy when someone watches my two video channels at the same time, device, browser

Let's say someone have 2 YouTube channels and one person had subscribed to both of these channels. And now he/she is opening these two channel's video at the same time, using same device and browser ...
0
votes
0answers
6 views

Why is design important when developing an app? [on hold]

I would like to know for an college essay why design plays a big role when developing an application and what factors make up a good app that doesn't overflow the audience
0
votes
1answer
382 views

Google sheet - get crypto currency price from Cryptobridge Exchange API

How can I retrieve only the price from this API in a Google spreadsheet? This is the API ticker - https://api.crypto-bridge.org/api/v1/ticker For example, if I use this function =INDEX(IMPORTDATA(...
1
vote
1answer
34 views

Show full URL on Google Search results?

I would like to see the full URL disclosed. Is there any way to achieve this? Maybe using a custom script or browser extension?
0
votes
0answers
6 views

Can I be removed by another LinkedIn designated admin

I am the creator of my company page and for better management I want one of my employee to be designated as admin. As I am reading through the articles it seems he can remove me from admin anytime. Is ...
2
votes
1answer
429 views

Auto reply to email address contained within message body

Infusionsoft sends my company email referrals using the same template each time with the same subject line. Unfortunately an auto-response would go to the Infusionsoft email, not the person who ...
0
votes
0answers
4 views

How to add a multilangual description to Facebook videos?

I would like to post a video on my Facebook page with its description written in English, Spanish and eventually a third language. How to do that? I know Facebook has such an option for posts and ...
1
vote
1answer
2k views

How to remove notification for suggested friend on Facebook?

How to remove notification for suggested friend on Facebook? Example: do you know john? you can add him as your friend. its giving me notification on the person that I do not know.
1
vote
2answers
4k views

How to validate a date in Google Forms?

Google Forms include the possibility to perform some sort of validation on user input for checkboxes and text; the functionality is available very easily both via the UI and the API. Unfortunately, it ...
0
votes
1answer
12 views

How to filter after parsing csv values contained in Google Sheets cells

I would like to be able to match all cells in column A (titles) that have one of the comma separated values in column E (Key Search Terms). This will involve at least two steps. 1) Parse each of the ...

15 30 50 per page