All Questions

Filter by
Sorted by
Tagged with
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
7 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 ...
0
votes
0answers
2 views

Reddit filterline custom filters

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
7 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 ...
0
votes
0answers
4 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 ...
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 ...
0
votes
0answers
11 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
528 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
38 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 ...
1
vote
0answers
12 views

How to solve the issue of my query results of in my sheet?

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

So I have this question in one of my interview practice problem and I'm not that familiar with Java, so how do I do this? [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 ...
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
0answers
14 views

Google Spreadsheet: 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 ...
1
vote
1answer
854 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
51 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 ...
12
votes
1answer
77k views

WhatsApp link with phone number doesn't open WhatsApp's web app

What I am trying to do is to open a link in the WhatsApp web app, it works in Chrome but in FF and IE, doesn't. Firefox: this is the link https://api.whatsapp.com/send?phone=[phone number], when the ...
0
votes
1answer
17 views

How to apply a conditional formatting rule on the last row of similar cell value across one column?

I am trying to conditionally format the last row that has similar values of sorted data based on country column. In this example of my test sheet, I'm sorting the data from A3:C18 by placing the ...
2
votes
2answers
4k views

Is there anyway to find the time stamp of a YouTube thumbnail?

A lot of channels are generating views from clickbait thumbnails. Is there a way to scan a video beforehand and determine the timestamp of the thumbnail, if it is even in there?
55
votes
4answers
151k views

How do I Log out of Google Accounts, one at a time?

I volunteer for many organizations, earning me several Google accounts to manage. The Multiple account sign-in feature built into Google is wonderful, except when I click Sign out, its signs out of ...
4
votes
2answers
13k views

Insert a linebreak in a Google Spreadsheet cell on an iPad

How does one add a linebreak in a cell using an iPad. I tried wrapping text but it wouldn’t work any other solutions?
0
votes
1answer
8 views

How to reset Workflow Actions that weren't run due to a GitHub incident?

GitHub Actions were unavailable for some time and PRs created in this time did not trigger any actions. After the functionality was restored the PRs did not pick up the status correctly and don't even ...
-2
votes
0answers
4 views

unable to Attach documents in Google forms [closed]

i have created a Google form and have mandated attachment of a document but it is not being allowed
1
vote
2answers
2k views

Google Forms Duplicating answers to Google Sheets

I have a google form to capture order information, When the user captured all order information, it pushes to a google sheet so we can keep an order history of who ordered what, when and how much. ...
0
votes
1answer
21 views

How to let particular advertiser purchase a pre roll ad for our videos?

We have a local company that wants to run a video pre roll campaign on all of the videos on our channel. How do we set this up? Do they have to create an AdSense account first or something? Can we ...
0
votes
1answer
30 views

IF/AND functions from multiple cells

Would anyone know how to fix this problem? I want cell A676 to categorize based on info from 2 cells C676 and D676. Basically IF the word "Paypal" is in cell D, AND there is a specific ...
1
vote
0answers
8 views

Is there a good open-source blogging system out there written in NodeJS that comes with GUI?

I've been working with this company for a few years. When we first started, I wrote their website using PHP and their mobile app using Cordova. They needed a blogging system and so since we were using ...
1
vote
0answers
9 views

Why can't I access someone's Instagram account if they have not blocked me?

Instagram now deletes all comments and likes from a user that is blocked. So I can't find or access the Instagram account today that I gave some beneficial comments to just a few days ago. From ...

15 30 50 per page
1
2 3 4 5
622