All Questions
33,870
questions
0
votes
0
answers
4
views
VLOOKUP or INDEX/MATCH used on a HTML Import
A little background, some friends and I wanted to start a Fantasy Golf league. To start we would pick our teams and fill in manually. I did some research and started to try and automate the process. ...
0
votes
1
answer
8
views
Help getting multiple rows of data from a selected drop down list
I have the following rows of data in my sheet. Here's 7 as an example, but I essentially have over 1000 rows of data.
Column A
Column B
1
Tesla
Jess
2
Toyota
Kelly
3
GoPro
Jess
4
Apple
Linda
5
...
- 1
0
votes
0
answers
5
views
How to return only certain date ranges from source data? [closed]
=query(IMPORTHTML("https://walletinvestor.com/bse-stock-forecast/tata-elxsi-ltd-bse-prediction/data","table",1),"Select Col2,Col3")
Above Googlesheet Query Gets me the ...
0
votes
0
answers
4
views
How to disable all localization on Chrome, Google Search, and all other Google apps? [closed]
I'm outside the US, and I want Google and Chrome to stop basing their localization on what it thinks my location is. I want it to use US English defaults for time, date, currency, temperature, ...
athome withagroovebox
0
votes
0
answers
5
views
Cmd+I randomly opens outlook.com in Chrome (not my default browser) [migrated]
I am perplexed for a few reasons:
My default browser is set to Vivaldi so I don't understand why clicking Cmd+I in Vivaldi sends me to outlook in Chrome
I have set Cmd+I in Vivaldi to be "...
- 113
0
votes
0
answers
5
views
All my replies on Twitter get hidden with "Show additional replies, including those that may contain offensive content"
For the last few days, whenever I reply to other tweets, my replies get hidden by Twitter.
If I log out & check the main thread, this is what I see
Only if someone clicks on Show, can they see my ...
- 83
0
votes
0
answers
7
views
How to Automatically Format a Google Sheet from Google Form data?
I have a Google Form which is linked to a Google Sheet that is submitting data for warranty exchanges for a client. At the end of each month they download the sheet as an Excel file to enter into ...
- 1
-1
votes
0
answers
5
views
How to find number of people's on Facebook page chat list?
Since I can't send first message to my customer from my Facebook page, there are only limited number of customers I got to chat on Facebook page and they are those who have started connection with my ...
0
votes
1
answer
4
views
Exception: The parameters (String) don't match the method signature for SpreadsheetApp.Spreadsheet.getSheetNam [closed]
I am trying to create a google sheets form that would automatically populate the entered data from one sheet to another within the same document. However, I am getting this error when running them. ...
1
vote
0
answers
10
views
Anyone know a workaround for Gmail "Remove formatting" fail at end of formatted message? [duplicate]
1 On a HTML-formatted message having a non-white text background at the message end e.g.
do Forward.
2 TAB to body, press CTRL+End to go to end.
3 Press CTRL+\ (Remove formatting)
4 Type "test&...
- 349
3
votes
1
answer
60
views
How to workaround Gmail loss of pasted image upon Print and Send?
1 In a Reply window containing text and image, Select All and Copy.
2 In another Reply window, Paste
e.g.
3 Print.
Expected: Image included
Observed: Image lost - shows broken graphic icon and "...
- 349
0
votes
0
answers
9
views
Reference other sheets in Google Sheets using file name? [duplicate]
I have a set of Google Sheets workbooks in a Google Drive folder that reference each other. One of the source workbooks contains data that is externally updated daily which then replaces the same ...
user1779906
0
votes
0
answers
13
views
How to use an arrayformula with dynamic row numbers (and other nested functions)? [closed]
I have 9 columns, each with the header 1-9. I want to iterate across each row, and if value exists in a particular column, I would like to grab the header value (1-9) and concatenate it as a comma ...
- 1
0
votes
0
answers
10
views
Where does events exported from Facebook to Google Calendar appear? [closed]
I just used the Facebook "Export your data to another service" feature and exported my Facebook events to Google Calendar but I can't find the events. The process consisted of ≈ 4 steps and ...
- 651
0
votes
0
answers
5
views
Does your Zoom Login using “Continue with Apple” etc Shows Chinese Error? [closed]
today I tried logging into Zoom with the option for using “Continue with Apple” and it showed an error. The “Continue with Google” option results in the same.
While the error is annoying, the fact ...
- 101
0
votes
0
answers
7
views
Why does the amount of photos on my Facebook keep going up and down everyday [closed]
my friend noticed this the other week that the amount of photos in my album keeps fluctuating, for instance today I have 1500 photos but yesterday it went down to 1490 then went upto 1496 then to 1500 ...
- 1
1
vote
1
answer
20
views
Cannot find active sheet: TypeError: read properties of undefined (reading 'source')
I'm trying to add the current date to a cell in column K when any cell in that respective row is changed.
I found this script and altered it for my situation so I can deploy it as a trigger:
function ...
- 415
0
votes
0
answers
3
views
Scraping a small town paper website for a particular column over the years [closed]
On behalf of a project for my 78-year old mother, I am trying to download a specific column (Toe Prints) written by one person (Doris Hartwig) that had been printed in multiple newspapers over decades ...
0
votes
0
answers
6
views
How to enforce a message template in Discord? [closed]
Currently channel members can post anything they want. Since our server is for Q&A I want them to follow a specific message template:
Please take a look at this Q&A doc before posting: www....
- 101
0
votes
0
answers
5
views
Why does Google think that 3 femtometre = 1.8e+20 meter? [closed]
I think the screenshot says it all. What's up with this?
A femtomet[er/re] is a trillionth of a met[er/re] so the answer should be 0.000000000000003. or 3e-15.
- 101
0
votes
0
answers
7
views
Replacing a template in multiple cells with data from another spreadsheet [closed]
I am looking for a way to import data from one spreadsheet into another, but only to replace placeholders inside of the cell, not the entirety of the cell.
The context is I have a target spreadsheet ...
0
votes
1
answer
7
views
Creating google forms that can be submitted only if the person selected correct answer (Google form is not a quiz) [closed]
Is it possible to insert an "If/Else" function in Google Forms using a Google Apps Script?
0
votes
0
answers
9
views
Security of data in transit [closed]
I have a question for someone who knows more about network security than I do (I know very little)
I have a Shiny web application running inside a container in a private subnet of a VPC. A user ...
0
votes
0
answers
5
views
Disable Google 2FA when authenticator is lost [duplicate]
I have a Google account where I have set up 2 step verification, with a phone number and Google Authenticator.
However, recently, I have lost the TOTP details used for the "Google Authenticator&...
- 101
0
votes
0
answers
4
views
When you should NOT use MongoDB? [closed]
I am planning to use MongoDB for my project, but after reading this article, I am uncertain about whether I should proceed with it. What is your opinion on this matter?
https://www.inconceptlabs.com/...
0
votes
0
answers
8
views
Rundeck Login only Loading screen [closed]
i installed on ubuntu server 22.04:
apt install ansible
https://docs.docker.com/engine/install/ubuntu/
https://docs.portainer.io/start/install/server/docker/linux
git clone https://github.com/rundeck/...
1
vote
1
answer
28
views
Why are the share button and toolbar blue in Google Sheets? [closed]
Here is the capture.
But the share button and toolbar look normal if I use another account.
- 11
0
votes
1
answer
13
views
Insert formula, process and replace by raw value
What is the best approach to achieve the following:
If a cell in column A has content, then place a formula into the cell in column B in the same row, referencing the cell in column A.
Once the ...
- 5,266
0
votes
1
answer
12
views
Google sheets. Compare the value in column on the 1st sheet with 2 others and then pull cells to y the right of matching value in the other sheets
I have one workbook, 3 sheets. Ultimately I'd like information from sheet 2 and 3 joined with corresponding information on the 1st sheet.
The 1st column has an ID number on each page. How can I make ...
Ariceliz
2
votes
1
answer
14
views
Outlook for Web (MS 365): Expand all Threads (Conversations)
Is there a way to expand all threads/conversations by default in Outlook for Web? To be clear: I do NOT have an outlook application installed on my laptop. This is the Web Outlook. I'm finding it hard ...
Christy
0
votes
1
answer
32
views
Google Sheets Pivot Table - Show totals for only one column in grand total
I have a pivot table that has 1 Row (ATIVO), 0 Column and 4 Values columns (Quantidade, Preço Un. Atual, Preço Médio and Total).
But I only need the grand total (shown as Total geral) from the last ...
- 103
-1
votes
0
answers
12
views
Why can't I change the color of the text? [closed]
I'm trying to make an alternative history family tree chart. Whenever I try to change the text color of a rectangle, it just doesn't change it into the color I picked. Never happens when I change the ...
-1
votes
0
answers
16
views
Need "Reset Button" in Google Sheets to revert drop down lists to one of the options ("None") instead of clearing cells completely [closed]
thanks for reading.
I am attempting to create a fee calculator for a small business which uses the INDIRECT and SUM functions along with drop down lists to find the total fees if a family enrolls in ...
- 1
-2
votes
0
answers
12
views
Saved places to use in itinerary
I've been using Google Maps to save places in lists.
I want to find a way to integrate those saved places (export or integrate) into Google My Maps to plan a trip/route.
So, I would like to create an ...
- 1
2
votes
1
answer
52
views
Append Current Stock Stock Price to Historical Prices
I'm looking to append the current share price of a stock to the end of a period with changing durations.
My current formula for the historical prices is (where cell B3 is a duration of days to ...
- 225
-1
votes
0
answers
12
views
Account issues with links to Google Workspace files in Gmail messages [closed]
We are on the non-profit version of Google workspace. I'm trying to solve an issue for my boss.
He's using the latest version of Chrome browser on the latest version of OSX on his Mac computer.
He's ...
- 1
-1
votes
1
answer
9
views
How can avoid Gmail Print preview inaccuracy w.r.t. original and output [closed]
Original:
Print dialog preview:
("Chris Jordan" is grey)
Print (Save as PDF) output:
How can I avoid this Print preview inaccuracy in the text colour i.e. get it to accurately show the ...
- 349
-1
votes
0
answers
12
views
LinkedIn "spotlight" notifications [closed]
From time to time, I receive this kind of notification from LinkedIn, that has this spotlight icon. These notifications don't come from my network of contacts, and isn't either one of the "...
-2
votes
0
answers
11
views
My facebook Account is locked! Please help [closed]
Currently, I don't remember my Facebook password, so I tried to reset It when I enter my mobile number and it shows this
I still have my mobile number, I tried to contact Facebook support but they ...
1
vote
1
answer
22
views
How to average the last 5 nonblank, nonzero value in a row in Google Sheets?
I run a disc golf league and in order to track handicaps we take an average of the last 5 rounds played. I currently have the player name in column A, the handicap in B, # of rounds played in C, best ...
- 13
0
votes
1
answer
24
views
Google Sheets, coloring a line depending on another column (conditional formatting for lines)
Imagine I have a table like the following.
Column A is the x-axis, e.g. time. Column B is some condition, e.g. 1 and 0 for yes and no or true and false. Column C has the y-values.
I'd like to create ...
0
votes
1
answer
7
views
In Vimeo, how do I add an unlisted video to my Watch Later list?
The background of my question is as follows: I found a Vimeo embedded video on some website, and I would like to play it on the big screen (using my Apple TV with the Vimeo tvOS app installed, in ...
- 101
0
votes
0
answers
23
views
How to add Google Authenticator (TOTP) to a Google account? [duplicate]
I'd like to 2FA with Google Authenticator to my Google account using the account settings page, but when I want to add 2FA, Google only offers adding an U2F security token for 2FA but provides no TOTP ...
- 193
0
votes
1
answer
30
views
Is there a way to search backward in Google Spreadsheets?
When I click CTRL+H then I can open big search box in Google Spreadsheets. It searches forward for specific text all sheets from the position of my cursor. But is there a way to search backward?
I ...
- 101
-1
votes
0
answers
6
views
Changing the order of the playlists on the left side on the home page of YouTube [duplicate]
I tried to search a way to change the order of the playlists on the left side on the home page of YouTube; it seems that this is not allowed. Can you tell me if there is a way to do it please?
My ...
- 196
-1
votes
0
answers
8
views
Search term to use in google photos to search for files greater than a certain size [closed]
I recall coming across a link which described how to filter videos / pictures in google search based on certain sizes. For example: videos:greater than:10mb. However I cannot seem to find this link ...
- 99
1
vote
1
answer
31
views
Differentiating between 0 and empty cell with VLOOKUP in Google Sheets
I am trying to use VLOOKUP in this Google Sheet to convert percentage grades to a 1–8 grading scale. I would like to be able to differentiate between a score of 0 and an empty score but am having ...
- 113
2
votes
1
answer
168
views
How to create a custom number format in Google Sheets that handles single and multiple digit numbers differently
How can I create a custom number format in Google Sheets that displays numbers > -10 and < 10 to one decimal place, but displays numbers <= -10 or >= 10 with no decimal places? The format ...
- 95
-1
votes
0
answers
6
views
Google drive photos [closed]
I'm organising photo files into folders on google drive. Can I now delete the same photos that are in the folders but are unorganised without losing them from the folders? Trying to free up space
...
- 1
0
votes
1
answer
22
views
How do I hide a column in Google Sheets from another user with a password? [duplicate]
I have a sheet being used by 4 different persons;
one of the columns has private information, related with payments.
I want to be able to see it all the time, but I don't want them to see it, even if ...
