All Questions

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

Need help with and Find Script

The function is not working. Anyone could help me? https://docs.google.com/spreadsheets/d/1jiwgi2OCtDL_59S2lTY2bt5BuPK0gYmhv5zZCSwWX1c/edit#gid=640530318 function Localizar() { var Cadastro = ...
user avatar
0 votes
0 answers
3 views

How can I create a unique list of data across columns containing text "Retailer Name"?

I have certain data where I want the unique Retailer name across multiple sheets and multiple columns containing "Retailer Name" as the heading. I've attached a screenshot of my data for ...
user avatar
0 votes
1 answer
7 views

Google Sheets formula to format substrings of column concatenation?

If I have a spreadsheet with columns for author, year, title, publication, etc, could I add a column that concatenates and formats those as a citation for a bibliography? It would be something like ...
user avatar
  • 255
0 votes
0 answers
5 views

Groups in Google Workspaces - what's the different types of groups?

I manage a Google Workspace Account. The account has several "groups": i.e., email lists. When I go into Admin > Groups, I don't see them (screenshot) But when I search by the group's ...
user avatar
0 votes
2 answers
10 views

Unique formula, to automatically add category of exercises from different columns into one list

I had a bunch of exercises listed on a sheet named 'exercise sheet', each in its own category. On a different sheet (my programming sheet), I used the formula =unique('exercise list'!B3:B) to pull ...
user avatar
0 votes
0 answers
12 views

How can I sum cells that have an inexact range?

I want to sum the number of reps on the RHS as a total, taking the top value that is optional to athlete performing the set. So 8-10 appears 5 times, 50 reps total. How do I make Google Sheets do a ...
user avatar
-1 votes
0 answers
4 views

I cant remember my gmail username and password and i have lost my phone what can i do? [duplicate]

I know the number I used but I dont have it anymore I cant recieve the code what to I do
user avatar
0 votes
1 answer
12 views

How do I sum values based on criteria in the same row?

How do I sum values horizontally that match the word "food" in cell A1. Example below:
user avatar
  • 1
0 votes
0 answers
4 views

Does Facebook restrict the number of search results you can get on on a per-account basis?

For the past two months or so, I've been getting very few results when I search for photos. Even common terms like "birthday party" return no more than 40 to 60 hits. It doesn't seem like a ...
user avatar
  • 277
0 votes
0 answers
6 views

How to export Google contacts with non-English characters?

When exporting Google contacts to csv format, all the non-English entries are labelled as question marks "?". How to export them properly?
user avatar
0 votes
0 answers
3 views

email date lost after moving between email boxes using Apple Mail [migrated]

My university has decided to move its working platform from Google to Microsoft and has asked everyone to manually move emails from Gmail to Microsoft Exchange using third-party software. I chose to ...
user avatar
  • 227
0 votes
0 answers
4 views

Unable to see chrom menu buttons [migrated]

How do I change the color of the menu buttons on chrome. As you can see from the image provided the refresh button is hardly visible. How can I change the color so I can more easily see the refresh ...
user avatar
1 vote
1 answer
24 views

How can I shorten this formula in Sheets?

In column A I have a long list of words (one per cell). My goal was to determine which words are made up of the same letters (e.g. Align, Lagging, and Ganglia, so repeated letters don't matter to me). ...
user avatar
1 vote
1 answer
13 views

Regexextract to get a text in the middle of string

SAMPLE SHEET I have data in a column in this format: 1 P01 - Product Name here - PAID IN FULL 2 P02 - Product2 Name here - PARTIALLY PAID 20 1 P03 - Product2 Name here I've been trying to ...
user avatar
  • 191
1 vote
0 answers
11 views

Search box to find if number entered falls in a range

I have a Google Sheet with a number in column B and another in column C. It is a number range that is produced daily. I am trying to create a search box that a user will type in a specific number they ...
user avatar
  • 11
0 votes
0 answers
9 views

Tab equivalent for Mac while searching from website in chrome bar [migrated]

For ex. In Windows Chrome if you type youtube.com on bar and press tab it enables a textbox to search on youtube, What's the equivalent in Mac OS?
user avatar
0 votes
0 answers
19 views

Can’t delete Marketplace custom message

Somehow a message I sent to a seller on Facebook Marketplace has been saved as my ‘custom message’, and pops up in the message field every time I open a listing. Although I have found it in settings, ...
user avatar
-1 votes
0 answers
5 views

How to use search engines to know which film/tv series is on Disney Plus without being a subscriber? [closed]

site:netflix.com -site:dvd.netflix.com "name of show" => Search if a show is on Netflix (enter to see if it's available in your country) site:primevideo.com "name of show" => ...
user avatar
0 votes
1 answer
7 views

How to find correct field name that is used for advanced searching

When doing advanced search in JIRA, how can know what is the backend field name for the highlighted label? I'm trying to filter only "Type = Epic" but when I try typing "Type" in ...
user avatar
  • 99
1 vote
1 answer
8 views

How to return a value from a row from the last column a text appears

I am having problems returning the correct value i need. I enter data on this table. And i want to return some values on the other table. In that second table i want to return the last date his name ...
user avatar
0 votes
0 answers
5 views

How to copy/import export segments to GA4 property?

I have more then 300 segments added in my Google Analytics Universal, now I wanted to move on GA4, so how can I transfer all data to GA4?
user avatar
0 votes
1 answer
18 views

How to Turn Data in Rows into Data in Columns but only when the rows share a key element in common (Pivot a table into a matrix?)

My student information system gives me multiple rows per student, each row showing one period in their schedule. I want rearrange the data so each row is the complete schedule for one student. Put ...
user avatar
-2 votes
0 answers
10 views

Google Sites: Select the meta image of a page [closed]

When I am sharing a link to a google site on a social network, the wrong image is fetched by the meta scraper of the social network. how can I select the image that will be the meta property="og:...
user avatar
-1 votes
0 answers
9 views

How do I send a SPAM email to my account to test my arrival at SPAM? [duplicate]

It would be best if there was an online tool for this purpose where I would give my email address and send it a spam email. I want to check if the settings for SPAM in Google Workspace Gmail are good.
user avatar
0 votes
0 answers
10 views

Outlook.com - count conversation as 1 message

In Outlook webmail service, I have the following settings: messages are grouped into conversations, messages are not automatically marked as read. I mark messages as read manually. When messages are ...
user avatar
0 votes
0 answers
10 views

Lookup In Multiple Sheets & Add Unique Identifier

I'm trying to create an email lookup worksheet that essentially lists the results of a search throughout multiple worksheets (all in the same Sheet document). As an example, I have "Sheet 1",...
user avatar
  • 1
-1 votes
1 answer
17 views

Mac Outlook we encountered a problem while verifying your identity [closed]

Same to me, this morning when open up Outlook, Google ask me to grant access to MS APP, after click "Allow". Outlook account still cannot connect to Gmail. "we encountered a problem ...
user avatar
  • 1
0 votes
0 answers
13 views

Script to send email with value when new value is entered in a column

I am looking to create a script which sends an email when a new value is entered into a specific column. As part of the email, I would information from the row in which the value is entered in. Is ...
user avatar
  • 1
0 votes
1 answer
17 views

How can I perform a search over only my direct messages in Slack?

I'd like to perform a search (e.g., "webapps") over my direct messages. How can I perform a search over only my direct messages in Slack?
user avatar
0 votes
3 answers
265 views

Can't connect to Gmail on outlook app: We encountered a problem while verifying your identity

Today my Gmail accounts on two different laptops both failed to be connected by the local outlook apps on Mac. Outlook popped up a Gmail log-in window but after logging in I was always presented with ...
user avatar
  • 227
0 votes
0 answers
12 views

Google Sheet Formula / Appscript with Google Form Results

I'm creating an automated Roster which takes Data via Google Forms. The Goal of this is for the Data to go into the Sheet that Google Forms Makes automatically. The issue I'm having is trying to get ...
user avatar
0 votes
0 answers
9 views

IMPORTRANGE contains specific columns with multiple answers

Example, one person can enter 5 events with several options for participating (both days or Sunday only or 1st go....) how do I get master1 sheet to only show contestants on Saturday and master2 only ...
user avatar
0 votes
0 answers
4 views

Details not editing on Groove music [migrated]

I'm trying to edit the info of the songs on GROOVE MUSIC, but I'm unable to do so. Plus if someone can suggest a fast way to segregate albums (or editing info) then please help me out :)
user avatar
  • 40
0 votes
1 answer
28 views

Any way to access the filter funnel icon via keyboard in Google Sheets?

It's not in the official docs, but is there by any chance a non-documented/hacky keyboard shortcut for the little green filter funnel which has to be clicked to bring the "filter by" menu? ...
user avatar
  • 131
0 votes
1 answer
10 views

Why does my onEdit macro error when checking on an edit in a specific cell and sheet?

I've been battling with this for several days and used many previous answers found on these site, as well as a few others, but still can't get my script to run as intended. I have a dropdown box on ...
user avatar
  • 11
0 votes
1 answer
19 views

How to find the next lowest available number from a list on Google Sheets

I'm looking to find a formula which I can use, to show, the next lowest available number for a range of Asset Tag 1 - 500 As an example if 1 has been used the next available number will be 2. However, ...
user avatar
0 votes
0 answers
16 views

Auto create new sheet when new data in column?

I'm trying to create a new sheet on google sheets whenever column B gets a new value. This sheet will be named the value that created it. . I also want to have a function in the new sheet that ...
user avatar
0 votes
1 answer
6 views

How do I hide my followers on my Spotify profile?

Users who visit my profile on Spotify can see who I follow and who my followers are. How do I hide this information so that it is not public?
user avatar
  • 567
0 votes
1 answer
15 views

Filter formula & adding notes

Outline of spreadsheet. I have a spreadsheet we use to add daily shipments of products. This is added to daily so is constantly changing. Some of these are shipped nationally and some internationally. ...
user avatar
  • 1
3 votes
3 answers
234 views

How to filter to show data that contain numbers greater or equal to "x"?

I have a google sheet with data that contains a column that is mixed both with text and numbers. I want to filter all to see which have numbers greater or equal to $500,000. or which column have the ...
user avatar
  • 33
0 votes
0 answers
15 views

Google Sheets - Calculate monthly income amount based on entered amount + selected frequency (weekly, biweekly, etc.)

I would like to calculate a monthly total figure for income amounts that happen with different frequencies. Person enters the amount of income. The frequency is selected from a drop down list. I need ...
user avatar
  • 1
0 votes
1 answer
28 views

How to disable Gmail Print's NEW [Quoted text hidden]?

Since an apparent recent change to Gmail, Print performs [Quoted text hidden] even on text that does not show the inline unhide button (defeating the previous workaround). Any workaround in Gmail? ...
user avatar
  • 262
0 votes
0 answers
15 views

We want to migrate around 250 TBs of data from our on-premises servers to an online solution

I am working on a new project for a customer, where the customer have 10 on-premises windows servers which contain on total around 250 TBs of data. and we want to migrate those data to an online ...
user avatar
  • 101
0 votes
0 answers
21 views

Get Ask and Bid Option Prices from Fidelity's Website Using Google Sheets

I was able to get ask/bid option prices for a particular option from Fidelity Brokerage's web site using Google Sheets and importXML - but no longer. I think the site changed. The website to access ...
user avatar
-1 votes
0 answers
11 views

How to show two web pages on one page? [closed]

I want to build a website where the first page, MainPage, has links to other pages; but instead of opening these other pages in new windows, as what normally happens with an tag, I want the linked ...
user avatar
  • 99
0 votes
1 answer
19 views

Convert link into coordinates

I need to somehow convert google maps link into geographical coordinates( longitude, latitude). Like in one column I have the link and in other two must be the coordinates.
user avatar
0 votes
0 answers
6 views

Assign Slack Members a Number

I can go to https://slack.com/admin/atlas/configure-profile and create a Number field for member profiles. That's easy enough. The problem, they can arbitrarily edit this field. I would like to assign ...
user avatar
0 votes
0 answers
11 views

Show number of responses in Google Form to people filling the form

I would like to know if there is a way to add to the form something like "X people filled the form" for people other than me. The option to show the summary of responses gives too much ...
user avatar
  • 1
0 votes
1 answer
20 views

Combine an array formula with query function

I want to know if there is a way that I can combine any of these 3 formulas. Sample Sheet I have in col. A3, this extracts the info in Data tab, and splits into rows: =arrayformula(substitute(...
user avatar
  • 191
1 vote
0 answers
12 views

Why 2 columns of the same value give different total?

Sample Data in Result Sheet I have a formula in A2 that extracts data & splits it into unit & product (A & B). I used the SUMIF formula to give the the total of each separate set of ...
user avatar
  • 191

15 30 50 per page
1
2 3 4 5
661