All Questions

Filter by
Sorted by
Tagged with
0 votes
1 answer
13 views

How to create HTML mail in Gmail?

I would like to send an HTML mail using Gmail. Following https://www.campaignmonitor.com/blog/how-to/how-to-create-an-html-email-in-gmail/ I just copied my HTML into the message, but it did not work, ...
user avatar
  • 129
0 votes
0 answers
9 views

Does wordpress.com have any kind of official status or is it just a confusingly named hosting provider specializing in WordPress?

Does wordpress.com have any kind of official status or is it just a confusingly named hosting provider? I hear different things. I hear some say that it's a version of WordPress. (so maybe it uses a ...
user avatar
  • 2,643
0 votes
1 answer
15 views

Counting different types of text and producing specific text outcome

So I'm trying to create a tracker where I can gauge a pass/warning/fail status for each category. Under "Report Status", I wanted a function that can put out the text "Fail" if one ...
user avatar
0 votes
2 answers
28 views

Converting ARRAYFORMULA to range for SUMIF

I have a sheet that IMPORTRANGE's data from another spreadsheet, which contains a column with numerical values that are of type string. In another sheet I am trying to sum the values in that column ...
user avatar
  • 103
0 votes
1 answer
43 views

How to import only some of csv into Google Sheets

I'm trying to auto-import this huge csv file into Google Sheets, but when I use the importdata function, it tells me "Resource at URL contents exceeded maximum size." I'd like it to auto-...
user avatar
0 votes
1 answer
32 views

I'm asking how to sort specific grouped rows

I have a question that seems similar to this one: Sorting a sheet without losing group order I want to sort the Rows on the 2nd Tab of the Spreadsheet ("Sorted Sheet"), so that the rows ...
user avatar
0 votes
1 answer
29 views

Sorting multiple columns using formula

Give a sequence of columns, I want to sort each column individually using formula because of some reason. Eg. A B C D 4 7 2 5 1 8 1 3 9 3 4 7 4 Expected output A B C D 1 7 1 3 4 7 2 4 8 ...
user avatar
  • 3
0 votes
1 answer
9 views

Gmail "superset" label?

Let's say I have the label Lists/A, Lists/B, Lists/C, etc. How can I search for all messages tagged with Lists/<anything>?
user avatar
  • 101
0 votes
0 answers
13 views

Discord emojis in channel names stopped working

Instead of seeing the usual emojis in channel names, I'm showing a gray X. This also appears in the OS: It appears to be relegated to one system, but I'm at a loss as to what could be causing it. I ...
user avatar
  • 101
0 votes
1 answer
11 views

How to resolve the library catalog error: "Request data is missing. Please try again."

(The Toronto Public Library, like various other libraries, uses a library software suite named SirsiDynix Symphony. This software suite includes various modules, including an online catalogue.) I was ...
user avatar
0 votes
1 answer
16 views

Regexextract numbers from string

I have a regexextract formula which takes the year from Column A (column) - however this only works if the year is yyyy-yy format - however some of the years are only yyyy and it returns an error Is ...
user avatar
0 votes
0 answers
31 views

Is there a way to unhide a picture I was tagged by a friend on Facebook? Restore it to appear on my profile

SO, a friend tagged me on a photo we took from a recent trip. I have tag review on so I had to allow the post before it appears on my profile. There were five pictures and I accidentally clicked Hide ...
user avatar
  • 1
0 votes
0 answers
11 views

Top bar won't show more specific categories

Maybe a week ago, I've inadvertently accepted too fast a message from the YouTube desktop website asking if I wanted to have more new videos on my homepage or something similar. Now I only have some ...
user avatar
1 vote
1 answer
41 views

How to make a formula expand to new rows when new data is added?

I've got a set of data, a column of numbers in this case, that I want to automatically calculate moving averages for when new data is entered. Currently I'm doing this by using =TRIMMEAN($A$2:A2, 0.15)...
user avatar
1 vote
2 answers
34 views

Splitting JSON-Formatted Single Column Into Rows and Columns in Google Sheets

PROBLEM Since Google Sheets doesn't natively support JSON data, which I'm importing, I'm trying to split the data into a matrix of four columns and an unfixed number of rows using only Google Sheets's ...
user avatar
  • 193
0 votes
1 answer
22 views

Can I add another, different set of data to a row or column in the same sheet?

I am trying to enter some analytics data from Twitter. I want to sort things by month. In each month, I want to have columns for 1st best tweet, 2nd best tweet, etc. In each of these tweet columns, I ...
user avatar
  • 1
0 votes
1 answer
22 views

How to create a linked sheet that checks a box for a day if found and inserts text from another column

I'm trying to create a sheet in Google Sheets for my team that shows me what runners have run on what day of the week. Their activities are automatically imported via Zapier with dates from Strava ...
user avatar
0 votes
1 answer
22 views

Flattening the values (not formulae) of a summary sheet

I work at a company that owns a lot of film gear that they bring on freelance shoots. I'm trying to create a simple, streamlined way for them to notate what's brought on each shoot so that they don't ...
user avatar
0 votes
0 answers
15 views

Why isn't my formula working?

I am using the following formula: =ARRAY_CONSTRAIN(ARRAYFORMULA(IFERROR(INDEX('Pick Your Meals'!$E$1:$BIF$1,SMALL(IF('Pick Your Meals'!$E$130:$BIF$130>0,COLUMN('Pick Your Meals'!$E$1:$BIF$1)-COLUMN(...
user avatar
0 votes
0 answers
13 views

How to transfer large amount of emails between Gmail-accounts?

I have one Gmail account A and one Google Business (?)¹ account B. I want to transfer 50 000 mails from A to B. I have tried this before using IMAP and Thunderbird, Apple Mail etc. but it is unstable ...
user avatar
  • 541
0 votes
1 answer
44 views

Creating a dynamic 2d array

I have to create variable length sequences from a column along its rows. Eg- Suppose the column is as below 2 4 3 I want to create a sequence like this 2 | 1 | 2 4 | 1 | 2 | 3 | 4 3 | 1 | 2 | ...
user avatar
  • 3
0 votes
0 answers
14 views

Is it possible to create a Google image search URL for a specific size and color and text?

I'm creating a simple CMS, and I want to let users click a link in the administration panel to search for an image with specific attributes. These attributes are: Specific size (for example 1600*900) ...
user avatar
0 votes
0 answers
41 views

Why is Google not sending a 6 digit code to recovery email?

This happens in both two different scenarios: Setting up a recovery email for my Google account. The Gmail I put in doesn't receive any email from Google. Not on spam either. The Send a new code. ...
user avatar
  • 101
1 vote
1 answer
76 views

Choose format for new Date() in Google Apps Script

I have tried almost all suggestions on the internet, yet nothing seems to work. Maybe someone can help a newbie out. I am using this at the end of my script: sheet.appendRow([new Date(), null, text]); ...
user avatar
1 vote
2 answers
61 views

Changing the dot (.) into comma (,) in Google Sheets, how do I do that? (numerical pad, in Holland, for currency)

I already managed to change the dot on numerical pad into a comma in i.e. excel. But how do I do that in Google Sheets?
user avatar
3 votes
1 answer
126 views

Formula for matrix (dates in descending order)

As a sequel to this question Formula for matrix (dates in ascending order) how would the formula (=IF($B2="Apple",A2-SORT(FILTER(A:A,B:B="Pear", A:A<$A2),1,FALSE),"") ...
user avatar
  • 199
0 votes
1 answer
34 views

How do I simplify this formula to be expandable?

The Example sheet The formula: For all x from 1 to 10, if (Sell <= Buy * x) then x, else ">=10" I thought I might be able to cheat a little with the sequence function: =ARRAYFORMULA(...
user avatar
  • 3
3 votes
2 answers
127 views

Formula for matrix (dates in ascending order)

Firstly, apologies for this question but I couldn't really wrap my head on how to do this (ultimate aim is to put it in app scripts) Let's say I have a table that is updated daily showing the fruit ...
user avatar
  • 199
0 votes
1 answer
27 views

Google sheets: Single out certain words in string based on second string

I have one column with concatenated words, say international city names. Each cell in this column is different, but city names overlap. And I have one cell with concatenated words, say only German ...
user avatar
  • 1
0 votes
0 answers
7 views

How to delete entire group chat in Messenger?

Accidentally added someone to a private group chat. How can I delete the entire conversation so they won't see it?
user avatar
  • 1
0 votes
0 answers
24 views

How to edit/format/change date forat sequence of a existing data into another date format sequence?

I got a bank account statement xls sheet with date in format of DD/MM/YYYY i.e. 06/01/2019 in the original form, but when I'm trying to format it into DD-MON-YY it is taking the value as MM/DD/YYYY ...
user avatar
0 votes
0 answers
16 views

Can I see a user's previous comments on a certain YouTube channel?

Afaik: When using the YouTube app: I can go to a YouTube video, scroll down to comments and then tap on a person's profile picture to see the recent comments they've made on the channel plus the ...
user avatar
  • 201
0 votes
0 answers
11 views

My Facebook Page has no invite option

I am facing a problem for a few days and tried my best to get it out but couldn't. The problem is that the Page of my site has no more invite options. Before it was available and I also sent ...
user avatar
  • 1
1 vote
4 answers
51 views

Cell specifying the running total length

Context Here column C contains a running total of the last 5 items from column B. Formula The formula is straightforward: Question In the above, it's hardcoded for a running total of 5. What's a ...
user avatar
0 votes
0 answers
18 views

How to sum a column of variable length, starting at the first cell below the nearest blank cell

Can anybody help with this please? I need to sum a column of figures. The number of rows in the column will be variable, but will be a contiguous range, with no gaps. The range for the sum will start ...
user avatar
0 votes
0 answers
24 views

Facebook login issue

Someone else used my Facebook number to create a new Facebook account and I can't get login into my Facebook account because I forgot my password. And I've tried to recover my lost password but it ...
user avatar
  • 1
0 votes
0 answers
7 views

Google Meet revokes my ownership of meeting when I assign to company calendar

I'm trying to set up a Google Meeting. Everyone in the company has a calendar that is "owned" by a company Gmail account that was set up long before we got Google Workspace, so I create ...
user avatar
  • 448
0 votes
0 answers
26 views

How do I make a points system on Google Sheets?

I have a timetable where people can write their names into a box which correlates to a different duty they must complete. I want to assign a different value of “points” to each duty so that when a ...
user avatar
0 votes
1 answer
29 views

How do I keep exact text formatting when using a data validation dropdown list in Google Sheets?

I have a column that contains a bold number and a non-bold text part. I want to use this information as a drop-down selection list, but it currently isn't letting me keep the bold formatting on only ...
user avatar
0 votes
3 answers
32 views

Making a graph from data of one out every n lines

I have data that comes in batches of N values ("Y" values if you like) for a given index (or "X" value if you like). How to make N separate series in my graph for each entry of a ...
user avatar
  • 103
0 votes
0 answers
14 views

Gmail deliveredto operator not working for email alias addresses in Google Workspace

I am using Gmail on Google Workspace and I have multiple aliases setup on my root Gmail account (e.g. myusername@domain.com) such as: webmaster@mydomain.com admin@mydomian.com privacy@mydomain.com ...
user avatar
0 votes
0 answers
12 views

Free tile map servers for OpenStreetMap similar to openweathermap.org but for non-weather data?

https://openweathermap.org/api/weather-map-2 shows openweathermap has a free (limited, API key required) service that lets you pull maps in "slippy tile" format so they can be overlaid ...
user avatar
0 votes
0 answers
10 views

How can I see all my public events on my Google calendar?

Events on a Google Calendar calendar may be public or private. How can I see all my public events on my Google Calendar calendar?
user avatar
0 votes
0 answers
15 views

Blender insert vertices into a face

I am trying to insert a complex vertices structure into a face without disturbing the structure. See pictures what I need:
user avatar
1 vote
2 answers
32 views

Is setting a trigger for a function to run with a triggered function not allowed?

I would like my function freezeSunday to run at exactly at 1pm on Sunday. Since it does not appear that you can trigger a function to run at a precise time (only at a randomly selected time within a ...
user avatar
0 votes
0 answers
17 views

Google Sheets Margins in Print Settings Significantly Different than Printed PDF

I need to generate a PDF from a sheet in Google Sheets and I need the margins to be exactly as depicted in the print settings preview. As you can see in the picture below, the preview is differing ...
user avatar
0 votes
1 answer
35 views

How do I put the if function inside the lookup? - Daily Routine sheet

I have a sheet - daily routine which has two columns: activity and time as shown here Activity Time Sleep 😴 6:00 am Toilet 🚽 6:15 am Get ready for gym 🤸‍♂️ 6:30 am Exercise 💪 7:50 am ... ...
user avatar
  • 101
0 votes
0 answers
24 views

Insert Dropdown (Cell Range) from Google Sheets into Google Doc

I'm using Google Docs to collect a lot of information about property. Each property has its own Doc file. In this Doc, I have various Dropdown lists. I'm at the point where I need to update and add ...
user avatar
  • 101
0 votes
1 answer
18 views

Google Sheets - Is there a way to filter values but keep them in the respective rows they came from?

I'm looking for a way to filter values based on another column but keep them in the same rows they came from. Here's an example I created manually of the correct output: The goal here is to have a ...
user avatar
1 vote
2 answers
32 views

Google sheet, from 2 lists to flattened table

I have two independent columns with data. How could I use that data to then produce a flattened table like this:
user avatar
  • 113

15 30 50 per page
1
3 4
5
6 7
660