All Questions

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

Extract Information from Webpage onto Google Sheets

I've been trying to grab some data from this webpage: https://seekingalpha.com/symbol/BZUN. I want to import the follower count (under the add to portfolio button) into a cell on google sheets. For ...
0
votes
2answers
437 views

Google Sheets Formula for Attendance Records

I have a very overwhelming and large attendance sheet of 350+ people that I need to keep track of. I have a very simple attendance record of 0 if you weren't there and 1 if you were. For one of our ...
0
votes
1answer
2k views

Google Apps Script: print, open or download as PDF a Google Doc?

I have created a Form that will run a script on submit to dynamically generate a google doc. So far so good. What I miss is a way to: Print the document (open the printing preview in browser) ...
0
votes
1answer
112 views

Why YouTube shows two different names?

I created my channel with the name of 'enthusiastic ladka' and everywhere it shows expect my YouTube main title name. Why it is different? Here is the screenshot of my problem.
0
votes
1answer
533 views

Batch change song names in Google Play Music

I have a substantial amount of user-uploaded songs on Google Play. A good portion of these have ".mp3" at the end of the file name. Is there any way that I can batch remove this ending from all of ...
0
votes
2answers
16 views

Query function problem

When using a query function that selects two columns from another sheet, I get two results in one cell. It looks like it doesn't respect the initial structure of the selected data. Any idea, please?
0
votes
0answers
131 views

How to automate bulk upload on Hootsuite with images?

I want to do bulk posts with the csv uploader on Hoot Suite. However, there is no clear way to automate the image uploading for Instagram and Facebook. All of the examples I have found require the ...
0
votes
1answer
129 views

Gmail on Chrome Browser - Change on 2/19/2019

I use several Gmail accounts, and for years I've been able to access each inbox separately on my Android phone. A few days ago, Google in all it's top-down command non-wisdom changed this so I have ...
0
votes
1answer
118 views

Why are certain sensitive words in rap songs on YouTube censored?

I just noticed it in one song, thought nothing of it, and then in another, it was really obvious as well. For reference, in this one: https://www.youtube.com/watch?v=85sC2xLIViU E.g. the words nigga ...
0
votes
1answer
134 views

Filter all email using plus addressing

I am looking for a way in gmail (technically google apps for business I think) to filter all email which is delivered to an address using plus addressing. I want to tag all email to firstname.lastname@...
0
votes
1answer
522 views

Gmail displaying images even when it says “Images are not displayed”

How is this possible? Doesn't the circled part of the screenshot below seem false given that there is then an image in the body of the email? UPDATE in response to comment: When I inspect the HTML, ...
0
votes
3answers
378 views

How to return what is missing from a 2 column list comparing against all possible combinations of 2 single column lists?

Sample data: A B C D E F 1 name handed in students assignments name missing 2 a 1 a 1 b 2 3 b 1 b 2 ...
0
votes
1answer
180 views

Show insignificant zero

I want, when I write a Number in a Cell, that the zeros are still visible. In a Google sheet. e.g. when I write 1.050, or 1.0 or 1.2000 there should stay exactly that. Not 1.05; 1; 1.2 or something ...
0
votes
1answer
149 views

How to correctly show contact names in Gmail

Most of my contacts are businesses, I was able to find the field "Archive as" in my Google Contacts which helped in organizing them. However when entering a contact in Gmail, it still shows the ...
0
votes
2answers
623 views

How to get price of specific cryptocurrencies at specific times?

I have an assortment of cryptocurrency transactions over time. Various currency pairs at various prices. I need to figure out what the price of those currencies was, in Bitcoin, at the time that I ...
0
votes
1answer
615 views

Getting data from another Google sheet that isn't in the same order

I have a very basic knowledge of deeper functions of Google sheets and solving this has been a little bit of pain in the butt so far. I have a spreadsheet A column A contains ID column I that has ...
0
votes
2answers
804 views

Protect spreadsheet against duplicate data and sheet addition/deletion

There are some people that love to troll and spam my Google spreadsheet with useless info. Google Sheet lacks granular permission restriction. I need to prevent duplicate data from being submitted. I ...
0
votes
2answers
354 views

How to apply conditional formatting only if cell has X value? [google sheet] [duplicate]

I have a sheet with statistical data to which I had applied color scale conditional formatting. Some rows I set to have green for highest and red for lowest number in row and other rows the other way ...
0
votes
1answer
359 views

Is it possible to see all Gmail accounts by phone number?

I've created quite a few Gmail accounts for different projects, all verified with my cell phone number. Is it possible to see all the Gmail accounts connected with a specific cell phone number?
0
votes
1answer
110 views

How can I check my storage on my OneDrive for business account?

How can I check my storage on my OneDrive for a business account? https://faq.oit.gatech.edu/content/how-do-i-check-my-storage-usage-onedrive-business says: but I don't have the "site settings" ...
0
votes
1answer
133 views

How to apply conditional data validation when a cell with a defined value is changed?

I have a spreadsheet that's basically a grid checklist, let's say 10 columns and 20 rows. There are multiple cells that have N/A as the value, and I'm worried going through the checklist that one ...
0
votes
1answer
1k views

How to know how many times i have visited a website?

I use google to make research online. I dont want to collect data from the same websiye twice so i want google to tell me if it is the first time i am visiting the website or not.
0
votes
0answers
35 views

Grouping returned snooze messages in inbox

Is there an inbox view that puts snoozed messages that have come back in one segment so they are a lower priority than new messages?
0
votes
1answer
35 views

Limit discount code to once per person

I've created a referral discount code, I will personally hand out the discount code when someone refers someone else and that person orders. I Only want that person to be able to use that code once. (...
0
votes
1answer
1k views

How to either disable account key or update information in Yahoo

I have Yahoo mail and lost the cell phone that was registered to receive the code to sign into my email instead of using the password. I just keep getting into this endless circuit and cannot update ...
0
votes
0answers
119 views

Are there any other (faster) ways to browse Google Drive files than the web & desktop versions?

Google's own web version is quite slow to navigate between folders. The desktop version which syncs files (and file aliases to Google Docs) to your desktop filesystem lets you navigate between folders ...
0
votes
1answer
23 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
405 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
1answer
874 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
2answers
966 views

Problem with QUERY(IMPORTRANGE()) to retrieve data

I’m having a problem with the =QUERY(IMPORTRANGE()) formula while retrieving a column data from one spreadsheet to another. =QUERY(IMPORTRANGE("spreedsheetURL","Sheet1!A2"),"select Col2 WHERE Col1 ...
0
votes
2answers
1k views

Import range from 3 sheets/tabs into 4th

I currently have 3 sheets (tabs) in a Google Sheets workbook. Each column header (Row 1) in the 3 sheets are identical. I'd like to create a 4th sheet that combines ALL the contents in the 3 sheets ...
0
votes
1answer
437 views

Upload Limit of Drive.File.Insert

While I use the following app script code to upload file from URL to GDrive it is executed flawless but when I change the source URL with a large file's URL (more than 1GB) it uploads only 50MB for ...
0
votes
1answer
67 views

How do I change the realname connected with an email on GoogleMail?

How do I permanently change the name related to an email that I have recieved and sent email to in the past on GoogleMail (gmail.com)? The user changed their realname (examples: changed surname, ...
0
votes
1answer
18 views

Number in a cell linked with a text

I would like to ask if there is a solution to my problem: I have 200 numbers from 1 to 200 which are linked with text. For example: 1 = car, 2 = bicycle and so on. I would like to write a number (1) ...
0
votes
1answer
313 views

G suite login issues

when I create an account in google admin and try to login into that account, it fails and redirects me to google admin portal. The error message that I get is that "We are sorry, but you do not have ...
0
votes
1answer
45 views

Prevent the stretching from changing cells border in Google spreadsheet

Is it possible to prevent the stretching from changing cells border in Google spreadsheet? I mean that if I stretch a cell which has a border above it, then the same border will be added to the cells ...
0
votes
0answers
99 views

Workaround for Facebook censorship

Can't send link to a page, neither in post or comments. The link is not about malware or terrorism, it’s a niche website about anime, my friend has made some voiceover translation and wanted to share ...
0
votes
1answer
1k views

Google Sheets function returns an incorrect value

I have a very simple function for every cell in column D, for example: D24 =C24-(B24*N$2) Example with values: D24 =10-(1*6,5) This works; however, not all the time. For cell D24 this returns a ...
0
votes
1answer
121 views

MediaFire Data Retention?

There Data Retention Policy Is Below- https://www.mediafire.com/policies/data_retention.php#data_retention_table Can someone read this information from the link and inform me what it means when they ...
0
votes
1answer
37 views

4 IF AND Statements in one cell

Trying to get two equations to then present one of four options. Example: Have no idea where to start, all four need to sit in the one cell.
0
votes
0answers
780 views

Match an automatic newline with regex find and replace in Google Docs

Google Docs implements regex find/replace, but I've been unable to match newlines that haven't been created explicitly by pressing the enter key. Is there any way to match 'implicit' newlines in ...
0
votes
1answer
1k views

Google Drive and Google photos (delete from Drive without losing them on Photos)

All of my photos are on Google photos. They are stored using the free space with Google's quality rather than the original quality. There is a folder on my Google Drive that is called "Google Photos". ...
0
votes
1answer
55 views

Automatically (protect or update or retain) a cell's formula when a row is added from “Zapier and Twilio”

When a row is added in this case from a (Zapier into a Google sheet, the formula in a cell not used by the incoming data is deleted. How can I retain/protect the original formula in column AE being =...
0
votes
1answer
24 views

Pandora's Next-Song Selection: When, Where, and How?

I surprisingly cannot find any information about this online: I have some questions on the Selection of the Next Song in Pandora (Premium) App: Does the selection of the next song occur in the App ...
0
votes
1answer
124 views

Change picture of Google account

I tried to change the picture of my Google account. I did this through Gmail. However, the picture has not yet changed. I tried the things I have read in other related questions; remove/change my own ...
0
votes
2answers
42 views

Cell reference for contains value in Google Sheet

Looking for help referencing another spreadsheet, where I want to lookup several values in cell A2, to see if the value is contained in the cell (as there are variations), then setup an else clause at ...
0
votes
0answers
14 views

Chrome inspector devtools sources incremental text selection: Undo last?

Most people don't know about this feature, but Ctrl + D will select the next match: https://www.keycdn.com/vid/blog/select-next-occurence.mp4 (source article) This is a feature that exists in many ...
0
votes
3answers
79 views

Picking the Total from the Next Week

I have the next year mapped out (one line for each day) and have the week subtotal at the end of each week (which is a Friday). I am wanting the Next weeks subtotal to show in another cell for that ...
0
votes
0answers
99 views

Google Chrome autocomplete calculation won't let me select and copy the result

I used to be able to type simple calculations in the URL bar in Google Chrome and the result would appear beneath the calculation where I could now hit the down arrow key to select the result and then ...
0
votes
3answers
67 views

Average formula for Google Sheets with substitution over some figures

I have a row of figures from 0 to 2, some cells are empty. I need to count an average for them, but with the rule that would count 2 as 1. Thanks

15 30 50 per page
1
556 557
558
559 560
612