All Questions

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

Google Sheets SUMPRODUCT and IFS on different sheets

=ARRAYFORMULA(SUMPRODUCT((Products!B2:B=D2)*(IFS(H2="x",Products!D2:D,I2="x",Products!E2:E,J2="x",Products!F2:F)*(E2:E)))) I have a spreadsheet with an Orders sheet and a Products sheet. Product ...
0
votes
0answers
5 views

How to find _any_ formula error in a Google Sheet via a standard command (and not a script)?

For complex Google Sheets with many tabs (my teams effectively employ Google Sheets as a sort of database in these scenarios), is there a relatively-easy way to search for any and all formula errors (...
1
vote
2answers
101 views

Google Sheets - Get unique values from a column and return the values a single column

I was hoping to get some help and direction. I have two sheets--a 'Raw data' sheet and a 'Dashboard' sheet. A user would dump the raw data in the first sheet and the dashboard will summarise figures ...
1
vote
2answers
33 views

Mediawiki: Custom Namespaces How To

I understand that MediaWiki cannot have subwikis, rather custom Namespaces would be the closest one could get (source). In order to test this I created a Namespace as per Manual:Using custom ...
0
votes
0answers
5 views

Encrypt and decrypt video url in Django [closed]

I am developing a learning platform with Django Python. There will be a monthly subscription. People can watch videos and learn. I already made serving media files, videos, and images. Now I face a ...
0
votes
0answers
4 views

No edit icon for file of forked GitHub project on Chrome Browser

I am trying to add some details to the forked project and so i like to pull it to the main project i am searching the edit icon on ht page of GitHub project and i have seen this instruction but i can ...
0
votes
0answers
9 views

Google sheets: Count all value where condition

I'm trying to count how many "products" appear in my tables with the same value I made this little example to explain what I want: Values excepted (only the count): Apple with value 1 = 2 (...
0
votes
1answer
32 views

if cell B4=B1:B2, countif C1:E2=AAA

If have 2 tables. I need the count of AAA for a particular name in Table 2. Example: I need to count the number of times AAA occurs for Peter.
1
vote
1answer
14 views

How to combine two different columns

I have two different columns with emails and I'd like to display all the emails in a separate column in the spreadsheet. Both the columns can be extended further so I can't select all cells statically....
0
votes
1answer
35 views

How do Amazon AWS websites determine localization? [closed]

After short trip to Russia all websites insist on showing me Russian versions in Chrome. IE, I open the following in Chrome Incognito window https://aws.amazon.com/ec2/spot/pricing/ And I'm ...
0
votes
2answers
11 views

How to prevent row/column insertion/deletion from breaking links to other sheets?

Earlier I asked this question : How to create a link with content bound to other cell's content in Google sheets? And untill now the provided solution was working perfectly for me but now, the ...
5
votes
2answers
3k views

How can I select all cells that contain specific text in Google Sheets?

I have a spreadsheet that contains 20,000 cells. I want to select all cells that contain "foobar". How can I do this?
0
votes
1answer
110 views

How to create a custom route in Google Maps, then navigate it on a mobile?

When you get directions in Google Maps on the desktop, a route is generated which can then be changed by dragging new waypoints into the route. I would like to save this custom route and send it to ...
0
votes
1answer
3 views

is there a way to skip youtube ads by a click or button without waiting 5 seconds or more

It is frustrating having to wait 5 seconds each time or 10 seconds to see a repetitive or unwanted ad also you don't want to block ads using a blocker. is there an addon to do that with just one click
0
votes
1answer
279 views

Google Sheets: word count for a webpage content (url) for SEO

For SEO analysis, I am using Google Sheets to extract basic data from my own webpages. I am able to access page title, description, <h1> tags, or number of characters via LEN(): =IMPORTXML(A3, ...
0
votes
1answer
157 views

How long does one have to wait to be able to connect to web.wechat.com?

When trying to connect to connect to web.wechat.com, I get the error message: For account security, newly registered WeChat accounts are unable to log in to WeChat for Web. To use WeChat on a ...
0
votes
1answer
16 views

Can Facebook's Custom privacy setting ever include the public?

On Facebook, I occasionally see certain friends with their privacy settings set to Custom. When I comment on their posts, I don't want my comments to show up publicly, but I can't know whether they ...
1
vote
1answer
840 views

Is there a Google Play link that automatically starts playing music?

Main question: At the moment, when I want to play music I have to go here: play.google.com/music/listen#/home And then click the I'm Feeling Lucky icon or another playlist. I would like to have a ...
0
votes
1answer
128 views

How to link to a specific comment on Amazon

Some Amazon articles have hundreds of comments. How can I create a link to a specific one for sharing?
1
vote
1answer
380 views

How to import a .mathcha-file into mathtcha.io?

In mathcha it is possible to download the document as a .mathcha-file, as you can see in Figure_1. However there seems to be no way to import this .mathcha-file again. Even the "Menu" (see Figure_2) ...
1
vote
1answer
5k views

How to add family members to Google Account without payment profile?

I am trying to set up a Google family (to use Youtube and maybe other services together). So I follow the setup process: Open https://families.google.com/u/0/families Then "Invite family member&...
0
votes
1answer
17 views

Find duplicates across multiple columns

My spreadsheet contains information about companies and is structured ledger-like in this way: Company Quarter Revenues EBITDA A 2010.1 5 1 A 2010.2 6 1 B ...
0
votes
1answer
31 views

Where do I use the unique code to get back in to Facebook?

Luckily I can still get in on my phone, but it's suddenly using an old, discontinued, company email. I went through all the steps with Facebook and they have "mailed" me a 6 digit code, but ...
0
votes
2answers
396 views

Is there a shortcut to site:youtube.com (search for videos on Youtube directly from a search bar)?

I use different search engines and anytime I need to search specifically on google all I need to do is type !g Is there a shortcut for Youtube as well because typing site:youtube.com takes too much ...
0
votes
1answer
855 views

Adding location data to Google Photos

In Google Photos, when I view an individual photo in my web browser and click on the "i" (with a circle around it) to bring up the photo info, at the bottom of the info it says "Where was this taken?" ...
0
votes
1answer
42 views

How do I do some data validation dropdown items can be selectable by only owner of the document?

I have a Google Sheets document which is shared with nearly thirty people and I added data validation dropdown to all the cells to not entering different values except I defined. This data validation ...
0
votes
1answer
18 views

Google docs produces a pop up when copying and pasting nearly every time

When I copy and paste into google docs it almost always (3 times out of 4) produces the following box even when I use the keyboard shortcuts (on firefox). Is there any way to permanently tell it to ...
3
votes
0answers
893 views

How do I fix copy/paste in Google Documents?

At the beginning of this week, I noticed that I can no longer properly copy and paste into or out of a Google Document. I find that if I highlight more than one paragraph and press Edit / Copy or ctrl ...
0
votes
2answers
653 views

Is it possible to contact Facebook asking them to recover an account?

If someone can't recover his Facebook account by any mean. Is it possible to send his ID to Facebook and ask them to recover his account? Because earlier this year I filled a form asking Facebook to ...
0
votes
1answer
31 views

importrange & query

I don't have programming background, but as a novice, experiment with formulas on my own. I have two separate live sheets; On the 1st sheet (sheet A) tab F, when I write Y into any cell in Column O, ...
1
vote
1answer
28 views

How can I get notified of changes to certain columns in google sheets

Zapier only provides functionality to monitoring rows. How can I monitor changes to only specific columns? function sendEmailAlert() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var data = ...
0
votes
1answer
31 views

How can I reference a word in a dynamic cell for parameter 2 instead of having a fixed word in single quotes?

I want whatever value I enter into this cell - Sheet 2 Column D1 - to become part of my formula. And I need to be able to duplicate the sheets and have the "sheet 2" reference update to the duplicated ...
8
votes
4answers
10k views

How do I draw a polygon in draw.io?

I want to draw a free-hand polygon, to enclose certain portions of my diagram so I can identify them as being part of Phase I development, for example. Is there a polygon tool in draw.io?
0
votes
1answer
29 views

Import and SUM chosen (from drop-down) column to Sheet1 from Sheet2

What formula I can use in cell C2 to import one column from sheet 2 using a drop-down list? Here's the document.
0
votes
1answer
35 views

Emails to Google Groups email address aren't working

When I send an email to the an email address in Google Groups, I get the following error from Mail Delivery Subsystem mailer-daemon@googlemail.com We're writing to let you know that the group you ...
0
votes
1answer
29 views

How do I find my comments on YouTube

I posted a comment on a video and they created another part but I want to re-comment it on that video but quickly and it’s been like 1 month since I posted it is there a way to not have to scroll ...
3
votes
1answer
26 views

Using regex to select the text between two characters IF there is text

I have this text: <a class="_f5rco33" href="/account-settings"><div class="_ojs7nk">Account</div></a> And I want to grab the word "Account&...
0
votes
0answers
9 views

How to extract thousands of files from across multiple OneDrive folders [closed]

Essentially... I have 27 folders on OneDrive, each comprising thousands of files (.jpgs). I have generated a random list of 5,000 filenames (for reasons that aren't important), that I wish to transfer ...
0
votes
0answers
4 views

Outlook.com: when I select the “Other” message tab, the site crashes [closed]

In Outlook.com, when I move from "Focused" to "Other" message tab, I get a white screen with the message: Something Went Wrong There was something that went wrong with the ...
0
votes
0answers
3 views

Most popular on Rumble? [closed]

Is there any way to get a list with the most viewed videos on Rumble? And a list of users with most subscribers.
3
votes
1answer
66 views

How do image attachments affect Gmail quota?

Gmail seems to do some image processing when an image is uploaded, compressing the (JPG) image. There are also options to select the size of the image (small, best fit, original size). Also, there is ...
1
vote
1answer
15 views

Automated way to move Gmail image / video attachments to Google Photos

I'm running out of storage in my Google account. In order to save space, I'm trying to move many images and videos from Gmail into Google Photos with "high quality" (where Google Photos ...
4
votes
2answers
27k views

How to undo/ go back to a previous version in a Google Form

I deleted a certain section on my Google Form which has resulted in the deletion of the entire form. Does any one know if there is a way to fix this? Undo button is not working nor is the back button. ...
0
votes
1answer
29 views

Show student's result when they enter roll number in Google Form

I have a Google Sheet with all students subject marks, roll numbers, names. I'm thinking of following: Students are given URL of a Google Form. Only field there is for roll number. Once they entry ...
1
vote
0answers
9 views

How to migrate images in Gmail over to Google Photos? [duplicate]

I am approaching the 15GB limit of Google's free storage for Gmail and Drive. I have a lot of screenshots that I have sent with Gmail. I want to free up space but I don't want to delete any emails. ...
0
votes
0answers
566 views

My audio cuts out when others are speaking

When I'm on a group call on Zoom, I've noticed if there's any audio coming out of my speakers, my mic won't pick up my voice. So if there's background noise coming from someone else's computer, or if ...
0
votes
2answers
27 views

Alternative to a spreadsheet/Google Sheets for distributing one-time-use links?

I have a list of 1,000+ unique URLs for people to download a custom iPhone app that's on Apple Business Manager. Google Sheets allows everyone with the URL of the sheet to see the list, and they can ...
0
votes
1answer
187 views

How to create a row level calculated field in Google Data Studio?

If my table looks like: Date Conversions Clicks 2020-02-10 2 20 2020-02-09 50 80 And I'd like to add a calculated field of Ratio (conversions/clicks), which ...
0
votes
1answer
13 views

Tiddly Wiki tags list like in Tiddly Wiki Classic

In Tiddly Wiki classic I had a list with all Tiddlers tagged with the tag like the tiddlers name. Example: I had a tiddler named "Intro". When I have opened the tiddler "Intro" I ...
1
vote
1answer
100 views

Marketplace is no longer available

I am no longer able to see Marketplace. It says an error has occurred please try later. This is now happening for a month?

15 30 50 per page
1
2 3 4 5
615