All Questions
33,693
questions
0
votes
0
answers
2
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 ...
0
votes
0
answers
4
views
Need help writing a PowerShell script to manipulate Google Photo album names [closed]
I have more than 500 albums in Google Photos. Most of them have titles in the form "month year <optional text>".
I'd like to rename them in the form "year month <optional text&...
0
votes
0
answers
15
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, ...
1
vote
1
answer
36
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
16
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,...
1
vote
0
answers
12
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 ...
3
votes
1
answer
24
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 ....
2
votes
1
answer
20
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 ...
0
votes
0
answers
4
views
iOS Slack app - Threads stuck bold / unread [migrated]
I have followed Slack's instructions to clear unread messages and still "Threads" is bold in my Slack app. It is not bold on my desktop app.
Slack's instructions:
Mark everything as read on ...
0
votes
0
answers
13
views
How to Open Private Webpages on a Bitnami Lightsail Instance via SSH [closed]
I have a Bitnami Lightsail instance on AWS with Debian OS, where I have successfully installed the Google Chrome browser. My goal is to create a web application similar to Facebook or WhatsApp Web, ...
1
vote
0
answers
6
views
How does GitHub pick "Popular repositories" for organizations when fork and watchers count is equal?
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 (?) ...
1
vote
1
answer
59
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=...
0
votes
0
answers
13
views
Repeated Facebook Account Suspension [closed]
I joined Facebook yesterday and my account was immediately suspended. I appealed the suspension and it let me in, and I joined one group. When I tried logging in later last night my account was ...
1
vote
0
answers
12
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 ...
0
votes
1
answer
36
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
votes
0
answers
18
views
Does Google Workspace provide alternative subdomains like Microsoft 365 for Business (xyz.onmicrosoft.com)? [closed]
TL;DR
What is the free subdomain provided by Google Workspace that is similar to the free xyz.onmicrosoft.com subdomains provided by Microsoft?
Let us say our business domain is www.mango.edu. We have ...
1
vote
2
answers
41
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
16
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. ...
-1
votes
1
answer
6
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 ...
0
votes
0
answers
10
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 ...
1
vote
0
answers
8
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 ...
1
vote
0
answers
8
views
VLookup - Wksht 1 has multiple values in 1 cell - search for values in columns to the right of matched values in Wksht 2, return the sum in wksht 1 [migrated]
I am using the VLOOKUP function to search for values in one workbook (Workbook 2 below, highlighted in blue cell F513 - 515,600.05 and cell F518 - 96,560.46) 6 columns to the right of column A, based ...
0
votes
0
answers
12
views
linkedIn account restriction issue not solved after so many days [closed]
LinkedIn support my account is restricted and I don't know the exact reason I know that my account got hacked but I recovered it and used it for a couple of days after that I got to know that my ...
0
votes
1
answer
9
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?
1
vote
0
answers
30
views
This phone number has already been used too many times for verification
tl;dr: When trying to login to Google account and getting "This phone number has already been used too many times for verification" error, is there anything else that I can do except for ...
1
vote
0
answers
7
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
10
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 ...
1
vote
0
answers
11
views
Google Calendar event notifications are being deleted [closed]
I have a calendar called "TODO" in the Google Calendar app, where I usually place all-day events with various repeatedness (usually 1 month). I add a specific notification to send me an ...
0
votes
0
answers
10
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&...
1
vote
0
answers
8
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 ...
1
vote
0
answers
12
views
How can an admin of a Facebook group automatically reject posts without photos?
You're an admin of a large Facebook group for selling used goods. How can you set up admin assist (or any other tool) such that the selling posts without photos are automatically rejected, and their ...
1
vote
0
answers
17
views
How can an admin of a Facebook group automatically reject membership requests without rule acceptance?
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 ...
0
votes
0
answers
14
views
How can an admin of a Facebook group limit the number of actions to 1 post or comment per week per member indefinitely without being bothered?
You're a member of a large Facebook group in which thousands of members can post and comment without approval. Non-members cannot post without approval. How can you indefinitely limit the number of ...
2
votes
1
answer
60
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 ...
1
vote
1
answer
16
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 ...
0
votes
1
answer
15
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 ...
0
votes
0
answers
5
views
Access to Google Drive [migrated]
I have my Google Drive set up on my organization's laptop. Does my company have access to or the ability to view the files I have on my Google Drive?
If yes, how can I keep it on my laptop and yet ...
0
votes
2
answers
38
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 ...
0
votes
0
answers
20
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:...
0
votes
0
answers
13
views
automatically sort data in google sheets [migrated]
I am a total newbie here trying to make my spreadsheet AUTOMATICALLY sort the data based on DATE. I've attached a photo of the spreadsheet I am using.
You'll notice a WORKDAY formula in column G. Once ...
1
vote
0
answers
15
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 ...
1
vote
0
answers
20
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 "+" ...
0
votes
0
answers
11
views
I AM HAVING PROBLEMS GETTING WHATSAPP MESSAGES [closed]
I got a new phone and opened a WhatsApp account with my previous WhatsApp number. but am not receiving WhatsApp messages from WhatsApp groups that I'm previously in.
I don't mind not getting previous ...
-2
votes
0
answers
18
views
Google Contact Issue "This Profile was Found...." [closed]
I have the same issue mentioned here:
Remove Google+ profile from Gmail contact?
But google plus is no longer active so i cant find a remedy?
Any suggestions?
2
votes
0
answers
7
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 ...
1
vote
0
answers
11
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 ...
1
vote
1
answer
34
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 ...
1
vote
0
answers
17
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 ...
0
votes
0
answers
10
views
Does slack have any sort of read receipt capabilities? [duplicate]
I'm curious if there's any such capability in Slack to receive a written notification, maybe by SlackBot or via email or something, which will notify me when an individual(s) have read a given message....
1
vote
1
answer
16
views
Stuck with a google sheets IF formula for generating boolean strings
I've been looking for a solution everywhere, but have been unsuccesful.
I'm trying to make a formula on google sheets, that would help me utilize all added keywords from a column B into a sourcing ...