All Questions
33,006
questions
0
votes
0
answers
4
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 ...
0
votes
0
answers
2
views
I cant remember my gmail username and password and i have lost my phone what can i do?
I know the number I used but I dont have it anymore I cant recieve the code what to I do
0
votes
1
answer
6
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:
0
votes
0
answers
3
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 ...
0
votes
0
answers
5
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?
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 ...
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 ...
1
vote
1
answer
17
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).
...
1
vote
1
answer
12
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 ...
1
vote
0
answers
10
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 ...
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?
0
votes
0
answers
13
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, ...
0
votes
0
answers
4
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" => ...
0
votes
1
answer
6
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 ...
1
vote
1
answer
7
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 ...
0
votes
0
answers
4
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?
0
votes
1
answer
17
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 ...
-1
votes
0
answers
9
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:...
0
votes
0
answers
8
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.
0
votes
0
answers
9
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 ...
0
votes
0
answers
9
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",...
0
votes
1
answer
16
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 ...
0
votes
0
answers
12
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 ...
0
votes
1
answer
15
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?
0
votes
3
answers
262
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 ...
0
votes
0
answers
11
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 ...
0
votes
0
answers
8
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 ...
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 :)
0
votes
1
answer
24
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? ...
0
votes
1
answer
9
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 ...
0
votes
1
answer
18
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, ...
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 ...
0
votes
1
answer
5
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?
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.
...
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 ...
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 ...
0
votes
1
answer
26
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?
...
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 ...
0
votes
0
answers
20
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 ...
-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 ...
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.
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 ...
0
votes
0
answers
10
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 ...
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(...
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 ...
1
vote
1
answer
14
views
Importrange based on name of country with single formula
I'm newbie about google sheet..
How to importrange from different sheet based on name of country
this my step:
the formula placing in sheet REKAP ALL IKU cell B5-B10---(in col. "country"). ...
0
votes
1
answer
25
views
How to view data easily by client and by assignment in Google Sheets?
I own a digital marketing agency and I started using Google Sheets as my project management tool. I have multiple clients that I work with.
So I have created a Google Sheet for all my project ...
-1
votes
0
answers
15
views
How do I bypass a website's idle timeout?
There are certain websites such as Gitpod, Google Colab, browserstack, they all have a idle timeout settings. Is there an extension or way to bypass these website's timeout settings? I tried changing ...
0
votes
0
answers
11
views
Is there a way to set up a "dead man's switch" in Zapier?
Suppose there is a task I need to carry out each week (say, taking out the trash, paying a bill, giving yourself medication, etc.). Rather than be reminded to do the task by having a Zap with a ...
0
votes
1
answer
19
views
Why is COUNTIF returning a 0? It should be returning a value of 8
I have a fairly simple countif function that counts how many items are 90 days old or more.
=COUNTIF(PROCFilter!H2:H,">=90")
But all this is returning is a value of 0, when I know that ...