All Questions
33,881
questions
0
votes
0
answers
4
views
On my Twitter wall there are some tweets I never wrote
On my Twitter wall there are some tweets I never wrote
They are in the form of a short reply to myself.
The content of the tweets are always like this:
I am in! iups
or
Invite friends! gaul
or
...
0
votes
0
answers
4
views
What is the best practice for notifying someone (not attending) of calendar events?
What I've done up to now is to add the recipients on as guests, then mark them as "Optional" for attendance, but I've always felt this isn't really representative usage of the guest list. ...
1
vote
0
answers
6
views
why is a person's name gone when I look them up on messenger but I can still see and visit their page?
On Facebook messenger when I try to look them up, I can't see the name of the person or call option. When I click on the person, it still says you are friends with this person and I can see the ...
0
votes
0
answers
2
views
Can I download emails "with all labels" from my school account (gsuite) to my personal account?
School authorities are going to close my email account (School's gsuite) in 7 days. I am planning to download all my emails to my personal account. But I am facing some pop server-related errors. My ...
0
votes
0
answers
10
views
Facebook Watch is not displaying video playback timeline [closed]
I'm using the latest Chrome (v109) with ad blocking extensions (uBlock).
When I open a video in Watch, I can see the volume control and the full screen icon with a barely visible pause icon but the ...
1
vote
0
answers
7
views
Is this Facebook, or do I have a rogue extension or whatnot?
Recently I have noticed that I'm getting new reaction emojis, or whatever, when I click on notifications in the notification list on Facebook.
Here's an example:
I'm talking about the row of faces ...
0
votes
0
answers
25
views
Why is the user asked before activating DRM in the web browser? [closed]
For example when surfing on soundcloud.com I am asked if I want to active DRM media. (This question is not about soundcloud but instead about the message shown by the browser in general.)
I know other ...
0
votes
0
answers
10
views
Invite workspace group email as optional?
Months ago I recall (maybe incorrectly) that in Google Calendar with my Google Workspace account I was able to invite Workspace groups (a group with an email address) to events and specify them as ...
0
votes
2
answers
20
views
Find a cell containing text in a range and return the text in that cell
I have a range of data where each row is in alphabetical order and I want to pull each cell in the row that contains "client" to another column.
0
votes
0
answers
5
views
Count words or characters in a Notion table view
In a Notion database (table View), I'd like to have the number of words/characters/sentence contained in each note.
Here is an example, where I tediously entered the count manually:
Is there a way to ...
0
votes
0
answers
10
views
How do you import cell fill color from another spreadsheet? [duplicate]
I am currently working on a spreadsheet with 100+ conditional formatting rules on columns, and the formatting rules significantly reduce initial page load speed. I already implemented IMPORTRANGE(), ...
1
vote
0
answers
9
views
How can I dynamically label Gmail messages based on a field in the header?
I would like to label each incoming message based on the List-ID header. I want this label to be generated dynamically as needed because of the volume of lists to which I am subscribed as well as the ...
0
votes
1
answer
11
views
Google Sheets - Auto group and sort
I've got a bunch of data, in this instance it's lists of fixtures for my son's juniors football team, which I'd like to order for ease. The age group is split into sub teams, e.g. U10 Reds, U10 Blues ...
0
votes
0
answers
5
views
interaction operator in quantum physics [closed]
openfermion.ops.InteractionOperator(
constant, one_body_tensor, two_body_tensor
)
I do not know how to use this interaction operator in computing eigen values of hamiltonian
thank you
0
votes
0
answers
26
views
How to aquiring a specific address that seems to be not in use, possibly my own? [duplicate]
Trying to register a new GMail address, I got the error message that the account is already in use, and I was proposed some ugly alternatives (which I did not like).
As I suspected I had used the ...
0
votes
2
answers
16
views
Excel style table in Google Sheets
In Excel, I can create a table (n.b., not a Pivot Table) through Insert > Table with headers where I can sort and filter the table among other functions.
Is there a similar functionality in Google ...
0
votes
0
answers
18
views
Is there a way to have Google Sheets automatically update a formula when a new row is added? [closed]
I am currently working with the following spreadsheet:
Spreadsheet image
The write rows under the dealer names is where information will be entered concerning deliveries made and the columns to the ...
0
votes
0
answers
4
views
Does deactivating a Twitter account delete its content? [closed]
When looking to delete a Twitter account, there is only a deactivate option, that will disable the account completely after 30 days. But the description of what will happen seems to avoid mentioning ...
0
votes
1
answer
12
views
Displaying Indian Number system (Lakhs and Crores) in Google Sheets
I want a custom formula for Google Sheets to format both crores and lakhs in Indian Number System. I have the custom formula for positive, but couldn't figure out how to add negative number system in ...
-1
votes
2
answers
17
views
Is it possible to select a column of dates in Google Sheets and change just the month?
I'm working on a spreadsheet with a different sheet for each month, and while I'm duplicating the sample data realized it would be easier to just select a column and change the month without changing ...
0
votes
1
answer
17
views
Repeat a table for each row of another table in excel
I have this table in Microsoft Excel:
Col A (Month)
Col B (Date)
January
1/1/2023
January
1/2/2023
January
1/3/2023
And I have another table:
Col C (Dept.)
Col D (KPI)
Dep1
KPI1
Dep1
KPI2
...
0
votes
0
answers
17
views
Can I query/search Google Calendar for all recurring entries with end dates?
How can I query/search Google Calendar for all recurring entries with end dates?
What I need is a list of:
Distinct scheduled meetings
Which are recurring
But ONLY those where recurrence ends (either ...
0
votes
0
answers
17
views
How can I prevent Slack from replacing ":)" with some emoji when I write a message?
By default, Slack replaces :) with some emoji when I write a message.
How can I prevent Slack from replacing ":)" with some emoji when I write a message?
0
votes
0
answers
3
views
My slack private channel does not have an admin or account manager, how can I add and admin and change the name of the channel?
Need to rename a channel with no managers or admins. Can I assign an admin or manager?
1
vote
0
answers
11
views
Is there any way to see when a youtube livestream started?
I was wondering if anyone knows a way to find out when a YouTube livestream started. I've tried googling around but can't seem to find a solution. Of course I can see the date of the stream, but I'm ...
0
votes
0
answers
14
views
GA4 Google Analytics: Data Keeps Cutting Off
We have about users who visit our website from about 140 countries each week. It's been like this for years on Universal Analytics and was like this on GA4 until a few weeks ago. Now GA4 is only ...
0
votes
0
answers
12
views
Integrating API on a Google spreadsheet to find VAT information [closed]
I am struggling to understand how to exploit the API from OpenAPI in Google Sheets. Specifically, I have a list of circa 2500 companies reporting only their VAT values, and I would like to exploit the ...
0
votes
1
answer
7
views
Teams shows badge number for notification about a message that I am currently viewing in Teams
I do not understand how the badge count in Microsoft teams work.
I am getting this taskbar icon appearance
even if the chat window that has the new message (showing in bold) is open already (I can ...
0
votes
0
answers
7
views
Volume up/down for a specific web browser tab [closed]
I am looking for any application that can change the volume of a specific tab of a web browser.
I do know a Chrome extension that can completely mute a tab but do not know anything that changes the ...
0
votes
0
answers
5
views
How to get company details using Importxml from this URL? [duplicate]
I need the list of companies from here https://www.capterra.com/event-management-software/ I am trying to use the Importxml formula but there seems to be an error. Can someone pls help.
The formula I ...
0
votes
1
answer
22
views
How to clear all 0 values from range except for one 0 value preceding data?
I have a table in a Google sheet that looks like this:
The data updates daily with a new column added after Column "Date" and is intended to track how quickly my team moves through projects....
-1
votes
0
answers
5
views
Building SEO for web app [closed]
We are building a web app from scratch using React and Node. Since we are a content courses platform and looking to get good Google search rankings, we need to build SEO components like yoast SEO. Do ...
1
vote
0
answers
10
views
Is there any reddit extension or setting which will allow me to toggle my moderator view of the subreddit? [closed]
I browse reddit on the browser. I use RES & Moderator Toolbox extensions on my browser.
I am a mod of a small subreddit.
Is there any extension or setting which will allows me to the toggle the ...
0
votes
1
answer
16
views
Formula to select certain people only
I have a spresdsheet in google sheets and use the following formula
=QUERY('Main Data'!A2:U,"select B, sum(J), sum(E),count(E), sum(F), count(F), sum(G), count(U),
WHERE A IS NOT NULL
AND O>=...
0
votes
0
answers
19
views
How to prevent the spellcheck website wordcounter.net from saving the text?
A year ago, I copied a small text in https://wordcounter.net to count the number of words. Recently, I wanted to use this site again, and I noticed that my previous text was still there.
Is there a ...
0
votes
0
answers
6
views
Filling out existing excel using Online Web Forms [closed]
I am currently looking for an open source solution (self hosted) for web forms, which allows me to automatically update an existing excel file each time a form is submitted.
Does anyone know of ...
0
votes
0
answers
4
views
When do you go away and offline in Microsoft Teams?
If I am logged into Teams in the web app and I leave my computer, change tab or window, how long does it take before I am marked as 'away' to other users?
What conditions cause my status to be set to '...
1
vote
3
answers
52
views
Repeat a sequence N times
I have this table
Name (Col A)
Start Date (Col B)
End Date (Col C)
Name_1
1/31/2023
2/2/2023
Name_2
1/16/2023
1/17/2023
and I am trying to change it to a long format, like this:
Name
Date
Name_1
...
-1
votes
0
answers
7
views
Google Calendar: list all "my calendar" events [closed]
On Android phone, if I create a new calendar entry, it automatically sets the:
event: "<to my email address>"
but in older times, I used a different app, which didn't had this default,...
1
vote
0
answers
14
views
How can I search for a string across all comments in a PDF on Acrobat Web?
I have opened a PDF on Acrobat Web. It has a few comments by others. How can I search for a string across all comments in a PDF on Acrobat Web?
-1
votes
0
answers
20
views
countif with AND/OR?
Let's say I have a running tally of responses from parents of kids.
I want to keep track of which kids' parents have responded A or B, but obviously do not want to double count if both parents have ...
0
votes
0
answers
10
views
Googlefinance historic currency exchange rate wrong
If in google sheets I do
=GOOGLEFINANCE("Currency:EURIDR")*GOOGLEFINANCE("Currency:IDREUR")
I get a value close to 1 as expected. (Product of exchange rate and reverse rate should ...
0
votes
1
answer
26
views
Check What Same Text Is Found In A List & List The Text
I have 2 columns of values. I want to create a formula that looks at Column A and finds what Column B text values are within in the Column A items. Then I want what matches to list in column C. I've ...
0
votes
0
answers
22
views
How to add payout account for facebook page after admin banning me from accessing old account?
i have a facebook page where i'm the owner and i had an admin who was manging it for me but taking most of the earnings of my page as he added his bank account as the payout account from (bussiness....
0
votes
0
answers
13
views
My university email uses Outlook (Office365) and has Two-Factor Authentication, and I want to use Gmail interface via SMTP. How do enable this?
I used to be able to use my Outlook (Office 365) email on Gmail by doing the simple SMTP settings, like the one illustrated here. However, my university recently had Two-Factor Authentication, so the ...
0
votes
1
answer
40
views
Choose top 5 scores from multiple columns with conditions
I am trying to automate a bowling statistics table. Each bowler has multiple games, one column for each.
The problem I am having is that I am using =J1>=LARGE($J$3:$K$22, 4) in conditional ...
0
votes
0
answers
4
views
How to bulk transcribe many audio files with Microsoft Word 365 for the web? [closed]
Microsoft Word 365 for the web has an impressive transcription facility that's not yet available in the desktop app. I have a lot of little audio files that require speech to text and would prefer to ...
0
votes
2
answers
23
views
Google Sheets: Arrays: using ARRAYFORMULA() v. { }
Why does this work: =ARRAYFORMULA(LEFT(A2:A13,1)),
but this doesn't: ={LEFT(A2:A13,1)}
ie, using ARRAYFORMULA returns the array: J
F
M
A
M
J
J
A
S
O
N
D, while using the braces instead of the formula, ...
-1
votes
0
answers
12
views
How can i show "Add friend" and "follow" option in same time on my Facebook profile? [closed]
How can I show "Add friend" and "follow" option in same time on my Facebook profile?
0
votes
0
answers
12
views
CTRL+left-mouse-button does not open all links in separate tab in Gmail messages [closed]
Steps to reproduce:
Copy/paste the following text into a new Gmail and send it to yourself:
CTRL+LMB PASS https://mail.google.com/mail/
CTRL+LMB PASS https://mail.google.com/
CTRL+LMB PASS https://...