All Questions

Filter by
Sorted by
Tagged with
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. ...
The Buggser's user avatar
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 ...
starboy98.1's user avatar
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>...
Chris Douglas's user avatar
-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 ...
pfnanc's user avatar
  • 9
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 ...
Lance's user avatar
  • 257
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 ...
pfnanc's user avatar
  • 9
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 ...
nitro2k01's user avatar
  • 394
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 ...
Franck Dernoncourt's user avatar
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 ...
Ryan Amalfitano's user avatar
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?
Franck Dernoncourt's user avatar
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 ...
980980's user avatar
  • 29
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 ...
mplungjan's user avatar
  • 150
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 ...
Franck Dernoncourt's user avatar
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 ...
Pola Shriber's user avatar
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 ...
G0vnah's user avatar
  • 3
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 ...
Saeed Neamati's user avatar
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 ...
theEarlyRiser's user avatar
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 ...
Rylander's user avatar
  • 101
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 ...
Marjan Venema's user avatar
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,...
Tatti's user avatar
  • 1
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 ...
Louis S's user avatar
  • 15
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?
orome's user avatar
  • 660
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 ...
Zachery Becker's user avatar
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 ...
Zsar's user avatar
  • 121
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 ...
Zsar's user avatar
  • 121
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 ...
MolecularFae's user avatar
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 ...
jim groninger's user avatar
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/...
Sara J's user avatar
  • 1
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 ...
Kerrick Staley's user avatar
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/...
Сильный Могучий's user avatar
-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 ...
Paul's user avatar
  • 1
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. &...
Philip Wilson's user avatar
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 ...
Franck Dernoncourt's user avatar
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 ...
Kenny_Kodez's user avatar
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 ...
Linkinpark's user avatar
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 ...
Pablo's user avatar
  • 474
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 ...
ccpizza's user avatar
  • 347
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 ...
Dims's user avatar
  • 201
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....
Nipun Kulshreshtha's user avatar
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?
Franck Dernoncourt's user avatar
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 ...
Louis Cerato's user avatar
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 ...
Franck Dernoncourt's user avatar
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/...
Havok's user avatar
  • 11
-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 ...
Franck Dernoncourt's user avatar
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 ...
user318609's user avatar
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 ...
pub13's user avatar
  • 3
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 ...
Andrew Wade's user avatar
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 ...
E.B. Sandberg's user avatar
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 ...
Alex's user avatar
  • 121
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 ...
brumbarchris's user avatar

15 30 50 per page