All Questions
33,757
questions
0
votes
2
answers
81
views
How to specify topic instead of search term
I am using Google Trends to compare the search popularity of the programming languages Python and R. The issue I have is that the drop-down menu for selecting the type of search only appears once you ...
- 101
0
votes
2
answers
60
views
How can i get sum of data with specific date within table not just a column?
I'm need help to make formula. As the title said i need to get sum of data with specific date within table not just a column. Is that possible?
Here is the dataset below:
I tried to make some of ...
- 3
0
votes
1
answer
49
views
Formula to return count of duplicate dates based on multiple criteria
In Google Sheets, I have a column of dates in A and checkboxes in column B (Redeemed).
I want a formula to count, for each unique date, how many times it appears in the column where the following two ...
- 19
1
vote
0
answers
53
views
Unable to undo declined request to join
In the Activity log section of the group, I can see that another admin has declined a membership request, with the message:
{Admin} declined {Person's} request to join the group. [See details] [Undo]
...
- 301
2
votes
2
answers
94
views
How to combine ARRAYFORUMLA with INDIRECT to iterate over multiple sheets?
In Google Sheets I have employees' expense data.
Each sheet contains data for multiple employees, for a single month.
In a main sheet I have a formula that returns the SUM of all expenses for a single ...
- 21
3
votes
2
answers
905
views
Google Videos Search "sca_esv" query parameter possible tracking
When I search for something on Google and then go to Videos tab, I get a URL like
https://www.google.com/search?sca_esv=569877865&q=tester&tbm=vid&source=lnms&sa=X&ved=...
- 131
0
votes
2
answers
69
views
How can I format a cell to show the first and last characters and an ellipsis ... in the middle if the column isn't wide enough?
I'm using Google Sheets.
Let's say I have a cell whose value is a42c04ae-ea06-4992-b0bf-254943a7fdc2.
And I want it's column to be somewhat narrow, where unfortunately I won't be able to see the whole ...
- 714
1
vote
0
answers
140
views
How to solve "incorrect username or password"? [closed]
I suffer this same glitch. What's wrong? How do I correct this?
On 1 Oct 2023, Reddit suddenly signed me out when I was typing a comment. See screenshot below. But I know my WiFi was working, because ...
user317268
0
votes
1
answer
40
views
How to test one cell of numerical data against many numerical filters?
I have 50-digit long binary IDs (whose numbers correspond to qualitative data of a two-consonant long string) that I want to filter based on partial matches to what I call filter IDs, which are also ...
- 181
1
vote
0
answers
28
views
Change Google Organization Inbox Name [closed]
I'm looking to change the "nickname" of the inbox for my Google organization. I already tried changing the organization's name in the admin page but it still has not changed. I want to ...
- 11
1
vote
0
answers
31
views
Can I follow a user's activity on a Bugzilla instance?
There's a user who I see active on a bunch of bugs on a Bugzilla instance (= an installation of the bugzilla bug tracker on some website) I'm on. But - I don't see everything he's doing...
I know I ...
- 1,257
0
votes
1
answer
50
views
Google Sheets time in one cell cost in another
In Google Sheets, I want to be able to calculate a dollar amount based on the time of day entered.
I'd like to enter the time in one cell and have the formula in another cell calculate the cost.
These ...
- 1
0
votes
1
answer
23
views
Fill a column with dates for two days per week
I need to keep track of an employee who works Mondays and Thursdays. I need to fill a column with dates for these days. I know how to do sequential dates and I have tried dragging down from the corner ...
1
vote
1
answer
43
views
Adding (and updating) time stamp when cell color is changed in Google Sheets
I'm very new to scripts so please bear with me. I want to make a condition where if a cell color is changed, a new timestamp is created. So a cell will start from white (unused) and change to ~3 ...
- 11
0
votes
1
answer
32
views
How to reset the zoom to 100% via keyboard?
I have a fairly big draw.io diagram. I need to move and zoom around a lot. After navigating within the diagram, I would like to reset the zoom to 100%. However, I haven't found a way to do that ...
- 101
1
vote
0
answers
63
views
How to find a specific Trello card by card id or date
Our Trello board currently has about 500 cards on it. We can easily search by card number if it's three digits long, e.g. 123, but searching for two digit card numbers also returns three digit card ...
- 181
0
votes
1
answer
46
views
How can I view or search across all the group direct messages sent by Bob to groups where Alice is present in Slack?
I use https://slack.com/. I have group messages between the following groups (I am also a member of each of these groups):
Alice, Bob
Alice, Bob, Charlie
Bob, Charlie
Alice, Bob, Charlie, David
Bob, ...
- 17.3k
1
vote
1
answer
78
views
Clear cell value if cell in adjacent column is blank
In Google Sheets I have two data columns, S and T.
What formula would clear the value in T if the value in S is not RUN?
Sample Data
Before
S
T
1
...
2
votes
0
answers
26
views
Recreate a youtube playlist from a mhtml file
I've been adding music to my playlist for a long time and back it up often to a mhtml file, it has all the details of the normal playlist page and even has the urls of the songs when you click on them,...
- 21
0
votes
0
answers
35
views
How to enable Bing's "Chat with Video" feature?
There was a 'Chat with Video' feature on Bing that no longer appears in my account/region.
It allowed one to talk to a GPT instance that is knowledgeable on the topic of the video.
How do I enable ...
- 154
3
votes
1
answer
40
views
Gmail search by filetype is failing
I am trying to filter gmail searches using filename[filetype] syntax, specifically for .zip and .jar files.
When I try filetype:zip, for example, I am able to see exactly 6 results, which all include ....
- 131
2
votes
1
answer
61
views
Looking up two criteria in a table, one vertical, one horizontal and finding a value
I have a large table of data.
Column A is names
Columns C-I are monthly commissions. (Column C is March 2023, Column D is April 2023, etc)
Columns C-I are going to change regularly as we are pulling ...
1
vote
0
answers
26
views
How does GitHub pick "Popular repositories" for organizations when fork and watchers count is equal? [closed]
My mind still blows on looking for logic (if any) in which our organization's repositories GitHub picks for "Popular repositories". If all other factors are equal then the natural logic (?) ...
- 2,650
2
votes
1
answer
290
views
can't connect google workspace to Bard to give Bard access to Gmail
I am interested in having Bard summarise some emails..
I go here https://bard.google.com/chat
I click "help", it sends me here https://support.google.com/mail/answer/10079371?hl=en&sjid=...
- 3,004
1
vote
0
answers
30
views
fatal not a git repository Windows Self-Hosted runner GitHub Actions [closed]
I am trying to run git commands on windows self hosted runner which is configured on Amazon EC2 instance. I have installed the git bash on the same machine where my runner is configured and set it's ...
- 11
0
votes
1
answer
156
views
Insert space after every character of a text string
I'm trying to create a formula that takes a text string of unknown length and returns it after inserting a space between every character.
For example, if A1="FOO" then the formula should ...
1
vote
2
answers
57
views
Formula that looks for any matching substrings between two cells
In Google Sheets, I'm trying to compose a formula that compares the substrings in two cells.
Substrings in each cell are separated by a space.
The formula should return TRUE if any substring in one ...
0
votes
1
answer
23
views
Google Sheets complex formula or script is needed
I have trouble with creating a complex conditional formula in Google Sheets. Honestly, I feel there is a need for some script with a "for" cycle, but I'm not sure.
The task is the following. ...
- 103
-1
votes
1
answer
35
views
Periods are invalid characters for group names?
In Gmail usernames, periods are ignored characters, meaning that email sent to [email protected] and [email protected] will go to the same inbox.
I'm trying to setup a Google Group that has ...
1
vote
0
answers
82
views
Is it possible to tag or mention a person in Google Chat with just their first name?
In Google Chat, I would like to tag/mention a colleague using just their first name, not their entire name. Is this possible?
(This question is basically identical to this one, but for Google Chat ...
- 241
1
vote
0
answers
34
views
Combine responses in google forms
I made changes to a google form after I received several responses. They were minor edits like changing "yes" to "Yes" with a capital.
Can I combine the two sets of data so that ...
- 11
1
vote
1
answer
121
views
How to activate TOTP without phone number?
How can TOTP 2FA be activated on a Google account without first activating SMS 2FA, and therefore entering a phone number?
- 169
0
votes
1
answer
4k
views
This phone number has already been used too many times for verification
tl;dr: When trying to login to a new Google account I'm getting a "This phone number has already been used too many times for verification" error, but I don't have another phone number. Is ...
- 2,650
1
vote
0
answers
12
views
If I like a Reddit video, it should be automatically posted as a native video to Facebook-Pages and Twitter with help of IFTTT
How can I create the following applet using IFTTT:
If I like a Reddit video, it should be automatically posted as a native video to Facebook Pages and Twitter.
The same should apply for an album. I am ...
1
vote
0
answers
25
views
SMTP with app-passowrd of O365 does not work
I have an email address in Office 365 which I would like to use for a scanner's SMTP feature.
For this email address, I have enforced MFA to be able to set an app-password.
I give the following ...
- 111
1
vote
0
answers
11
views
Google Sheets query with sum and date? [duplicate]
I'm trying to write a query from the following table:
columns for date (A), description (B), amount (C), category (D)
I have this query:
=query(Transactions!A2:D501, "select D, sum(C) group by D&...
- 11
2
votes
0
answers
46
views
Is it possible to find out what email address is associated to a YouTube channel if "View Email Address" isn't there? [closed]
I'm trying to access my business YouTube channel and do not know the email address associated with it. The channel was set up by a previous employee and we have no idea what they used. How can I gain ...
- 21
1
vote
0
answers
61
views
How can an admin of a Facebook group automatically reject membership requests without rule acceptance? [closed]
You're an admin of a large Facebook group with a list of rules. To become a group member, a general Facebook user has to tick the box that he/she accepts the rules; no other questions are asked. How ...
user316742
3
votes
1
answer
100
views
Making a bubble chart in Goggle Sheets for year-on-year comparison - ie year versus month?
I'd like to make a multi-series bubble chart from 17 years of sporadic data with Year on the Y axis and Month+Day on the X axis and the bubble size corresponding to each data point's value.
I've ...
- 31
1
vote
1
answer
21
views
onEdit updates correctly, but then overwrites following columns after pasting (editing) multiple rows
I'm using Google Spreadsheets and found a script here:
onEdit only updates top row after pasting (editing) multiple rows
I manipulated the script to fit my needs, and I need it to only look at column ...
- 13
0
votes
1
answer
23
views
I have multiple unequally sized rows that I want to combine into a single matrix. How can this be done?
As stated by the title, I have various rows which do not contain equal amounts of data. Furthermore, the size of each row changes per user input on another sheet. I want to combine all these rows into ...
- 181
0
votes
2
answers
153
views
XPath Query to Retrieve Element Value and Name
Using the IMPORTXML function in Google Sheets, I'm trying to get the 'properties' element values from this link to appear with their element names as column headers.
Using the below XPath query ...
- 227
0
votes
1
answer
92
views
How can I search for equations that are displayed as [Equation] instead of the actual equation in a document in Word 365 online?
I use Word online via my Office 365 subscription. I have made an online copy of a Word document containing many equations. For some reasons, some equations got messed up in the process, and appears as:...
- 17.3k
1
vote
2
answers
229
views
How to prevent Google from showing any local results and ads?
Alternative question:
Is worldwide Google search (NCR) still available?
If Google is used from an internet segment with excessive SEO (for example, during travel), English queries will often be mixed ...
- 123
1
vote
0
answers
27
views
Gmail message sent issue [closed]
I sent someone a picture of my mothers social security card by accident they have not seen it through gmail into their personal work email.. and I don’t want her to see it if I report her as spam will ...
- 11
1
vote
0
answers
43
views
Why does my YouTube link on my Facebook profile redirecting to other account?
I added my YouTube handle to my Facebook profile. But whenever I click that link/handle, it redirects to someone else's YouTube account. How am I gonna fix this?
P.S. I have tried adding "+" ...
- 11
2
votes
0
answers
89
views
Automatically post/share to group as a page/from a page
Is there any way to automatically share posts from your own Facebook page to your own Facebook group, with the post showing that it came from the page?
I tried several automation tools, but the only ...
- 21
1
vote
0
answers
18
views
Random response or response from a set [closed]
Is there a way with mailchimp that you can set up an automated trigger or workflow that sends a different response based on criteria in the trigger, or just randomly?
The use-case is customer signs up ...
- 111
1
vote
1
answer
48
views
How can I retrieve a 2D array by its header?
What I am trying to accomplish here is to build a spreadsheet for meal planning.
On the left side, with the column header called dish ideas, I am logging all the individual ingredients of a recipe.
On ...
- 11
1
vote
0
answers
29
views
Gmail & Filters
I have set up filters in Gmail to attach a label to specific emails and have checked the box marked "skip inbox/put in the archive". However, some emails get marked with the correct label ...
- 11