All Questions
33,749
questions
2
votes
1
answer
35
views
chart select data: there are more items than can fit in the menu
I have time series data with at least 250 data points. I graph the data with a Sheets Line Chart. I'd like to add some data points with labels to the graph via the Add Select Data Point option.
...
0
votes
0
answers
27
views
How can I logout all users from Google Workspace? [closed]
Due to a new password policy, we require to log out all users at midnight so they log in back and set a new password. How can I log them out in Google Workspace? This the only thing I found but it ...
0
votes
1
answer
21
views
Excluding specific range in Google Sheets
I have a range formula on a Google Sheet that pulls the next future date out from a column containing nothing but dates (column C), starting from the 4th row:
=MIN(FILTER(ARRAYFORMULA(C4:C),C4:C>...
-1
votes
1
answer
28
views
All Time Rolling Average based on string order with multiple conditions in the same column - Google Sheets
I'm trying to calculate the average $ amounts per category (X & Y) and their sub-categories (A,B,C,D,E) on a rolling basis based on past data that's on a string format. There are 2 types of ...
2
votes
1
answer
167
views
How to force uniqueness of cell in Google Spreadsheet with non-Latin text in cell?
I have Kannada text in my column and it's not working, but it worked fine with Latin text before. Kannada text is from a region near India. Here is my spreadsheet, there are too many rows to include ...
0
votes
1
answer
39
views
Rolling Average based on string order with multiple conditions in the same column in Google Sheets
I'm trying to calculate the average $ amounts per category (X & Y) and their sub-categories (A,B,C,D,E) on a rolling basis based on past data that's on a string format. There are 2 types of ...
0
votes
1
answer
80
views
All links for switching to Maps are missing from Google Search results [duplicate]
Problem with Google Search
When I perform a search at www.google.com while logged in to my profile, the results are now missing the normal Google product links I would see at the top of the page ...
0
votes
0
answers
18
views
Where can I add some private information on a video I uploaded on YouTube and publicly shared?
I uploaded a video on YouTube. I shared it publicly. Where can I add on YouTube some private information on a video? E.g., is there any field in the YouTube Studio that would allow me to write down ...
1
vote
0
answers
23
views
How to post videos longer than 15 minutes on Instagram?
Instagram does not let me post videos longer than 15 minutes and strictly gives a 15 minute limit on videos whenever I try to upload a video. However I’ve seen other people able to post videos longer ...
0
votes
1
answer
43
views
Why do some YouTube videos have a filename while others don't?
Some YouTube videos have a filename, e.g.:
and other don't:
Both others don't. Why? What decides whether a YouTube video has a filename?
2
votes
1
answer
737
views
Will mobile-friendly URLs still work in desktop browsers when Gmail retires their Basic HTML view in 2024?
I use the following "Mobile Gmail" links in Chrome browser on my laptop:
mail.google.com/mail/u/0/x/
m.gmail.com
mail.google.com/mail/mu/mp/
Google has announced that users can only use ...
0
votes
0
answers
11
views
I cannot remove a dead channel from my web slack "Workspace switcher"
An admin seems to have redirected a dead slack channel to its replacement.
When I am using Slack via a web browser and I click on the channel, it is redirected so I cannot sign out of it and I cannot ...
0
votes
0
answers
115
views
If a YouTube video is monetized, how can I see if the revenue goes to the channel’s owner, YouTube or a 3rd-party, if I'm not the video/channel owner?
I know that:
One can see if a video on YouTube is monetized if one is the video/channel owner.
One can see if a YouTube channel is monetized even if one is not the channel owner:
When you're on ...
1
vote
1
answer
13
views
Android (child) cannot make a purchase since iPhone (parent) doesn’t have Google play and therefore cannot add payment method to this app
I have an iPhone while my child has an Android. We use Family Link.
I want to approve an in-app purchase on his phone, and I understand that I need to add a payment method to my Google Play, but since ...
0
votes
1
answer
29
views
Does Google Sheets have a function to insert X number of Y characters within a cell? [duplicate]
I currently have a spreadsheet which requires a variable number of line breaks within a cell based on input data from another cell.
Long story short, I currently am using a brute force method to ...
0
votes
1
answer
21
views
Stuck at understanding how duplicate prevention formula works in Google Sheets
Many blog posts and educational sites tell us to use =countif($A$2:A2,A2)=1 in the selected range.
However, they don't explain it. And for me it doesn't work and since I can't understand it I can't ...
0
votes
0
answers
5
views
How to set different color themes to OS, web browsers and other programs [migrated]
These days I was suspecting something weird after the installation of my OS updates. I use the dark theme on my Pop_OS and automatically my web navigators Chrome and Firefox are synchronized with the ...
0
votes
1
answer
22
views
How to turn off smart paragraph selection in the Microsoft Word 365 Web app?
How do you turn off smart paragraph selection in the Microsoft Word Web app? There are a number of questions related to this, but they all are for the desktop app, not the web app; this is an example ...
0
votes
0
answers
16
views
How to fix emoji and special characters rendering inconsistently on Win10 in Google Doc created on Win 11 [closed]
I created a Google Doc on my Win11 machine using both emoji's and special characters.
When I opened it on my Win10 machine, the display of those was inconsistent.
The most curious part: they show ...
0
votes
0
answers
12
views
Unable to change geolocation through VPN is it advisable to consider changing the IP address? [migrated]
Unable to change geolocation through VPN; is it advisable to consider changing the IP address?
Lately, I've been experiencing difficulties in altering my geolocation through a VPN. I use a VPN service,...
0
votes
1
answer
16
views
Automatic way to select a range for a formula based on the date
I am creating a calculator where the user describes a list of tasks in Activities!B2:B, and in C2:C they rate 0-5. To separate each day, I've used a date for each task in A2:A (stylistically separated ...
0
votes
1
answer
16
views
Is there a way to access and manage a Slack Workflow as text?
Slack provides a visual editor for its Workflows, but I need to have all my organizations DevOps under source control (and as text).
Is there a way to access and manage a Slack Workflow as text?
0
votes
0
answers
7
views
Is there a software or application that can be used to create an appointment scheduling system with rule sets? [migrated]
I have been scouring the web looking for appointment scheduling software or an application that can be used to create an appointment scheduling system.
What I am looking for is an appointment system ...
1
vote
0
answers
22
views
Preserve leading whitespaces in commit message bodies (Redmine)
(see also the same issue in GitLab)
git log correctly displays indentation and alignment created by inserting leading whitespaces:
Do some cool stuff
class CoolStuffCapable
+ function doSomeCoolStuff ...
1
vote
0
answers
26
views
Preserve leading whitespaces in commit message bodies (GitLab)
(see also the same issue in Redmine)
git log correctly displays indentation and alignment created by inserting leading whitespaces:
Do some cool stuff
class CoolStuffCapable
+ function ...
0
votes
1
answer
41
views
Gmail option menu is blocked underneath context menu of your specific browser when right clicking on email [closed]
I was conducting a search result for certain emails in my Gmail account I found them and began selecting each one I wanted to move to a certain area in my gmail
However there was no option to move ...
1
vote
0
answers
23
views
ArrayFormula Trouble pulling data for just a year or just last 15 days No understanding how to do [closed]
Google sheet to see my problem
https://docs.google.com/spreadsheets/d/1e3sjPNDJ3crJVQIn9L-lKllXP0wvc9NC22cnjxCveEs/edit?usp=sharing
See separate tab (help)
See all Yellow Boxes........they have the ...
0
votes
0
answers
6
views
How to fix a 'damaged app' error message when the app can't be found [migrated]
I have been getting the error message "DeepL” is damaged and can’t be opened. You should move it to the Bin" on my Macbook (OS: 14.0 (23A344))
I tried searching for the app in Applications/...
2
votes
2
answers
137
views
How can I start a ChatGPT conversation from a URL?
I'm wondering if it might be possible to start a new OpenAI ChatGPT conversation by using a URL. I need to find some URL like https://chat.openai.com/chat?topic=why+is+the+sky+blue such that when I ...
1
vote
1
answer
61
views
How to combine ARRAYFORMULA + QUERY?
"Please advise on how to correctly input the formulas to get the desired result as shown in the picture.
Task:
https://docs.google.com/spreadsheets/d/14tpPliM_3b7RIikSimvdzLjkFq3CexPKbtOEuD4aIKU/...
-1
votes
0
answers
13
views
Automatically Format & Combine Cells [duplicate]
I have a pretty specific need and I’ve had a lot of trouble figuring how even to get started.
I have several columns of text. My goal is to combine them into one cell (per row), such that:
The first ...
0
votes
1
answer
24
views
Column Identifiers as Described in Query Language Reference (Version 0.7) not working
In the Query Language Reference document found at https://developers.google.com/chart/interactive/docs/querylanguage#Table_used_in_Examples it indicates the following as properties of data tables.
&...
0
votes
1
answer
30
views
If I search for `messageclass:meeting` in my emails with Outlook on the web, what kind of search is it doing?
On How can I only list emails that contain meeting invites with Outlook on the web?, one suggestion was to search for messageclass:meeting in my emails with Outlook on the web. It does return some ...
0
votes
0
answers
11
views
Issues accessing school Google Account, after getting locked out of it [migrated]
I just graduated this May and essentially, I had to get as many important files transported from my school account to my main before June. I'd say I did a good job of doing that, but not necessarily ...
0
votes
1
answer
21
views
Using created filter to filter specific value base on other cells value
I can't seem to figure this out. I am wonder if it is possible to create a filter for a column, and then filter that column based on another cells value. So I have created a filter for A column which ...
0
votes
0
answers
5
views
Strange effects in streaming with Facebook live [migrated]
I'm streaming some songs with a video in Facebook live using OBS Studio and VLC player. In some particular songs, I get the strange effect that the video speeds up. I could understand that the video ...
0
votes
0
answers
9
views
How to get user data from Foursquare/Swarm under GDPR? [migrated]
Is there a way to download all my contributed check-in and reviews data from Foursquare/Swarm?
The foursquare.com doesn't seem to have a way to log in with the old foursquare/swarm credentials.
Isn't ...
1
vote
1
answer
29
views
How to see chat titles in ChatGPT history?
They made ChatGPT to give title to each chat session and store them in history. Unfortunately, they forgot to give an ability to see these titles, since they are truncated and there is no way to make ...
1
vote
1
answer
88
views
How can I hide my Gmail profile picture from contacts?
For the last few weeks, I have started seeing people's Gmail profile pictures in my contacts list or when I call them.
I don't want any callers (whether in my contacts or not) to see my profile photo....
2
votes
0
answers
20
views
As a viewer of a YouTube video, can one see whether the video received a copyright claim?
I saw a video on YouTube. I am just a viewer: I have not uploaded that video to YouTube. Can I see whether the video received a copyright claim?
0
votes
0
answers
11
views
Data validation with 2 conditions [migrated]
I am looking for a conditional formatting formula that validates two conditions from another sheet.
I have Sheet1 and Sheet2: Sheet2 has daily records of workers such as time in and off, Sheet2 ...
0
votes
0
answers
42
views
I added a few music tracks to my YouTube video with YouTube Studio. How can I automatically have them play sequentially instead of simultaneously?
I have a 30-minute video YouTube. I use YouTube Studio to add some music from YouTube Audio Library. I've added 5 tracks from YouTube Audio Library. By default, these 5 tracks are stacked together at ...
1
vote
1
answer
41
views
Format a numbered list in google docs into a table template?
I have a list with a url, an emoji (of a set of 3), and a name in a numbered list.
Taking a list like this:
https://news.ycombinator.com/item?id=38122061 🥾 D. onohoe
https://news.ycombinator.com/...
-1
votes
1
answer
115
views
How can I only list emails that contain meeting invites with Outlook on the web?
I am cleaning my email inbox using Outlook on the web. I'd like to only list emails that contain meeting invites, so that I can see which ones to delete or archive. How can I only list emails that ...
0
votes
1
answer
34
views
Timestamp on change of another range
I have a Planning sheet that I use to follow budgets that are reported every week.
I'd like to have K7:18 stamped with a date when there is a change in the corresponding cell of I7:I18 range.
I cannot ...
0
votes
1
answer
43
views
How to find largest group of consecutive numbers
This is a complex ask, so I apologize if it's unclear and will be happy to clarify. I have a series of numbers (dice rolls, in this case), and I need a formula to do the following:
Find groups of ...
1
vote
1
answer
43
views
Conditional formatting based on frequency
I have a range (A1:L200) that has only numerical values (0-37).
I have a formula that shows the frequency that each value appears:
=FREQUENCY(A1:L200, N1:N38)
How can I use this formula or something ...
0
votes
0
answers
21
views
Putting a custom function in same file as Apps Scripts [duplicate]
I'm sure I'm missing something very simple, but here is my problem. I have a spreadsheet with an apps script that has global variables that require authorization (due to openBy). I want to add a ...
2
votes
0
answers
16
views
Is there an easy way to bulk unsubscribe from following users on Reddit?
I'm following hundreds of users (possibly a thousand) and would like to make a backup list of them and unfollow all of them, so I'm only subbed to actual subreddits.
Does anyone know of any way I ...
1
vote
0
answers
18
views
Change units of curve object types in Draw.io
I know I can select View > Units > Millimeters in the main menu, but even if I do that, it only seems to impact some of the objects I draw: circle, square, rectangle.
Unfortunately, for other ...