All Questions

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

How do I make Google search with multiple sets of filter conditions?

I'm trying to combine two search queries consisted of multiple search operators into one search query, but it's not working. 1st query: trade war site:bbc.com AND inurl:world-43512098 2nd query: ...
0
votes
0answers
2 views

Random grey horizontal lines in google sheets

Im having the exact same problem as in this post, but the fix didn't work for me: Random gray horizontal lines in Google Sheets - using Chrome and Opera I'm only using chrome. I'm on 100% zoom. ...
0
votes
1answer
8 views

How to make a cell highlight red if its less than 6 digits and NOT effect blank cells?

I use this function =LEN(P3:P)<6 in order to highlight all the entries with less than 6 digits (6 is minimum) However, all the blank cells also highlight red. What function do I have to do in ...
0
votes
0answers
4 views

In Google sheets script how do you email a date in a cell and control how it looks in email?

I'm building a Sheets Script add-on for sending invoices. In my sheet, I have a chart with the dates written along a row. When I use the MailApp.sendEmail() the date is printed in the email ...
0
votes
0answers
6 views

Auto increment date in sheets (for daily reports)

I have to manage a daily report sheet in which I have created a template/Format which is copied or duplicated by my team members every day. In the date col, I want the date to automatically update ...
0
votes
1answer
11 views

How can I receive money on PayPal without giving a country ID? How can I change PayPal nationality?

I made a PayPal account 8 months ago and signed up with another nationality mistakenly (choosing nationality before the sign up page at the time wasn't clear and many cities all over the world share ...
0
votes
0answers
7 views

How to create minor headings in google site?

I am unable to create a subheading under another subheading which is a minor heading. I tried indenting. But, that doesn't create minor heading in google sites. I am only able to create sub heading. I ...
-2
votes
0answers
10 views

Can’t see today’s Birthdays . Blurred

Started about 2 weeks ago. When I hit names on Birthdays using iPad, I can’t see anything, the page is blurred.
0
votes
3answers
31 views

Trying to run two scripts on same sheet and getting error

I found a code to run the two different scripts online, however i keep getting an error Missing ; before statement. Original function onEdit(e) { oneditfx1(e); oneditfx2(); } function ...
0
votes
1answer
7 views

How to Avoid nude & porn content in YouTube feed? [on hold]

I like YouTube very much for its help in information and knowledge but i always get very much disturbed n distracted when i see on my android in my YouTube feed in YouTube app , any video containing ...
1
vote
1answer
9 views

Does it exist an online map service that allows me to select what to view?

I want to take a screenshot of a map over a certain block in a European capital that should be "flat" and only list the street names on the surrounding streets, that is - no point of interests, labels,...
0
votes
0answers
7 views

Code to automatically duplicate a google spreadsheet

I want to automatically create a copy of an existing google spreadsheet that will have a name taken from a list. So when I add a name to that list the file will automatically duplicate with a specific ...
-1
votes
0answers
34 views

I want to recover my Gmail ID [duplicate]

I have no ID PW. I have no any other option so how can get my GMAIL PW. No contact NO mention in my GMAIL.
0
votes
0answers
4 views

How to move a row to another sheet based on date value

I want to move row to another tab based on date value. i.e. if the data is 90 days older from today the row should automatically transferred to another tab. Sample Sheet : https://docs.google.com/...
0
votes
0answers
4 views

How to search for all Wikimedia Commons images that depict a given Wikidata item?

Commons images have a "depicts" property. For instance this image of a dog has "depicts" set to dog. Question: How to show all media that depict dogs? In other words, all Wikimedia Commons files ...
0
votes
0answers
11 views

dropdown values from different sheet/spreadsheet

I have been following the tutorials of Learn Google Spreadsheets and are stuck with the following. In my HTML file, I have got a select/dropdown menu that gets the values from a spreadsheet. That's ...
0
votes
0answers
12 views

Creating direct link to access document in shared (Office 365 / sharepoint) folder

I need a way to access the access the following file via one-click. https://websiteName.sharepoint.com/folder/subfolder/document.pdf I have a link for guest access to the subfolder containing the ...
-2
votes
0answers
8 views

Calendar solution for a platform [on hold]

I am looking for a calendar solution that satisfies the following requirements: public (events can be viewed without logging in first) Good UX (web, mobile) GDPR compliant every user can add new ...
0
votes
0answers
14 views

Simple Client Area CMS

I am trying to build a client area to a website. It's a basic concept, yet I haven't found a simple solution. What it should look like: It's a password-protected area where each user has their login ...
0
votes
0answers
4 views

Require-context in React.js - getting file path dynamically [migrated]

I've been trying to set a file path as a variable, using require.context(). Require.context accepts three parameters: filepath, boolean if subfolders should be included and RegEx for file-name search ...
0
votes
0answers
7 views

Viewing & editing data in Google Sheets using a form

Question: Is there any way to view and edit data in Google Sheets in a form, like MS Access or OpenOffice Base can do that? It would be perfect if we could cycle through each record, which would be ...
1
vote
1answer
13 views

AND / OR Conditional Formatting for Google Sheets with multiple criteria

I am trying to write a custom formula to conditional format column E by referring to the different tenure level targets in column D to indicate if they are hitting their targets base off of their ...
-1
votes
0answers
7 views

Chrome does not autofill saved passwords [migrated]

Chrome browser does not autofill saved passwords, however the option is turned on in chrome://settings/passwords: Although there are no items in Saved Passwords, but all they can be accessed by ...
1
vote
1answer
11 views

What's the size of this “mini” video?

I want to know the size of YouTube's mini videos in pixels. i.e. the videos that show up usually at the end of a YouTube video by the owner of the channel. e.g. I want the exact size of that small ...
-2
votes
1answer
26 views

Google Sheets missing core range reference operators intersection+union/concatenation [on hold]

But Google Sheets' top competitors long have these core range reference operators: Microsoft Excel long has range operators intersection+union per official http://office.microsoft.com/en-us/excel-...
0
votes
1answer
17 views

How to reference a dynamic range in Google Sheets Script?

I have a sheet where the filter originally started on row 2, so my range was A2:J. As I've added and deleted rows/columns, my range has changed and it's still changing as I edit the sheet. Is there ...
1
vote
1answer
17 views

Query sum for unique pairs of rows

I have a spreadsheet which logs the duration an employee spends in a city. An employee can visit a city multiple times like Peter in this example. City Person Days London Tom ...
0
votes
0answers
3 views

In Slack, we start a quoted paragraph with '>>>'. How do we end a quoted paragraph?

In Slack, we start a quoted paragraph with >>>. Is there a way to end the quoted paragraph, and continue writing more unquoted text in the same message?
0
votes
1answer
39 views

In Gmail's Inbox, is there a way to know if I received a message as a 'To' or as a 'CC'?

When one looks at the listing of one's Gmail inbox, is there a way to distinguish only messages that were sent to the inbox as a To:, and not as CC: or BCC:?
-1
votes
0answers
24 views

Why are my Facebook photos losing quality?

The pictures on my Facebook account seem to have become more pixelated. I compared a photo with an old screenshot on Online Image Diff, and there really are differences. How could I get my original ...
0
votes
1answer
20 views

Cut and paste data from a row of cells from one tab to another tab in Google Sheets and repeat with new data

The below code works for Q3 but not for Q5. I'm relatively new to sheets and writing code and I'm sure that you can't have two functions with the same name but am unsure how to resolve so that I can ...
0
votes
1answer
8 views

Odd ProtonMail text modification in drafts

I have a text stored in ProtonMail's draft message. Once, I logon and I see odd modifications to my message: seems like < has been changed to &lt;. seems like > has been changed to &gt;...
1
vote
0answers
11 views

Update other sheet's rows based on pasted data

I have a worksheet with several sheets in it for social media analytics purposes. I would like to be able to paste data from a CSV I export daily into one sheet and have the data parsed and copied to ...
0
votes
0answers
29 views

How can one recover a locked Facebook without asking one's friends for help?

I logged into Facebook from a different country where I am typically located: the account got locked. It seems that one can unlock the account with different ways but as shown in the example below, it ...
1
vote
0answers
12 views

How can I send an email, with an attachment from the user's local storage, using Google Sheets Script?

I'm new to Google Script but quite experienced in Excel VBA. I'm trying to set up a Google Sheet to enable sending of a given document by email attachment to a number of recipients. I've got the email ...
0
votes
0answers
13 views

Copy the data from one sheet to another, assigned to a particular line

I have two google sheets. I need to copy the data from one sheet to another, assigned to a particular line. For the sake of ease of understanding, I changed the colors in the sheets example as they ...
-1
votes
0answers
9 views

Google Sheets pull data from second sheet where Row and Column are strings

I am trying to pull data from a different sheet in google sheets by matching row and column header EG SheetB LOC prox dist qty sjc 12 15 19 dfw 10 16 8 atl ord In ...
-1
votes
0answers
17 views

My currency not available [on hold]

I am from Maldives. My currency is MVR (Maldivian Rufiya) but it is not available in currency options when i tried to add products in my page. Is there any solution for this
0
votes
1answer
11 views

Countifs in between ranges

I'm struggling to pull below conditions together. I'd like to have a formula that will count values between 1 and 5 only when cell U13 contains the text 1-5. =COUNTIFS(U13,"1-5") =COUNTIFS(K2:K22,"&...
0
votes
0answers
10 views

How to disable pinning every message when forwarded from the channel?

I've linked the super group under Discussion Group section of the channel, so everything that is posted on the channel is being forwarded to the group. However, as the side effect, all messages are ...
0
votes
1answer
16 views

I want to get values from multiple URL's in Google Spreadsheet. IMPORTDATA doesnt work

I have 9000 lines with URL's in my Google Sheet. Example: https://steamcommunity.com/auction/ajaxgetgoovalueforitemtype/?appid=233860&item_type=10). Every URL returns JSON like this: { "success": ...
0
votes
1answer
22 views

How to partial extract from 3 columns with multiple levels of rules?

The formula someone on this forum provided worked well, but I have run into a problem, which I am struggling to get around. Google sheets Link The formula in H2 looks between 00 & 02 and ...
-2
votes
0answers
5 views

Which is the best/most used web UI builder? [on hold]

I would like to know what UI tool is used by most web developers - or you tinker with the CSS until the outcome is just right? I have a hard time creating the UI and it still looks ugly, even on my ...
-1
votes
0answers
22 views

How do I set the price information of my Facebook Marketplace listing to be 'Contact Seller'?

When I tried to post a listing to Facebook Marketplace, it seems that the price field of the form only allows numbers, and will disable the 'post' button if I did not enter a number. This is also the ...
0
votes
1answer
17 views

Google sheets spreadsheet will not format date correctly

I have a Google spreadsheet with a date column formatted to dd mmm yyyy. Many of the dates are formatted this way, but some cells will not format this way, and no matter what I select under "Format", "...
0
votes
0answers
7 views

Why do pictures of my Leaf dash display get tagged in Budapest

I take pictures of my Leaf dashboard display to monitor my miles-per-KWH. I recently uploaded to Google Photos all photos from my iPhone SE (running IOS 12.3.1). The Leaf display photos have been ...
0
votes
0answers
6 views

hide rows in Google Sheets based on cell value in a different row

I'm trying to build a worksheet in google sheets with a checkbox which will hide and unhide lines 5 thru 60. My checkbox is in cell A4, and when checked cell A4 says "hide", and unchecked cell A4 ...
0
votes
0answers
40 views

I hit the select button and all my emails disappeared. How do I retrieve them or where are they?

I hit the select button by accident and then all my emails disappeared. How do I retrieve them or where did they go?
1
vote
1answer
33 views

ArrayFormula to extract part of the string

I have come across the below formula, and I am finding it quite useful, I want to turn it into an array shortly, but before I do, I was wondering if there was an easier way to do this? =if(len(LEFT(...
1
vote
1answer
16 views

When I insert a row, indirect does not update

I have a summary sheet and I would like that every time I add a new sheet everything gets referenced to the summary sheet. I have used indirect to do this, the only flaw is that once I add a row, the ...

15 30 50 per page