All Questions

6,997 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
22 views

Create an overview of users that can edit / view specific folders within Google Drive

We have a share Google Drive environment where different folders are shared with several people. Per folder I can see who currently has access to the folder. For compliance purposes I want to create ...
0
votes
1answer
492 views

Monetization disabled in my YouTube channel

I have created a new channel on YouTube called Rancho's YouTube Channel last week. I have uploaded 3 videos that after that my monetization is disabled. How to fix this? I have attached the ...
0
votes
1answer
27 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
415 views

Copy data validation “list of items” from one sheet to another?

On one sheet I have a column that uses "list of items" data validation which allows for a drop-down menu to extend and a multiple of options to be selected. Is there a way to automatically populate ...
0
votes
0answers
878 views

Is there a way to private YouTube stream archives by default?

I've recently started streaming and I can't seem to find a more efficient way of privatizing all of my stream archives other than going into each archive one by one and setting it to private. On my ...
0
votes
0answers
533 views

Do Google app passwords expire?

I manage a shared email account (in Gmail) for a small organization. I have 2-factor authentication turned on and had generated an app password for an external app that accesses the inbox via IMAP. ...
0
votes
1answer
14 views

Gmail Forward email to group, with recipients replying to specific person

I forward a LOT of emails every day. Most of the time, people reply to who they need to. Example. "Do you need money?" Email. Forward to people who need money. But I don't need them to reply to me, I ...
0
votes
2answers
86 views

Function to search columns and tally data

I am wondering if I can write a function to search a column in my spreadsheet for a specific name, then return x number of values within the row(s) that contain the name. For example... M4 holds the ...
0
votes
1answer
566 views

How can I use GOOGLEFINANCE to return a share price in a certain currency?

I have shares in different currencies that I want to track in only a single currency. I currently have a cell that returns the currency and one that returns the price, I then multiply them. However, I'...
0
votes
1answer
83 views

When someone shares a Google doc or presentation with me, I no longer get an email notification. How can I fix this?

When a teacher or peer shares a google doc, presentation, or spreadsheet with me, it no longer appears in my Gmail. I have checked my spam, trash, and all my folders. It used to send a notification, ...
0
votes
1answer
770 views

Concatenating URL with a value to create link, but links only partially work

I have a column of cells in Google spreadsheet with values such as: b2397 b9504 b3333 b8655 bxxxx I would like to combine each value with a URL, for example: http://websitex.com?id= ...
0
votes
2answers
93 views

How to export CSV without commas in unpopulated cells?

I have a form converter which simply rearranges columns. I use a script to paste Values only into another sheet for export and uploading onto another website. However, when I go to export, it seems ...
0
votes
0answers
1k views

How to append data to desired column in Google Sheets?

I have created Google sheet having two columns A & B. I want to enter "In time" in column A and its corresponding Out time in column B. I have created two python scripts which append data to the ...
0
votes
1answer
378 views

Average value using different sheets on Google Sheets

I have a data set that's separated by year (so, the first year is Sheet1, the second year is Sheet2, and so on. There are 18 years in total). I want to average the data from different years. At first, ...
0
votes
0answers
322 views

URL code for Google Form section

I have Google form with 10 section(lets call it page), and I use app inventor to create the mobile interface. The problem is when I get the pre-fill link with a link to be execute: https://docs....
0
votes
2answers
22 views

How to work over rows from all other sheets in Google Sheets?

I have a 'summary' sheet and 12 other sheets named 'Jan20', 'Feb20', etc. In the summary sheet I have this formula (to calculate Uber costs): =FILTER('Jan20'!F2:F, REGEXMATCH('Jan20'!D2:D, "UBER")) ...
0
votes
0answers
44 views

Email bombs: How can I defend a web email account against one?

Email bombs: How can I defend a web email account against one? For what reason? To save email addresses from an email bomb targeted at Office365 and Outlook.com accounts using custom domain ...
0
votes
0answers
12 views

How can I make google give me only top-level page results?

I would like to do a keyword search but with only top-level pages as result. For example, I want https://superuser.com as a hit but not https://superuser.com/questions/230975/ on my search. Only ...
0
votes
1answer
159 views

Add row to Google Sheets and keep formulas from previous row

I want to add a row to my spreadsheet but keep the formulas – and only the formulas – of the previous row. The #1 solution provided here doesn't help me because it also copies non-formula information, ...
0
votes
0answers
2k views

How can I export an specified Instagram chat and view it in a clear way?

How can I export an specified Instagram chat and view it in a clear way? This feature is available in WhatsApp. ... the only thing that is available in instagram is a full backup that contains ...
0
votes
1answer
2k views

Convert Number and Text to Number

I have a spreadsheet in Google Sheets with data like this: In sheet 2, in column pricelist, the below data is there. I want the summary in sheet 1 to have the same. I have used index and match but it ...
0
votes
0answers
16 views

How does one import an RSS url as a RSS formated URL?

Currenty I am currently trying to aggregate a few of these urls in order to pull html which I want to display in my Sheet. Problem But currently I am just importing RSS from a news aggregator using ...
0
votes
1answer
151 views

How do I calculate weighted rates in Google Sheets?

I would like to calculate the cost on $D "Rent" with a weighted cost when the respective cell in $B="PB". The calculation would be based on the formula 7x+1.3x=1252 where 7 is dependent on COUNTIF(A2:...
0
votes
1answer
26 views

How To Edit Title Caption?

I am unable to edit a title caption on photos I posted in Google Shared Photos. Is there a way to edit the title caption?
0
votes
0answers
34 views

Google Sheets: auto-format an entire column to be hyperlinks upon import

Here's my process: export CSV from CRM > import to Google Sheets > do work. In ColA are unique IDs (all integers e.g. 808938269) of accounts in my CRM. I would like to appended a generic [URL] string ...
0
votes
2answers
26 views

How to count duplicate names as one value in Sheets?

I have a large dataset in Sheets and I'm grouping together the data in a pivot table and have a hard time figuring out how to avoid counting every instance of a name instead of counting the name as ...
0
votes
1answer
4k views

Google Sheets Conditional Formatting Isn't Working

I am making a spreadsheet in Google Sheets and my conditional formatting works in some cells and not in others. I have gone so far as to delete all of the formattings for the entire workbook and ...
0
votes
1answer
2k views

Copy and paste text with comments

I've got 2 google drive documents that have comments in them, made using the comments tool. I'd like to copy and paste text along with its comments between the 2 documents is that possible?
0
votes
0answers
1k views

What is the best way to search a video with specific song in it on youtube?

Under any Youtube video there is a description of music/songs under it. What is the best way to search a Youtube video based on that song? I can search it by the name of that song in Google search but ...
0
votes
0answers
72 views

Opening a docx.URL

My superior sent a newsletter as Circulaire...docx.URL. I am unable to view it or to print it. I have downloaded it and have put it in My Google Drive. However, no matter what I do I can't open it ...
0
votes
0answers
100 views

Help with a two way link script for google sheets

so I found a great answer to a question that I had about connecting two different spreadsheets with a link that would allow you to edit either one and the other would update, and I found this great ...
0
votes
1answer
282 views

Max value conditional formatting rule not working in Google Sheets

I want the max value in Column B to show up. I put in this formula but it's not working. What am I doing wrong? Here is the table
0
votes
0answers
394 views

Master Checkbox that turns off other checkboxes based on keyword in a different cell

I'm trying to create a master checkbox (actually a few) that toggle on/off various other columns of checkboxes on the same sheet. I have researched this issue and found only solutions either A) ...
0
votes
0answers
20 views

Creating a twitter search link that references the user that clicked on said link

I was wondering if its possible to make a link of the formhttps://twitter.com/search?q=itunes.apple%20from%3A&src=typd where the search is performed on the whoever is logged in when it is clicked. ...
0
votes
0answers
1k views

How can I unzip multiple zip files?

I actually would've just posted this as a comment under @Wikunia's brilliant colab answer, here, but I'm new (sorry!!): Basically, that works, and it works perfectly, but I'd like to genericise it to ...
0
votes
1answer
6k views

How to move a row into another sheet?

In Google Sheets, I need to hide rows if column H says, "Completed" My preference would be to cut and copy the row to a new sheet if column F reads "Completed", but sounds more difficult. If you ...
0
votes
1answer
37 views

Default to 'More Options' in Google Calendar

In Google Calendar, when creating an event, I always utilize the options under 'More Options' (creating an all day event, modifying notifications, etc). I know it's only an extra click away, but with ...
0
votes
1answer
53 views

Where did the “internet speed test” go?

If I Google Internet speed test Google should offer me a quick internet speed test box as the first result. I could test my internet speed without leaving the Google search page. Now, this box is ...
0
votes
0answers
25 views

Google script full up the database

I have make more questions for this topic, the scrips are working, but i will add more cells to the script. The script what i have. function myFunction() { var spreadsheet = SpreadsheetApp....
0
votes
1answer
2k views

How to rotate a curve in Draw.io?

I know how to rotate an object in Draw.io because usually there is an anchor where my mouse changes into the rotation mode. This is also explained in this tutorial: https://support.draw.io/display/DO/...
0
votes
1answer
623 views

How to plot weekly, monthly stock price in Google Sheets?

Help me with functions or formulas for google sheet to display UPTREND DOWNTREND BULLISH BEARISH of Daily weekly monthly quarterly stocks as seen in PIcture attached herewith Please help me build a ...
0
votes
1answer
223 views

Display the aspect ratio of the current video on YouTube?

I need to know the current video's aspect ratio on YouTube. Is there any extension that can detect and display?
0
votes
1answer
82 views

Using the Wayback Machine without loading scrolling images on its front page

The Wayback Machine (https://web.archive.org) is very useful for finding old versions of websites. Unfortunately, its front page has a bar of horizontally moving images that take a long time to load. ...
0
votes
1answer
12 views

Inserting responses

I am using Google Form to capture a survey. I have about 7 questions regarding a conference lecture. I want to use Google Forms and was wondering if I can manually insert the responses?
0
votes
1answer
176 views

Drawing fields within a UML Class Diagram when generating from CSV

I followed the example here: https://jgraph.github.io/drawio-tools/tools/csv.html To create a UML Class Diagram from CSV. All went well, however, there is no documentation or sample of how to create ...
0
votes
0answers
584 views

Can't double-click to open Google Sheet document (Windows with File Stream)

I use Google Drive File Stream on Windows. I used to be able to open a Google spreadsheet from an explorer window just by double-clicking on it like any other file. Now I can only open them by right-...
0
votes
0answers
399 views

Google Drive - Get Image sizes

Is there a script that I can use to get the images sizes within a folder on google drive?
0
votes
1answer
29 views

Get Startpage to label tabs with search query

When Startpage opens a page with search results the tab for the new page is labeled beginning with "Search results - Startpage" where the label fades out on the right hand side. Whereas when I open ...
0
votes
0answers
12 views

How to “freeze” a number from cell reference in Google Sheets based on date

Is there a way to display a number from a referenced cell, only so long as we're in a given month, and when the month changes, that cell number remains static, like frozen in time?
0
votes
1answer
722 views

How can I go back from YouTube TV to 'normal' Youtube

I followed the advice in this answer and entered https://youtube.com/tv in my FireFox browser. A login screen appeared which I could skip and indeed, all videos appeared in a large full screen format. ...

15 30 50 per page
1
113 114
115
116 117
140