All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
25 views

Comparison Column Chart

I'm trying to make a chart in Google Sheets to compare how much two people have paid towards something. What I'm looking for is the chart to have several cost categories (groceries, dining out, pets, ...
0
votes
0answers
4 views

Chrome extension doesn't show number of users

I have built and published my chrome extension. I am not sure why it doesn't show the number of users who installed it (currently 4). Is there a certain limit that the number of users should reach for ...
1
vote
0answers
20 views

Adding together multiple Sum Filter or Sumifs with multiple conditions across multiple sheets?

So I have a budgeting spread sheet. I have an overview page that I need to link to a "Checkings" sheet and a "CC-Chase" sheet. To calculate the amount spent on a specific category ...
0
votes
0answers
2 views

Specific youtube video not playing

I am having a big problem, whenever I search for this video, it says Sorry, the Wayback Machine does not have this video (xxxxxxxxxx) archived (or not indexed yet). can you please fix this specific ...
1
vote
1answer
66 views

How do I find the Facebook Platform Application ID?

How do I find the Facebook Platform Application ID? The Drupal Metatag module is asking me for the "Facebook Platform Application ID". I've no idea where that ID is located. Suggestions?
0
votes
1answer
786 views

Google reverse image search in a specific country

I want to use Google to search for a specific image inside a specific country (IP)! Using http://images.google.com/ gives me results for all sites, but I can't sort results by country. It would also ...
2
votes
4answers
5k views

CPU vs. RAM for Google Sheets

I use Chrome and Google Sheets with large spreadsheets which have IMPORTRANGEs, VLOOKUPs and pivot tables. I am looking to improve speed. For this use which has the bigger impact CPU or RAM? Perhaps ...
-1
votes
2answers
400 views

Move sent Gmail message to draft

After sending an email, it moves to sent and does not stay in drafts (makes sense). Sometimes I need to send someone a 'draft' email, meaning they are not the end person but someone I need to check ...
10
votes
4answers
6k views

Can I disable comments by default on my YouTube videos?

Comments are unfortunately always automatically enabled when I upload a video to YouTube either via their website or iPhoto, but more often that not I later manually disable comments for each uploaded ...
0
votes
1answer
6 views

Is there a way to detect with Google-Apps-Script whether Google Sheets is opened from Android app or from desktop browser?

I have a small script that I have further reduced for the sake of this question. Basically it implements the onEdit function in which it may show an alert (using SpreadsheetApp.getUi().alert()) and ...
1
vote
0answers
19 views

Need help with google sheets, sending info from one sheet to another, but allowing the second sheet to be modifiable!

Guys for example I have this master sheet, which has one specific column that I want to filter by. for example it has different job titles, and I want that to be on another sheet so I can create "...
0
votes
1answer
15 views

google Script insert as HTML

If I have the string: var text = "Altman, R. (1992). Sound space. In R. Altman (Ed.), <em>Sound Theory Sound Practice</em> (pp. 46–64). New York: Routledge."; How can I insert ...
6
votes
3answers
3k views

Youtube: Move “Watch later” to new Playlist

I want to add all search results to a playlist in youtube. The quickest way to do this seems to click the "watch later" icon on every video (1 click). Adding each video to an individual playlist is ...
-2
votes
0answers
18 views

So I have this question in one of my interview practice problem and I'm not that familiar with Java [closed]

A Java program to that performs the following tasks: Accepts integer input (one integer at a time) from the user. Inserts the given integer into an integer array of size 10 in ascending order. If the ...
0
votes
0answers
6 views

What is the best Javascript python interpreter for what I am working on? [closed]

I am making a website to help teach users Python. What service can I use to run custom Python functions (no other libraries)? For example, the user inputs down(2) on my website, this service takes ...
0
votes
0answers
4 views

Google Voice Text Messaging: Selecting recipient failure

Failure confirmed on Firefox, Chromium and Safari browsers. When sending text messaging a dropdown menu of recipients is provided, however, clicking on the recipient no longer selects the recipient. ...
1
vote
1answer
14 views

How to solve the issue of sorting numbers in 00-00 format?

https://docs.google.com/spreadsheets/d/1VsEvt2KnYGnlN_qHjkjPohVHF5MUqfyHD7tSk0VpkqA/edit#gid=1418057437 I have this sheet that I enter all data of patients in (Data_Entry) tab and I want these data to ...
0
votes
1answer
7 views

Google sheet sum minus sum gives small number when should be 0

I'm doing accounting in google sheet so my column C and D are all numbers with 2 decimal points. But somehow when I subtract sum of debit and sum of credit, the result is a small number when it should ...
0
votes
0answers
2 views

Reddit filterline custom filters [closed]

How can I access the filterline of reddit in order to use custom filters on the posts? Can you help me?
11
votes
2answers
44k views

How can I hide my name on a shared Google Doc?

Just realized my name is clear as day on my documents that I'm sharing with strangers. Meanwhile they all show up as "Anonymous %animal%". How do I make it so my name doesn't show up?
0
votes
0answers
14 views

is there a formula that will allow me to pull data from one google sheet tab to another based on a if contains conditional

I have a list of start dates in one tab in Google sheets. I want to pull only the start dates that reflect 2021 into a new tab, as well as pull the corresponding info for that entry from the other ...
9
votes
4answers
26k views

How can I group a pivot table into weeks or months?

In Microsoft Excel, in a pivot table, you can right click on the dates - while within the pivot table, on a date and select group (from the drop down menu) - then you can choose different groupings, ...
2
votes
2answers
5k views

How to export text from Google Doc as HTML?

I have body of text in a Google Doc containing a large number of links. I need to get the text – and all the links – into my client's CMS. Unfortunately, it seems Google Docs no longer allows users ...
-1
votes
0answers
12 views

How can I copy and paste equations on Google Docs?

I tried to copy and paste mathematical and chemical equations from websites to Google Docs but for some reason, the formatting looks weird. How do I ensure that the mathematical and chemical equations ...
0
votes
1answer
532 views

Create a custom DateTimePicker in Google Sheets

In a sheet I have a column to enter a datetime value that would later be checked by a script to create a trigger. I would like to set a picker in that column to ease selection and avoid errors. I ...
0
votes
0answers
2 views

How do I BATCH download ALL Facebook videos that are under the GUIDES section?

How do I BATCH download ALL Facebook videos that are under the GUIDES section (previously known as UNITS) of a private group which I'm a member(not admin)? I'm already logged in to FB via JDownloader ...
0
votes
1answer
7 views

How to convert a rational number like 1.6 to the higher integer number?

How can i convert the number 1.6 to 2, 3.8 to 4 and 1.2 to 2. Any number that has0.0 to be converted to the next number . Round will round the number to the nearest integer but I want to the higher ...
1
vote
2answers
13 views

How to test apps script addon

I have created an addon using this guide. code.gs function onOpen() { SpreadsheetApp.getUi().createAddonMenu() .addItem('Start', 'showSidebar'); } function showSidebar() { const ui = ...
2
votes
2answers
40 views

How to sum a range columns from another google sheet

I get this daily data consumption spreadsheet report from a vendor that looks like this userid feb1 feb2 feb3 . feb29 u1 100 34 23 . 4 u2 0 24 ...
0
votes
1answer
25 views

How to use google apps script to validate a cell?

I have been trying to write this code to validate a range of cells. If the cells contain the text "true" then set value as "Incorrect Data" else "DD Data" /** @OnlyCurrentDoc */ function myFunction() ...
6
votes
1answer
554 views

Does Google Authenticator work with personal accounts?

Is it possible to set up Google Authenticator for my personal accounts or is it only available for Google Apps accounts?
1
vote
1answer
57 views

Is there any way to automatically upload things to Google Photos but NOT Google Drive?

I'm using Google's Backup and Sync tool to automatically save photos from my hard drive onto the cloud. The problem is that I want my photos to go into Google Photos but NOT into Google Drive. In ...
0
votes
2answers
847 views

Match word in a cell with a column of words

I need to match a word to a list of words and then insert the category name in the cell next to it. Eg. I will in Column A type a list of words like Apple, Red Apple, Coke, Carrot The formula must ...
0
votes
0answers
11 views

Jump to a cell, address of which is located in another cell

A1 has a formula that shows the address of the last row with data (A958, A959). I need to make a link in A2 to the cell address of A1. (eg. If A1 has Value C456, I need to jump to Cell C456 by ...
1
vote
1answer
3k views

How to combine FILTER with TRANSPOSE in data validation custom formula

Cells A2, C2, and E2 contain the data I want to make my custom list for data validation. Cells B2 and D2 have data I don't want in the list (just text - "vs" - in them). So, I'm trying to use the ...
1
vote
1answer
881 views

Anonymous voting on google forms

I have this situation: A group of people must vote using Google Forms. Their voting choices must be anonymous. But, they don't have gmail accounts and we would like to collect who has voted and who ...
1
vote
0answers
12 views

How do I create a list of ranked numbers in Sheets––one that will adjust if I change a number?

I have a column of numbers 1-50 in a Google Sheet, which are a ranking list for a different column of fifty items (items are ranked relative to one another, so 1 is the best in the list and 50 is the ...
0
votes
1answer
1k views

Using checkbox to copy data form worksheet A to worksheet B

I am trying to use the new Checkbox function in Google Sheets. I can't figure out how If I click the checkbox in A9 on Worksheet 2 I want the Text in A10 and the $ amount in A11 to be copied to cells ...
0
votes
1answer
23 views

Sort a column by name with query between tabs

I am pulling information from one tab to another and I believe this is why it will not allow me to sort (because it is not sorted in the original tab). The easy solution would be to sort that tab. ...
1
vote
0answers
8 views

How do I specify a consistent interval for a date-range axis in a Google Sheet Chart

I have a Google Sheet with a set of deposits and withdrawls and the running balance. I have added a chart to the sheet, so I can visualize what the balance has been over time and when deposits or ...
0
votes
1answer
784 views

Add dynamic questions in Google forms

I am using google forms to punch orders in my Google Sheets. Although I am facing a challenge as the number of products is variable. For example Question 1: Item Name Question 2: Quantity I ...
0
votes
1answer
148 views

Sharing Blogger blogs in Facebook shows blog title and article title

I have a blog on blogger (blogspot), and when I want to share an article on facebook, the name of the link (the gray fild under the image) appears as: [Blog Name]: [Blog Post Title] I would like to ...
0
votes
1answer
15k views

How can we find friends or import contacts in Twitter (2020)?

At the moment, my Twitter account only has 24 followers. I plan to increase that by finding and inviting my friends/connections in Gmail or other social networks. It is a very common approach in other ...
8
votes
2answers
6k views

Is it possible to block Facebook's sponsored ads using uBlock now that they separate “sponsored” text onto different divs?

If you inspect the word "sponsored" on Facebook's sponsored posts, you'll see they break the word up across multiple elements to bypass uBlock Origin and other blockers. Is there a way to still block ...
-1
votes
1answer
189 views

Don't allow same answer in Google Form

So I have a problem where I want to use google form for data collection for few different teams. At google form the first question is to type in the item number (6 symbols) and there is no duplicates ...
1
vote
0answers
6 views

Does the Internet Wayback Machine API support adding a link to scrape?

I can go to the Internet Wayback machine website and add a link to the site for the Wayback spider to scrape; is it possible to do this using their API as well? From what I've read you can only pull ...
1
vote
1answer
856 views

Looking for a “weighted average if” functions in Google Sheets

I am familiar with the =AVERAGE.WEIGHTED function in Google Sheets, but I'm wondering if there's a way to add an IF in there, like =AVERAGEIF. I have a baseball spreadsheet, with the following ...
1
vote
0answers
14 views

Facebook: How to successfully paste formatted text into a group post?

On Facebook, when creating a new post to be posted into a Group (as opposed to onto a standard personal or company page), Facebook allows you to add some simple formatting to the post. If you ...
0
votes
1answer
52 views

How Do I Combine Gmail Search Operators?

I was attempting to create a filter which would delete all emails alerting me that a website updated its terms or privacy policy. This is the search filter I'm trying to use to accomplish that +...
10
votes
3answers
4k views

In Gmail, can I show only unread emails for a label as a Section

I'm using the Priority Inbox, and want to add a Section with only unread messages from a label. The section dropbox allows me to select a label, but shows all messages in the label (including read ...

15 30 50 per page
1
2 3 4 5
622