All Questions

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

How to create a Todoist task from a Telegram message and link each other by URL

Normally we work by creating topics on Telegram groups. Quite often we want to create a task after a discussion or decision in Todoist. Then we link the latest Telegram message to the Todoist. We do ...
chelder's user avatar
  • 371
1 vote
2 answers
24 views

Printing the date of a cell in the Google Apps Script console

I wrote in cell D1 the function "=today()", and in google apps script I'm trying to print it in this way: function myFunction() { const ss = SpreadsheetApp.getActive(); const ws = ss....
Federica Guidotti's user avatar
0 votes
2 answers
30 views

How can you calculate the distance between in a spreadsheet?

I want to calculate the distance between an address and multiple addresses in a list. I want to use this calculation to quickly determine which addresses fall within a delivery radius. The addresses ...
Mark C's user avatar
  • 101
0 votes
2 answers
29 views

Searching a specific word in urls containing specific characters in Google search

In Google search I wrote: "albero" inurl:(unipi OR unina OR unimi OR unimib OR polimi OR unito OR polito OR uniroma1 OR uniroma2 OR uniroma 3 OR units OR unitn OR unibz OR uniba OR poliba OR ...
Federica Guidotti's user avatar
2 votes
1 answer
40 views

Conditional formating max values over multiple rows

I have Google Sheets data in column pairs from Column B to AQ. Each column pair represents a single year with the first column containing order counts, Orders, and the second containing order totals ...
Wes B's user avatar
  • 21
1 vote
1 answer
12 views

I work 3-4 days a week, on an 8-week schedule. Is there a quick way to add this to Google Calendar?

I work 3-4 days a week, on an 8-week schedule. The days vary weekly during that schedule, but the schedule repeats after 8 weeks. Is there a quick way to add this to Google Calendar? Can I create an 8-...
Caz's user avatar
  • 11
-1 votes
1 answer
22 views

How can you open a Google Form that is closed without the owner account?

I was too late for a statistics quiz. How can you open a Google Form that is closed without the owner account?
Gum Cum's user avatar
-1 votes
1 answer
45 views

Does Google Account Recovery ever require BOTH a working recovery email and working recovery phone number?

Some members of Google Account community believed that: Without BOTH a current recovery email AND a current phone number, previously set up in the account, (both must be accessible and up to date), ...
sourcejedi's user avatar
0 votes
0 answers
10 views

Extracting web-publish exchange rates using google sheets IMPORTHTML function [duplicate]

I would like to extract specific exchange rates from two Thai banks: https://www.bangkokbank.com/en/Personal/Other-Services/View-Rates/Foreign-Exchange-Rates# https://exchangerate.krungthai.com/#/...
Maciej Tomczak's user avatar
2 votes
1 answer
34 views

Highlighting only text for google sheets

Is it possible to highlight individual text in Google Sheets, just like how you can on Google Docs or Slides?
Emma's user avatar
  • 21
0 votes
0 answers
20 views

How to prevent Google from changing the order of logged in accounts?

This happens on all the browsers randomly, most often when some account gets logged off, but also on other occassions. And if you have cached/stored URLs like these: https://mail.google.com/mail/u/1/#...
Destroy666's user avatar
1 vote
0 answers
15 views

How do we convert this table into wikitext format? [closed]

The following table is incorrectly formatted. { | Left<br>Column || Middle<br>Column || Right<br>Column | - | (UP, LEFT) || (UP, ) || Data 2 | - | Row ...
Theodore Shepard's user avatar
1 vote
1 answer
14 views

Sorting a range of data based on a column within that data

I have a set of data spanning columns A through P in Google Sheets. I would like to add a column in Q that will return the values of A based on the top values of column P. I assume this can be with ...
Colin Davis's user avatar
-1 votes
1 answer
19 views

What is the proper way to create an internal link in wikitext? [closed]

Our goal is to create an internal-facing hyper link such that.... the text people see with their eyes says "hot dogs" The page on mathematical strict total orderings is the destination ...
Theodore Shepard's user avatar
4 votes
2 answers
2k views

Converting "4.8 million" into an actual number

I have a sheet that has numeric records that are a mix of three different number types: 260,000 4.8 million 870 million 1.1 billion The first one is handled just fine as a number, but the ones ...
RobKohr's user avatar
  • 151
2 votes
1 answer
73 views

How to change Google Sheets interface language?

When for example opening some Google Sheet in a private tab without signing in to Google, the interface language is determined by the IP. So how to change the interface language to English?
vstepaniuk's user avatar
1 vote
1 answer
34 views

All of my group members' names are shown in bold and black font. How can I tell which have blocked me as an Admin?

I've read countless posts that state that an Admin can check their members list, and any of the members that have blocked Admins will show up as bold and black font. Not so...every member of my group ...
Libbie A's user avatar
1 vote
0 answers
22 views

Is there any case-sensitive search engine available? [closed]

This is not a duplicate of this question about Google. I am aware that the problem of distinguishing between, say, "GaP" (gallium phosphide), "gap" (hole), and "GAP" (...
Kotlopou's user avatar
  • 111
2 votes
0 answers
16 views

What's the criteria to be able to view the time recipients spent reading an email Outlook on the web?

I've sent an email using Outlook on the web. I read on Outlook on the web: "Not enough data to measure time spent reading this mail. What's the criteria to be able to view the time recipients ...
Franck Dernoncourt's user avatar
1 vote
0 answers
22 views

How to check if I've been banned on GitHub?

How can I check if my account has been banned by a repo or org on GitHub? I contributed several bug reports, feature requests, and a PR to a repo -- including some related to security & privacy/...
Michael Altfield's user avatar
3 votes
3 answers
360 views

Formula to count rows between positive values

I need a formula in Google Sheets to count the number of rows between each positive number in a column. In Column B of the table below, for every value in Column A that is less than, or equal to zero, ...
Yu Lun CHEN's user avatar
0 votes
1 answer
17 views

What's the minimum indentation for "is_contributor: false"? Why indentation?

This comment below indented the Reddit AutoModerator rule / user check "is_contributor: false" for 4 spaces. Why? Why can't you indent solely 1 space? Why indent at all? The is_contributor ...
user109440's user avatar
1 vote
0 answers
11 views

How can I view the most recently created repositories by a GitHub user or organization?

I am looking at a GitHub user or organization, e.g. https://github.com/orgs/adobe-research/ How can I view the most recently created repositories? I don't see any ~"sort by creation date" ...
Franck Dernoncourt's user avatar
1 vote
2 answers
32 views

Finding preceding n results from a list based on conditions in Google Sheets

I have the following list in a Google Sheet: List Apple Banana Pear Grapes Kiwi Mandarin Papaya Orange Tomato Plum Watermelon Based on these two following conditions, I'm trying to get ...
pfnanc's user avatar
  • 43
0 votes
2 answers
22 views

I wanted to set the maximum value of each unique input as active

In the example data below, for each unique SYS Name, the Status column is marked Active in the row with that SYS Name's highest Serial Number. In Status, Column C, for each unique Sys Name the row ...
Vintikon Indonesia Perkasa's user avatar
0 votes
0 answers
13 views

Add button missing in Facebook Page Roles

I’ve worked for weeks trying to add another person in Page Roles (whose name is missing as well) to my Facebook business account. It only has the one person that is assigned a roll currently; it has ...
Linda R.'s user avatar
1 vote
1 answer
34 views

In Google Sheets search for a string in a column, then return the row where found

In Google Sheets, I have two columns of data. The first column is labeled Category, and the second Contents I want to search Contents for a text string and return Category wherever it is matched. For ...
SeanJ's user avatar
  • 111
0 votes
0 answers
12 views

What could have changed that caused guests not to be able access a Slack channel anymore?

I have a Slack account through my organization. I created a Slack channel and invited 2 guests outside my organization to join my channel. They used to be able to use the Slack channel for 2 weeks, ...
Franck Dernoncourt's user avatar
0 votes
2 answers
27 views

Inverse column and row relationship

I have 2 sheets that looks like this: Manager Bob Manager Sally Manager Samuel Team A Team C Team G Team B Team X Team Y Team Z (Real data contains 25 columns and 40-50 rows) I would like to &...
FailedUnitTest's user avatar
2 votes
1 answer
149 views

alphanumerics in duration in sheets - how to convert to a number of minutes

Working in google sheets, I am getting input from another program in the form of "Xh Ym Zs" to track time. I'm trying to write a formula that will just yield a number of minutes, so "2h ...
user8531's user avatar
0 votes
0 answers
12 views

I'm unable to administor a YouTube Channel

My client created a YouTube channel, using his personal Gmail account, for his business. He's uploaded a number of videos of machinery and equipment that he has sold at auctions he runs. He wants to ...
Stacey Richards's user avatar
1 vote
0 answers
17 views

Deleting Google Sheets's row automatically after a specific date [closed]

I've the following table: My goal is to delete the 2th row automatically when the current date is equal to the date in the cell A2 plus 2 days. Example: in figure the A2 contains the date 10/04/2024 ...
Federica Guidotti's user avatar
2 votes
1 answer
38 views

I turned off crowd control and dialed down the spam filter on a subreddit I moderate. But why is Reddit still automatically removing my posts?

I signed up on Reddit but never posted anything. Then I created a new subreddit. I am its lone moderator. I winded down the spam filter, and turned off crowd control for posts as low as possible. See ...
user109440's user avatar
0 votes
0 answers
51 views

How can I filter emails with an empty body in Gmail? [duplicate]

I use Gmail. I want to list all emails where I am the sender, there are no attachments and have an empty body. How can I do so?
Franck Dernoncourt's user avatar
1 vote
0 answers
11 views

Reply to Gmail email [closed]

When I receive emails they are at the top of the screen. When I reply it's at the bottom. I know you can click on the 3 dots to get the whole conversation, but can you reply to the emails at the ...
Robyn Hoskins's user avatar
-1 votes
1 answer
16 views

Keep original header info for forwarded emails using Gmail filter [duplicate]

In Gmail, I set up a filter to forward specific emails to another email address (e.g., [email protected]). I want the forwarded emails to include the original header info at the top of the content of ...
johnnyho1415's user avatar
1 vote
1 answer
25 views

How can I view the percentage of recipients who opened an email in Outlook on the web?

I was able to view the percentage of recipients who opened an email in Outlook on the web: I don't know how that appeared. I only see this stats for that email, and I couldn't see it in the other ...
Franck Dernoncourt's user avatar
1 vote
1 answer
36 views

Edit TinyURL link destination on a free account

On a free TinyURL account, a TinyURL that you create cannot have its destination edited. Also, if you try to delete it, you are advised that it will be hidden from view, but that it still exists: ...
SAL's user avatar
  • 153
1 vote
2 answers
32 views

How do I make dropdown selections add value to a totals column in Google Sheets

Very new to Google sheets and very lost. I am trying to create an awards tracker for school Merits 2024 Ideally, I want to include drop down menus with options for each week we hand out merits at ...
MHLO17's user avatar
  • 13
-1 votes
1 answer
145 views

How to bring back clickable Google map in Google search results?

Recently Google made a really terrible change of not allowing the user to click the map in search results, who knows why. It normally opened Google Maps with the given location. I heard it's related ...
Destroy666's user avatar
0 votes
0 answers
7 views

How to see if Azure subscription is S0 or F0?

I want to access the Azure free tier of text-to-speech that includes 5 million characters in standard voices and 500,000 characters in neural voices, each month (this page, then click on "See all ...
emonigma's user avatar
  • 163
0 votes
0 answers
4 views

Reorganize Group page without triggering notifications

I'm the only admin of a Facebook Genealogy page. I have numerous files that I want to organize to make stuff easier to find however every change I make triggers a notification to all members. Is there ...
Harold Parsons's user avatar
0 votes
0 answers
4 views

Seen by feature on a Facebook group

I am an admin on a Facebook group but I can’t see the see the people who have seen the post. The other admin can and other members can but I can’t. The seen by is present and in bold but when I click ...
user325390's user avatar
1 vote
1 answer
24 views

Return the percentage of the month that has elapsed up to today's date

I want a formula to return the percentage of the month that has elapsed up to today's date. For example, if today is April 6, and April has 30 days, then the result would be 20%: 6 / 30 = 20% What ...
peterK88's user avatar
0 votes
0 answers
22 views

How to return multiple items from a range to a single cell as a list but user chooses how many items in Google Sheets?

I have variable lists that will have 200–1000 values in them. ex: 1 Reliable 2 Practical 3 Responsible 4 Organized 5 Detail-oriented 6 Logical 7 Hardworking 8 Dedicated 9 Honest 10 ...
kodarr's user avatar
  • 1
0 votes
0 answers
15 views

Google Contacts showing 2 conflicting count values

I have an Android phone. I check my Google Contacts on the web application and I am surprised to find that it is showing two different values for the number of contacts I have! Looks like the contacts ...
NoChance's user avatar
  • 113
1 vote
2 answers
43 views

Formula to calculate the sum of consecutive 0's and -1's

I am hoping someone can help me with a Google Sheets formula to calculate the minimum sum of consecutive 0s and -1s in a column. 0s and -1s are consecutive until interrupted by any other integer. For ...
Will's user avatar
  • 13
0 votes
1 answer
37 views

How can I see the size of an archive on archive.org?

E.g., https://archive.org/details/stack-exchange-images. How can I see the size of that archive, without having to download all the files or manually do the sum of the all file sizes?
Franck Dernoncourt's user avatar
1 vote
1 answer
21 views

Formula to return a value when the adjacent column's text contains any value from an array of text strings

In Google Sheets I have an array named "Tech_issues" with the following values: Array name value 1 value 2 value 3 value 4 Tech_issues crash froze glitch error I'm looking to create a ...
flipskyrain's user avatar
0 votes
0 answers
19 views

Google Sheet formula to search all columns that match a specific keyword and sum values from them [duplicate]

I'm trying to paste a formula on cell AS2 that searches the column names on Row 1 for an occurrence of a keyword and if that column has such a keyword on its title searches Row 2 for numeric values ...
MACC's user avatar
  • 101

15 30 50 per page