All Questions
33,710
questions
1
vote
0
answers
14
views
Google Sheets ladder linked with Google Drive folder
For a project at school, I have around 340 pages (170 spreads) labeled with the contents of the page/spread in the cell in a Google Sheet. I also have a Drive where every spread has a folder (ie 002-...
- 11
0
votes
1
answer
21
views
How to check in depth why Waiting/Saving is hanging
I have a sheet with 14*40000 cells that is giving me consistent hangs during some operations. I've been trimming it down and exporting just the one tab to a new sheet (works fine), and it sometimes ...
- 176
1
vote
0
answers
11
views
How to Transfer Spotify Library
I'm currently on my brother's Family account. I want to get my own account. How do I transfer my old Library to my new account?
- 11
1
vote
0
answers
14
views
Publishing one sheet from a Google spreadsheet
I have a Google spreadsheet which contains multiple individual sheets. In the upper right corner, the blue "Share" button shows "Anyone on the internet with the link can open it". ...
- 11
1
vote
0
answers
34
views
As a Reddit moderator, how do I compel each text post to contain this same Q & A format? [closed]
How can I obligate this format of questions and answers in each text post (on my SubReddit)? Posters shall answer EACH numbered question, which posters can't change.
How can AutoModerator remove any ...
user314568
1
vote
1
answer
16
views
Error when using the FILTER function to get the buyer's name, address etc [closed]
I work for an Amazon drop shipping business, and we have a spreadsheet of all the order information, including the order ID, quantity, cost, etc.
I have a different spreadsheet with the buyer ...
- 11
1
vote
0
answers
14
views
Google Workspace: really no free "shared mailbox" like in Microsoft Teams?
I´m searching for a possibility to create a "shared mailbox" in Google Worksspace. My company has A LOT of shared mailboxes like info@example.org, sales@example.org and so on.
In Microsoft ...
- 11
2
votes
1
answer
30
views
Retrieve subscribed calendar URL from Outlook OWA
I have a subscribed calendar on Outlook OWA and the calendar is listed under the "Other calendars" section.
I am not the owner of this calendar, and as such, I cannot 'share' the calendar as ...
- 83
2
votes
0
answers
20
views
How can I draw five circles around one circle using Draw.io?
I'm trying to create a diagram for my presentation.
However, I'm a bit stuck and not sure how to achieve this particular layout.
Could you kindly share your knowledge on how to draw like the image I'...
- 21
2
votes
1
answer
50
views
Kindle Web Reader (amazon ebooks) Dark Mode
Right know, even with Dark Reader (chrome extension), there's no good dark mode for Kindle Web Reader, is there any way to customize this web UI?
- 131
1
vote
0
answers
29
views
Why does YouTube show some videos with blank thumbnail? [closed]
Here is the YouTube video that is still up, but its thumbnail
is blank as if the video has been removed:
https://www.youtube.com/watch?v=MQ8y6-7-fbY
Why does YouTube show some videos with blank ...
- 19
0
votes
1
answer
16
views
Google sheet: find a Word from a range, in a string and return corresponding Word from the range
Column A contains text strings
Range aa:bb (in another sheet):
aa contains keywords
bb contains result-Words
I would like to put a function in for example cell B2 which:
Checks If any of the Words in ...
- 11
2
votes
0
answers
39
views
How to recover Google account if you lose your phone number? [duplicate]
I tried to log in to my Google account but after typing in the correct email and password, Google demands me to enter SMS code sent to my phone number attached to the account. However, I already lost ...
- 200
0
votes
1
answer
21
views
I moved a chart to a seperate sheet, do I have to reference the original sheet in front of every cell reference?
The name of the sheet I moved the chart from is Systm. Can I get rid of the redundancy?
=ARRAYFORMULA(COUNT(IF(({
'Systm'!$K$294:$K$339, 'Systm'!$BE$294:$BE$339}= 4 )*({
'Systm'!$L$294:$L$339, '...
- 99
1
vote
1
answer
33
views
Are there any ways to corrupt a google spreadsheet such that it can never be recovered by any means? [closed]
I have not shared it with anyone at any point save for my alternate gmail account. It has very, very personal information stored within and I realised immediately after creating it that I would rather ...
- 19
0
votes
1
answer
29
views
Google Sheets Date/Time Stamp
I have a Google Sheet with a dropdown menu in column U.I would like column V to timestamp when column U is changed. I've used the following code however this only timestamps the first time that column ...
1
vote
0
answers
7
views
Facebook Profile not linking to Groups I admin for
I have a personal Facebook profile and now admin 2 NFP Facebook community groups.
Problem is not being able to post in the group as an admin (posts as me personally everytime) and no function to be ...
- 21
0
votes
1
answer
19
views
How do I use an array formula to get column data from a sheet based a checkbox?
I have 3 sheets.
The first one Master contains my source data.
In the other two sheets I'm trying to get columns A-C from the source data Master!A:C based on the state of the checkboxes in columns D ...
0
votes
0
answers
10
views
How can I search for oncology polls on twitter? twitter don;t have poll option to search [duplicate]
How can I search for oncology polls on Twitter? twitter doesn't have poll option for searching.
0
votes
1
answer
13
views
How to get rid of the pencil icon from Google Workspace Labs
How do I get rid of this icon in Google Docs:
I believe I got sucked into this via an offer from The Google that I opted in to use, but silly me, I did not even consider that a billion-dollar ...
- 1,848
0
votes
0
answers
10
views
Google sheets - Padding dates in a pivot table
I would like to know if there's a way to pad empty dates rows when doing a pivot table when there're not present in the source table.
More context about what I'm trying to do. I track workout data and ...
mich
2
votes
2
answers
43
views
How to automatically add 00 minutes to hours in Google Sheets?
We have cells that store time in the H:MM format (24-hour time without a leading zero for hours). However, I don't like typing values such "8:00". Ideally, I'd like to type just a single ...
- 123
-2
votes
1
answer
69
views
Google Sheets double click fill down not working
If I select a cell and then double-click on the blue dot at the bottom-right of the cell, the fill-down function does not work, nothing happens.
Sometimes it does work, in other cases/columns.
The ...
- 183
1
vote
0
answers
66
views
What is the difference between block and "hide user" Youtube [closed]
I wish to block someone on youtube but it seems that the "Block user" option has been replaced with "Hide user from channel"?
I dont want to "hide", I want to completely ...
- 119
0
votes
0
answers
32
views
Total all-time views/visits of GitHub repo page by any means necessary (archived pages? third party software? URL visit counts?)
A similar question has been asked here, but I am in a slightly different situation and feel that others may be as well. While I understand that it is possible to begin tracking GitHub repo traffic for ...
1
vote
3
answers
34
views
Google Sheets Query: Selecting column, can only order descending
The following query works for me in google sheets:
=QUERY(A3:A,"SELECT A order by A desc")
Changing desc to asc however does not, instead returning #REF!:
=QUERY(A3:A,"SELECT A order ...
- 119
0
votes
0
answers
12
views
Does outlook permit searching in email headers?
I just noticed there is a specific header I would like to be able to search for. Is it possible to set up search on the basis of headers in Outlook 360? I see I can create a filter for a header, but ...
- 1,452
0
votes
0
answers
25
views
Why isn't the Facebook 'switch profile' option visible on my account?
I have my personal FB profile (don't really use it) but I'm admin to 2 groups. When posting as admin in the groups, FB does not give me the option to switch profiles. I've troubleshooted all the ...
- 21
0
votes
0
answers
5
views
Facebook page I have admin rights to displays "This content isn't available at the moment""
My personal FB account is an admin of a FB page. When I view that FB page's public URL as my personal account, it displays the message
This content isn't available at the moment
If I create a new FB ...
- 183
1
vote
1
answer
44
views
Is it possible to get a list of addresses that are "outside your organization" in Outlook 365?
I use "Outlook on the Web" (OWA) to access my company email address.
Some emails that I receive include the following warning:
This sender do-not-reply@training.acme.com is from outside ...
- 1,452
2
votes
1
answer
37
views
How to invoke the dark theme selection on Google's search page?
This is for Firefox. I know there are extensions for dark themes, but I don't want to use it because it messes up certain websites and doesn't get back to normal even after removing the extension.
...
- 123
0
votes
1
answer
18
views
How to remove pins from Google Maps for closed businesses?
In Google Maps I have stars or "visit later" (green flag) pins for many locations. Sometimes these businesses close or move and the data associated with the original location disappears ...
- 211
-2
votes
2
answers
259
views
When one of my Slack messages receives an emoji reaction, where can I see when the emoji reaction was sent?
My Slack messages sometime receive emoji reactions. When one of my Slack messages receives an emoji reaction, where can I see when the emoji reaction was sent?
Example of emoji reaction:
Mouse over ...
0
votes
1
answer
29
views
QUERY function to return records with multiple criteria
I have a dataset on Google Sheets similar to below:
Name
Team
Account
Date
Jennifer
East
Meta
5/1/2023
Steve
East
Alphabet
4/1/2023
Claire
West
Google
4/23/2023
Roger
West
Apple
6/23/2023
Bob
...
- 19
1
vote
1
answer
22
views
Conditional Formatting to Highlight Cells in Row if any number is present, but NOT if a formula or blank cell is present
I am looking for a conditional formatting rule that will highlight cells in a given row that contain a number only, but NOT a formula and NOT blank cells.
Example of the sheet:
Number of cases ...
- 11
1
vote
1
answer
21
views
Google Sheets QUERY function to return records with multiple filter criteria based on cell reference
I have a dataset on Google Sheets similar to below.
Name
Team
Account
Date
Jennifer
East
Meta
5/1/2023
Steve
East
Alphabet
4/1/2023
Claire
West
Google
4/23/2023
Roger
West
Apple
6/23/2023
Bob
...
- 19
1
vote
1
answer
21
views
Copying directories of Lined documents in Google Drive
In Google Drive I have ~130 documents with links to other documents in the same folder. I want to copy the folder and share it with a third party without needing to manually update all the links.
...
- 11
-2
votes
1
answer
42
views
Apply the same conditional formatting custom rule to multiple ranges on the same sheet
I have created a weekly tracker on Google Sheets, with the days organized in columns K through AI. Each day has three columns dedicated to tasks, assigned personnel, and notes. I have successfully ...
- 7
0
votes
0
answers
29
views
Can I set up a filter for emails sent via a specific server in gmail?
I use gmail, and its a fairly old account so its probably floating around the internet from more innocent days.
I've noticed a good chunk of spam I have that's local to me is sent via the same service....
- 565
0
votes
2
answers
46
views
How can I watch an empty GitHub repository?
To watch a GitHub repository, I simply click on watch. E.g., from https://github.com/adobe-research/custom-diffusion:
I don't see the watch button in this empty GitHub repository https://github.com/...
-1
votes
1
answer
31
views
How do I filter text in a column in google sheets?
I have a column that contains text and numbers in the same cell.
I want to return all the rows from a column that contain both the number 1 and the number 2.
I tried using =regexmatch(E1,"1|2&...
1
vote
0
answers
30
views
How to filter a Notion database for a specific given date
I'm trying to connect multiple parts of my Notion so that it's easier to use day to day. For that reason, I made a calendar view in order to easily see the different things I put into notion every day....
- 11
0
votes
2
answers
71
views
Google Sheets, multi row tabs at bottom or locked tab
Is there a way to have multiple rows of tabs for the sheets at the bottom of the editor? Or failing that, is there a way I can lock one tab so it is always available and never "slid off the ...
- 101
1
vote
2
answers
40
views
Highlight duplicates from four or more separate range in the same sheet
I want to highlight duplicate value in four separate range for a lessons schedule using conditional formatting in google sheets, in this example there are four classes,
what i'm trying to achieve are ...
2
votes
2
answers
63
views
Is there a way to manage a gmail account without access to a cell phone?
My brother has Alzheimers, but still likes to send emails to his kids.
His email is a Gmail account.
Something changed and Apple Mail isn't letting him read mail. Mail is requiring some form of ...
0
votes
2
answers
113
views
What happens when you share a Google Doc with a non-Google user? What do you have to do to make it work? [closed]
If you create a Google Doc, click Share and then enter a non-Gmail-address and uncheck "Notify user" (I don't want to share the link using clear text e-mail in this specific case), ...
- 679
3
votes
1
answer
42
views
Filter out non-personal emails with Gmail filter
I would like to create an email filter in Gmail which moves all incoming messages which are not addressed to me (these are typically messages from mailing lists) to a folder named Lists. The filter ...
- 133
4
votes
2
answers
940
views
How to translate images with Google Translate in bulk?
My workflow for a single image: I go to https://translate.google.com/, click the "Images" button, click "Browse your computer" to choose an image, translate, download the ...
- 223
1
vote
1
answer
22
views
How do I conditionally format all cells that begin with an equals sign? [duplicate]
Is it possible to use conditional formatting in Google Sheets to only format cells that are formulas (i.e. begin with an = sign)? For example, I would like a cell containing =F2*30 to be highlighted ...
- 113
0
votes
1
answer
29
views
Where to find create App Password for Microsoft 365 Basic
I want to create an app password for use with an application that accepts a login and password only. The application is MailtoX Desktop. I'm using it to migrate Microsoft Online mail to Gmail.
The ...
- 905