All Questions

1
vote
1answer
19 views

How to get rid of MORE/LESS

In my label/Folder is the option for more or less labels. Since I have over a hundred labels, I find it a great nuisance to click every time to get more. I would like to remove the options so that I ...
0
votes
1answer
27 views

Search for text in multiple columns in multiple worksheets

I have 3 columns (Col1, Col2, Col3). All 3 columns are in their own worksheet (WS1, WS2, WS3). I want to search each cell in Col1 see if that cell matches anything within Col2 in WS2 then output "...
0
votes
1answer
21 views

Inaccurate output when using importrange vs manual input

I have a little problem using Google Sheets. I'm using importrange to get raw data from another sheet that I don't own. This is the sample raw data, then import it my own sheet here. Importing data ...
0
votes
0answers
10 views

Google+ update required

Since approx 1. March, my Android phone show a separate notice: Google+ update required Tap to download the latest version This is different than the regular Play Store notices that updates are ...
0
votes
0answers
16 views

Creating a twitter search link that references the user that clicked on said link

I was wondering if its possible to make a link of the formhttps://twitter.com/search?q=itunes.apple%20from%3A&src=typd where the search is performed on the whoever is logged in when it is clicked. ...
0
votes
1answer
23 views

How can I compute the permutations multiplication “like” table to a linear list?

I have a table that is structured like this. I would like to transform the table into the permutations of the table if we treated like a multiplication table. Into a list that looks like this. ...
0
votes
0answers
12 views

FireFox URL To Desktop Shortcut [migrated]

I am using an Apple Mac Mini OS is 10.13.6. My default browser is Firefox 65.0.1. I also have the Opera browser installed in the Applications folder. When ever I drag a URL to the Desktop the Icon ...
0
votes
0answers
5 views

How do I measure pageviews/clicks/and subscriptions from different Sign-up CTA Buttons on my site [migrated]

I want to measure where on my website sign-ups to newsletters come from. i.e. -Are signups coming from my homepage's signup CTA button at the top? -Are signups coming form my hompage's signup CTA ...
0
votes
0answers
14 views

Google Drive - How can I unzip multiple zip files? (using Wikunia's Google colab/python method)

I actually would've just posted this as a comment under @Wikunia's brilliant colab answer, here, but I'm new (sorry!!): Basically, that works, and it works perfectly, but I'd like to genericise it to ...
0
votes
1answer
14 views

How to move a row into another sheet?

In Google Sheets, I need to hide rows if column H says, "Completed" My preference would be to cut and copy the row to a new sheet if column F reads "Completed", but sounds more difficult. If you ...
0
votes
2answers
17 views

Github pages are not generating

The https://github.com/wolfv6/wfpb repository has four .org files: 1_wfpb_basics.org 2_wfpb_implementation.org 3_wfpb_advanced.org nutrition_confusion.org I am attempting to publish the above four ....
1
vote
1answer
6 views

Insert Today's Date in Google Sheets on Norwegian Keyboard

Ctrl+; should be the US way to insert today's date, but this doesn't work on my Norwegian keyboard. Is there somewhere I can look up what it should be?
0
votes
1answer
8 views

How can I navigate inside a spreadsheet cell immediately after typing text?

This seems like it's a blindingly simple question with an obvious answer yet I cannot figure out how to do it nor find solutions online. If I type some text into a Google Sheets spreadsheet cell and ...
1
vote
0answers
10 views

How can I generate a download link which downloads a google drive folder as a zip?

I know it is possible to generate a permanent download link for files on Google Drive. My question here is is there a way to generate a URL which will serve as a permanent download link for a Google ...
0
votes
1answer
15 views

Where are files that I shared with someone going after he deleted them

I recently discovered a really weird behavior with Google Drive. So here is my folder structure: Folder 1 `-- Folder 1-1 `--- File 1-1-1 `-- Folder 1-2 Folder 2 Folder 1 is shared with a friend User ...
0
votes
0answers
11 views

My Facebook events don't display those who have selected 'going' only 'interested'

I have posted a couple of events to my business Facebook page, and initially I used to be able to see who had selected "Going" and who had selected "Interested" as two separate lists. However now it ...
0
votes
1answer
19 views

Migrating from flickr to google photos

With flickr putting the kibosh on unlimited photos with the free account I'm wondering if there is a known automated way to migrate thousands of photos from my flickr account to google photos. I've ...
0
votes
0answers
7 views

Default to 'More Options' in Google Calender

In Google Calendar, when creating an event, I always utilize the options under 'More Options' (creating an all day event, modifying notifications, etc). I know it's only an extra click away, but with ...
1
vote
1answer
16 views

Count worked days per employee

I am creating a spreadsheet in Google Sheets for a client who wants the sheet to pull data from their Google Calendar to calculate how many days each employee works. They use Calendar for their ...
0
votes
1answer
25 views

Where did the “internet speed test” go?

If I Google Internet speed test Google should offer me a quick internet speed test box as the first result. I could test my internet speed without leaving the Google search page. Now, this box is ...
0
votes
2answers
48 views

Export All emails + Attachments in a Gmail (G-Suite) account to a folder structure

I Have 6 G-Suite email accounts I need to remove however some of my staff still requires the contents of those Gmail accounts as they span 3-6 years and have a lot of historical data. I am looking ...
0
votes
1answer
10 views

Unable to SUM column calculated by Array Formula

I've used Array Formula to calculate the total price for an order and I have a manual column next to it to note what has been paid. When I come to do a comparison of the two though, Google sheets ...
0
votes
1answer
12 views

All text in a cell before the “ - ” or “ : ”

Is the Query function capable of taking the contents of a cell and returning everything before the first instance of - or :? Here is a screenshot of what I mean: Obviously, this isn't my actual data,...
0
votes
0answers
15 views

Google script full up the database

I have make more questions for this topic, the scrips are working, but i will add more cells to the script. The script what i have. function myFunction() { var spreadsheet = SpreadsheetApp....
1
vote
1answer
14 views

Can conditional formatting reference other sheet?

I needed to check which indexes exist on another sheet. So for the A:A range, I made conditional formatting with the following formula: =COUNTIF('Other Sheet'!A:A;A1) That had a red error outline. ...
0
votes
1answer
15 views

Cell with multiple color formatting results only to first color being applied

If a Google Sheet cell has 2 Conditional formattings, one which changes only font color, one which changes only the background, only the first conditional formatting affects the cell. The reason ...
0
votes
0answers
26 views

Gmail custom email always inserts my email into To field

When replying to an email sent to my custom domain, gmail always inserts my email into To field and I have to manually remove it.
0
votes
1answer
9 views

How to rotate a curve in Draw.io?

I know how to rotate an object in Draw.io because usually there is an anchor where my mouse changes into the rotation mode. This is also explained in this tutorial: https://support.draw.io/display/DO/...
0
votes
1answer
37 views

How to plot weekly, monthly stock price in Google Sheets?

Help me with functions or formulas for google sheet to display UPTREND DOWNTREND BULLISH BEARISH of Daily weekly monthly quarterly stocks as seen in PIcture attached herewith Please help me build a ...
0
votes
1answer
15 views

How can I find and replace color in Draw.io?

I want to replace all the red in these shapes with blue. Is there a fast way to do that? Maybe replace "FF0000" with "0000FF" but I'm not sure how to do that on Draw.io
1
vote
0answers
7 views

Why is clicking on a Google search result sending me to a different page than just typing in the same URL?

I was trying to track down the website of a local nonprofit, so I typed its name into Google. The first result showed the organization's actual domain name, but the description was spam, and clicking ...
0
votes
1answer
9 views

How to move subfolders organized in Google Drive filed together in wrong folder?

How to move multiple subfolders that are organized in Google Drive under a coherent overall project heading that were accidentally all moved together into an unrelated file? Need to pull out this ...
0
votes
0answers
7 views

Google Sheet - Write Notes based on cell reference's formula result

In Google Sheet, I want to create a custom function to write a note based on cell reference's formula result. But based on the discussion on this link, I just able to write the notes ONLY when the ...
1
vote
3answers
51 views

Duration to seconds calculation

There are 3 columns in my google sheet with heading Start time (col C), End Time (col D) and time taken (col E). Column E is arrived by finding the difference between col D and col C. Now when I try ...
1
vote
1answer
11 views

check if cell is empty OR has a value, AND cell in row isn't empty then assess as true or false

I'm trying to format a column so that if the column A cell is NOT empty, AND the column H cell is either empty OR "no" =AND(NOT(ISBLANK($A$1:$A)), (OR(ISBLANK($H$1:$H)), (LOOKUP("no", $H$1:$H))))
0
votes
0answers
16 views

macro for google sheets that can transferm data

I have make a macro in google sheets for transfer data from a cel to an other cel function myscript(){ var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); spreadsheet.setActiveSheet(...
-1
votes
0answers
14 views

How to follow someone on Facebook when follow button is missing

For work purposes, I would like to follow a Facebook account (set up as an individual, not as an organization) but I would rather not send them a friend request. How can I follow them? I don't see the ...
0
votes
0answers
21 views

How to Set Up Specific Anti-Phishing Rules in G Suite?

G Suite admins have the ability to make G Suite go harder on phishing attacks in an organization by ticking some checkboxes here and there, but there doesn't seem to be an ability to check incoming ...
0
votes
1answer
11 views

Display the aspect ratio of the current video on YouTube?

I need to know the current video's aspect ratio on YouTube. Is there any extension that can detect and display?
1
vote
1answer
17 views

Named range in Data validation

I am having trouble getting a named range to work in the data-validation criteria selection. Given that my named range is "ContactRecord" and the rangeid=1234567890, in the data-validation criteria ...
0
votes
1answer
7 views

Google API: increasing quotas

I recently bought a web platform that uses Google Maps API, however the maximum quota set by Google is not enough for my need. My account already has a credit card for billing. I have not found any ...
0
votes
1answer
5 views

Flagging empty cells if date in another cell has passed

Good afternoon! I've created a test sheet to help visualize this - https://docs.google.com/spreadsheets/d/1-qHH4GfeIZz-7OBHFpp4trrFNg7l-gBHDT2MHg9tFmE/edit?usp=sharing I'm aiming to have cells ...
0
votes
1answer
8 views

Using the Wayback Machine without loading scrolling images on its front page

The Wayback Machine (https://web.archive.org) is very useful for finding old versions of websites. Unfortunately, its front page has a bar of horizontally moving images that take a long time to load. ...
0
votes
0answers
3 views

Google Form - inserting responses

I am using google form to capture a survey. I have about 7 questions regarding a conference lecture. I want to use google forms and was wondering if I can manually insert the responses?
-1
votes
0answers
85 views

Forgotten Facebook Id and password

I HAVE FORGOTTEN MY FACEBOOK ID AND PASSWORD. I HAVE FORGOTTEN THE ADDRESS OF MY RECOVERY EMAIL. I ONLY KNOW THE FIRST LETTER OF MY RECOVERY EMAIL THET IS 'E'. I DONT EVEN REMEMBER THE RECOVERY EMAIL ...
0
votes
0answers
7 views

Drawing fields within a UML Class Diagram when generating from CSV

I followed the example here: https://jgraph.github.io/drawio-tools/tools/csv.html To create a UML Class Diagram from CSV. All went well, however, there is no documentation or sample of how to create ...
2
votes
2answers
37 views

Is there a folder for JUST Archived email? NOT ALL MAIL

Is there an "Archives" file? On my old email on my phone, when you swiped left, you deleted it, on Gmail, apparently you are sending it to Archives. While trying to search for the folder, and follow ...
-1
votes
0answers
6 views

Only 1 of my pages is available to interact as?

Facebook has recently added the ability for pages to join groups. When I enter a group as myself, I'm presented with the choice join the group as one of my pages. However, the choice is just for a 1 ...
-1
votes
0answers
22 views

Collaborative Google Maps map with one of my SAVED maps

I have a several lists of places in Google Maps, which I put together by adding places with the save link and selecting the target list. Then I share one of these lists with the three dots under ...
1
vote
1answer
11 views

Ignore “joined the Hangout” notifications

I am in a Google Hangout conversation. All messages are interesting, so I enabled notifications. Unfortunately, many people join and leave (more than actual messages), and I receive a notification ...

15 30 50 per page