All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
5 views

Firefox re-allow `alerts`? [migrated]

I visit a page which uses the javascript alert function for a particular functionality. Each time this alert pops up, Firefox puts a conspicuous box to prevent the site from alerting ever again. ...
1
vote
0answers
28 views

Facebook account asks for verification, but does not send out the verification

When I try to recover my account using email, it says: "Enter code We sent an 8-digit code to the email you chose. Please enter the code here once it arrives." "An error occurred while ...
0
votes
0answers
22 views

How to count rows instead of cells in Google Sheets based on multiple criteria? [closed]

I have a sheet that is used for tracking sales leads. Each row is a unique lead with a few of the first columns being basic information like Account #, Type, Date Signed Up, etc. Then I have about 16 ...
0
votes
0answers
3 views

About automatically un follow clubs and users in clubhouse app [migrated]

I have some bugs in my android phone sith the clubhouse application and it is automatically unfollowing the clubs or people for my user in application. So i have tries find some information on google ...
0
votes
0answers
3 views

How to sync files to a shared drive in google drive using googles backup and sync? [migrated]

Currently, google backup and sync app syncs files on my computer, which takes my own cloud space. So is it possible to sync my files to a shared drive? For example, I want to backup my full D: drive ...
0
votes
1answer
10 views

Why there is no (number) in the YouTube tab anymore?

Usually, when you have (number) on a YouTube tab, that means you have unread notifications. Now, the number tab is Removed. Why did they remove the number tab in the first place?
1
vote
1answer
22 views

How to manage emails from a mailing list in gmail

I have created a label in Gmail so that all emails coming from a particular address get tagged with the label. However, I would like for these emails to not appear in my inbox at all. This is a ...
1
vote
2answers
24 views

Indicating whether a value is in a specified set

Is there a Google Sheets formula that indicates whether a value (e.g., the contents of A1) is in a specified set (e.g., 1, 5, 9)? Yes, I could do a SWITCH(A1, 1, 1, 5, 1, 9, 1, 0), but that is overly ...
0
votes
2answers
21 views

How to stop Google Sheets from increasing numbers when dragging a cell?

So I have a column with text like abcd81. If I drag the cell by that bottom right point then the next row will have abcd82 and so on. How can I prevent this behavior?
0
votes
0answers
14 views

See views for Videos or PDFs uploaded to Google Drive?

Is it possible to get the number of views for a file uploaded to Drive, similarly to the Activity Dashboard you can use in Google Docs or Sheets? We have several videos and PDFs in a shared resource ...
0
votes
1answer
12 views

How to know Udacity course creation date?

I'm doing a course on Udacity, and want to know if it's the latest one. How do I check the creation date of the course? Course link
0
votes
0answers
6 views

Does a Google Doc's Version History count against your Storage Quota?

Google Drive recently changed their policy so that Google Docs count against your storage quota. Google Docs, by default, keeps a detailed version history of your document, so my question is whether ...
0
votes
0answers
7 views

Google drive backup : How do I sync only from my computer to drive?

I have configured a streaming backup for my computer on drive. But I see the drive and my computer is synced both ways, that is when I delete something on my computer it gets reflected on drive and ...
0
votes
0answers
3 views

Give permanent access to a computer via Chrome Remote Desktop? [migrated]

Is it possible to give someone else permanent access to a computer via Chrome Remote Desktop? My use case is simply that I want to be able to assist my elderly father with his Windows computer. I ...
0
votes
0answers
7 views

Seeing some except one mutual friend on a person's friend list

I am on "Pam's" Facebook page, and not friends with her yet. Pam's Friend's list shows our mutual friends. However, her Friends list is missing one mutual friend that I definitely know is ...
0
votes
1answer
42 views

Input timestamp into last cell

I work on a script to input timestamp in the lastcell when all previus cells are modified. The following is not working. function timestamp() { var archivo =SpreadsheetApp.getActiveSpreadsheet(); ...
0
votes
1answer
58 views

Sheet-form setup to allow users to update only their row?

Is it possible to use a Google Form to replace a user's data in a spreadsheet? Ideally this information would be attached to their email address as they are logged in to Google, thus preventing them ...
0
votes
1answer
47 views

Google Sheet: is it possible to make a chart's vertical axis' Min and Max values automatically adjust according to the values in the dataset?

I want to have my chart, which displays a range of data that updates periodically, to represent the changes across sampled values in a more zoomed-in form by having the minimum value of the vertical ...
0
votes
0answers
3 views

How to disable Sci-Hub display of PDF

I frequently use Sci-Hub. However, I would like Sci-Hub to not display PDFs in my browser. Apparently the site uses some kind of JavaScript to create a PDF viewer, as my browser is set to never ...
0
votes
1answer
25 views

Filter function in Google Sheets

I need help filter some data in Google Sheets. I want to create a FILTER() function that filters between 2 columns and also discards duplicates. Something like the UNIQUE() function between 2 columns.
0
votes
1answer
55 views

Query with long search criterion

In a Google sheet I have to search for a column containing a specific number. My search is =Query(OPGAVE_TRANS!$A$1:$AD$23;"select AD where A="&A1&" OR B="&A1&"...
0
votes
1answer
28 views

How to run a function everyday at 11 PM?

Currently the function runs every day at 11pm but it runs twice. I'm only needing it to run once though. function functionsToRun () { appendValues(); clearCells(); addZeros(); } function ...
0
votes
0answers
30 views

Convert input text into duration values with script on Google Sheets

I'm setting up a sheet to help coworkers keep track of their appointments. For now the only way to get those times is to copy-paste the numbers from a different program used to track the info. The ...
0
votes
0answers
8 views

How do I calculate percentage for my y axis based on a subset of data within the column?

​I have a simple multiple choice app that logs answer submissions for different quizzes. In this example, there was one session that logged 3 answers (for 3 different questions) for the "LMBB&...
0
votes
1answer
13 views

Splitting a list contained within a single cell and want to associate/add text from a different cell in the same row to the new separated list

I am using Google Forms to collect information. In google sheet, I have rows of data and one of the cells contains lists that needs to be separated out. =query(FLATTEN(ArrayFormula(IFERROR(SPLIT(G2:G,...
0
votes
1answer
12 views

How to use / refer to a named range when defining another named range in a Google Apps Script?

I have the following script in a Google Sheet Apps Script macro. It is meant to identify & delete a range of rows on a sheet. This was created by originally recording a macro & then attempting ...
0
votes
0answers
15 views

Auto populate comment

Is there a way to have google sheets auto populate a comment based on specific entries in a cell? I am trying to have google sheets auto populate a google form response if certain content is entered ...
1
vote
1answer
13 views

Conditional Formatting Help

I must be having an off day as I'm usually good with formulas - but I'm trying to finalize something for work and my brain is not getting me there.... I need a formula to color cell G75 Orange if cell ...
0
votes
0answers
9 views

Linking and entered data from one worksheet to another

I am developing a time-in-lieu Excel workbook. I have got the worksheet adjusted to being able to enter hours into any date in a month, it adds the dates and populates a set cell with the total (TOIL ...
0
votes
0answers
7 views

Is there a way to automatically change the text colour of English words in Google Docs?

I've been adding the meanings to all the French words on my google doc, and, to avoid confusing myself I change the text colour of all the English words. However, it's a pain to go through and change ...
0
votes
1answer
10 views

How do I add a sum if greater than zero to this current formula - =sumif(A1:A20,"<>#N/A")

I had an issue totaling the sum of a column with any value as #N/A. I solved it with this formula, however I only want it to add positive values but when I add "<0" I get an error. Any ...
0
votes
2answers
21 views

Google Sheets: Make the cell data the name of the link

Update: I have attached a pic for example. -------- I have ID numbers in each cell and I want that number to be a link to their file. I know how to make a separate hyperlink that will ref that cell to ...
0
votes
0answers
7 views

How to escape markup characters in Google Docs comments?

When you make a comment in Google Docs, it helpfully treats sandwiched characters as markup styling (article). Stars *…* become bold, Dashes -…- become strikethrough, and Underscores _…_ become ...
0
votes
2answers
26 views

Sheets - solution for a long nested if statement

https://docs.google.com/spreadsheets/d/13ZXDE2efDOSa2mI4GlzZDvFqB-eCfxtoFNJE73IniaU/edit I have done a lot of searching and reading and can’t seem to find a good solution to these long winded if ...
0
votes
2answers
17 views

Google Sheets - QUERY - SUM() based on empty column

I need to obtain the sum(B) if the column has empty values I want to reflect 0. I am automating this process for multiple sheets using app-script and need to use QUERY. Any suggestions?
0
votes
1answer
13 views

Conditional formatting from another google sheet

I am trying to create a conditional format for a cell to turn red, if that value is less than the value of another cell on a separate sheet. Does anybody know how to do this?
0
votes
1answer
11 views

Whats wrong with this formula in Google sheets? Im trying to get info from another sheet, but I need the cell to be dynamic

Heres the formula: ='Sector info'!(CONCAT("C", B2)) there's 2 parts to it, the part before the ! which references another sheet, and the second part, that lets me change the row im looking ...
0
votes
1answer
12 views

Want Query to return first column and count across the row

I have multiple google sheets with student names and scores from different courses. I am trying to query those sheets to return the student's name and a count of completed assignments in a totals ...
0
votes
1answer
9 views

Ranking in google sheets error. =rank(H2,$H2:$H92)+Countifs($H2=$H2,$I2,"<="&$I2)

I am trying to rank schools by the collection year. If a school ties I would like to use a different column to break the tie. Here is the function that I put: =rank(H2,$H2:$H92)+Countifs($H2=$H2,$I2,&...
0
votes
1answer
7 views

Prevent manually added data from shifting rows in auto-updating google sheet

Link to test file In my test file, I have two sheets. 1. ^ First one represent automatic data which will be later on fetched from auto-updating place like salesforce. 2. ^Second one has automatic ...
0
votes
1answer
9 views

I can't draw a horizontal line on grid in draw.io

How do I draw a horizontal line on a grid? See the picture As you see, the black line is a bit higher than the grid line. When I move the black line a bit lower, it overshoots the grid. All my ...
0
votes
1answer
16 views

How to keep permissions for protected sheets in Google Sheets when making a copy of the entire google Sheet

I have a Google Sheet file with multiple subsheets where I have protected the different subsheets so that the user can only enter input in certain cells. I havde addede the permissions that everyone ...
0
votes
1answer
22 views

Google Sheets: calling MailApp.sendEmail from a time-triggered script fails due to insufficient permissions. How to fix this?

My sheet runs some calculations on a chart of numbers which updates automatically from a time-driven script. Within that script I put at its very end a function which compares two of the resulting ...
0
votes
0answers
28 views

Using URL to populate Google Sheets cells

If I have a user click a URL for a Google Sheet but append the URL they click with parameters (ie. https://docs.google.com/spreadsheets/d/1N0qkLWp3fUm3xpp328MnIz8W4JdBR0990oPU8YW8G0E/edit?playerID=...
0
votes
1answer
11 views

How to Autofill Horizontally a Formula the same way you would Vertically

I'm trying to expand/autofill a formula in a Google Sheet row, the same way I would vertically but it's not working as desired. Here's the formula: =arrayformula(COUNTIFS(Tracking!$G$1:$G$203, "...
0
votes
1answer
21 views

Add one field in a queried Field

I have to work with a weirdly formatted dataset. I have a sheet where lines represent different parts of a model (bike) The first columns are checkboxes to indicate witch models the part is in. So my ...
1
vote
1answer
75 views

Logged into my email via another mail

my email is "foobar@gmail.com". I tried logging in "foo.bar@gmail.com" just to see if I had created such an email some time ago. I received a notification in my phone to reset ...
0
votes
0answers
5 views

Select debug browser in Visual Studio 2022 [migrated]

There used to be an option to select the browser you wanted to debug in. There "play" debug button also used to be available on debug toolbar. Are there settings to get this functionality ...
0
votes
0answers
12 views

Accidentally removed a folder from google drive (web)

I accidentally removed a folder from google drive (web). Then I checked the trash folder, I saw nothing. But trash removes file/folder every 30days, but this incident just happened 30sec ago, Can ...
1
vote
0answers
16 views

Filter multiple pivot tables from a connected Google sheet

I have a connected Google Sheet. In a separate tab, I have a number of pivot tables deriving from the range of this connected sheet. I want to create a way to filter all of the pivot tables based on ...

15 30 50 per page