All Questions

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

Google Forms-Sheets and Query function

I have a google sheet that retrives data from a google forms. When I use the QUERY function to retreive data from the FormResponce1 sheet generated by the form and put it in an other sheet that I'm ...
-1
votes
0answers
11 views

Intrusive violates my privacy [closed]

I ried to create a seperate account of FB but FB wants an official ID. I honestly don't feel comfortable uploading my ID card to strangers to view. Why can't they just specific questions that only ...
1
vote
1answer
35 views

Convert string to real date time value?

Here is my current input: 14.05.20 12.37.01 And yes, as it shows, there is a line break in the cell... Here is example sheet: https://docs.google.com/spreadsheets/d/...
3
votes
1answer
19 views

How do you delete documents for good on Google Docs?

I have documents on Google Docs that I either don't want or need. However, when I delete them, leave the site, and then return, they're still there, like I haven't deleted them at all. If you know the ...
2
votes
2answers
42 views

Convert columns of ISO 8601 strings to dates in Google Sheets

I'm pulling data to my sheet from an API using an ImportJSON function. The data array contains mixed data, including several columns of ISO 8601 date strings in UTC. For example: 2020-06-02T00:00:00Z ...
0
votes
0answers
5 views

How to delete a google sheets row without affecting formula references [duplicate]

My question if you can help is about google sheets getting values from a google forms. i'm using the query function to get the populated rows once you submit your answer, the problem is that if I ...
1
vote
1answer
17 views

Google Sheets TIMEVALUE can't parse time string

=TIMEVALUE("14:15:30") returns a #VALUE! error "TIMEVALUE parameter '14:15:30' cannot be parsed to date/time". I searched the web for a bit, and according to some people the time string may use wrong ...
0
votes
0answers
7 views

Can you find the BBC Intelligence Squared podcast?

Within the context of subscribing to podcasts with TuneIn where is the BBC version for intelligence squared podcasts? The US version certainly has an RSS feed. I'd like to listen to BBC intelligence ...
0
votes
0answers
4 views

how to subscribe to a podcast with TuneIn?

I'm trying to understand and use TuneIn to its potential. With Google play it's easy enough to view subscribed podcasts: https://play.google.com/music/listen#/podcasts 'TuneIn` doesn't seem to have ...
0
votes
0answers
6 views

validationRegex to accept/validate listed characters [closed]

5 to 16 alpha or alphanumeric to include special characters such as: Hyphen ( - ) Slash ( / ) Backslash ( \ ) Asterisk ( * ) Dollar Sign ( $ ) Period ( . ) Ampersand ( & ) Comma ( , ) Number Sign ...
3
votes
1answer
19 views

How change name to emails sent out my outlook.com account, not Microsoft Outlook?

I want change my Outlook.com account name when people get emails from me. I'm talking about just outlook.com online, not Microsoft Outlook software you install.
-2
votes
0answers
9 views

Need a good online booking platform to handle nightly bookings and package reservations

I need the best online booking platform for a lodge to take nightly reservations for their different lodging units, in addition to multi-day packages, as well as nightly dinners that they offer. They ...
0
votes
0answers
12 views

How do I delete a message sent in messenger that has not yet been delivered?

Suppose I wanted to delete a message that has been sent, but hasn't been delivered yet, like the one in the screenshot. When I click on it and then click ‘Remove’, I only get the ‘Remove for You’ ...
0
votes
1answer
11 views

How to view Google Books previews on mobile device (Android or iOS)?

If you try to preview a book on books.google.com from an Android or iOS mobile phone or tablet, it's basically impossible. You cannot zoom in to read the text. For example: There is a Google Play ...
1
vote
0answers
30 views

How to change cell format on ImportHTML Function

I've used the ImportHTML function to scrape play-by-play information from Basketball Reference. I am using a Vlookup to create a rating system based on time, point different, and several other ...
0
votes
1answer
10 views

What happens to my file in shared folder after shared folder is no longer shared

If I upload a file into a shared folder on Google Drive, that file is automatically visible and available to everyone that has access to that shared folder. If the owner of the folder then removes ...
0
votes
0answers
9 views

How to create a formula to look at my most recent past 20 scores in a column and averages the lowest 8 scores

In Google Sheets I would like to create a formula to look at my most recent past 20 scores in a column and averages the lowest 8 scores. In another post I found the following formula that will ...
0
votes
0answers
2 views

How to Extract Email address from my emails in cPanel Webmail?

Is there any actual ways to extract Email address from all of my received email?
1
vote
1answer
5 views

Google Sheets value on chart off from source by very small fraction

Trying to figure out why Google Sheets chart is off from the source data by a small fraction. My sheet has 7 rows of data and a sum row. All data only has 2 decimal points and the sum obviously has 2 ...
0
votes
0answers
4 views

I have accepted new members to my Facebook group but they are not showing in member list?

I am the admin of a Facebook group. Today I received 80ish new member requests to join my page. I accepted members one by one. Then I noticed that the number of my group members had not gone up ...
0
votes
0answers
5 views

Make Google search results link directly to linked page

Google search results usually link to google.com/url with a bunch of gibberish. How can I make them link directly to the result? I'd like a solution that works for both Chrome and Firefox
1
vote
0answers
6 views

How to force Slack to apply markdown within a word?

Slack has "recently" introduced its a bit annoying WYSIWYG "message composer" which breaks the message formatting with the inline markdown. Fortunately there is now also option called "format messages ...
1
vote
2answers
60 views

How to delete 100 thousand emails all at once?

I have this about 100 thousand emails in my Gmail, good thing it is under the "All Mail" label. How can I delete all my emails at once? The Gmail interface can only display 100 emails per page, ...
0
votes
1answer
17 views

Google sheets, how do I combine data from two cells, where there is a URL (web-link) in the cells, without loosing the link(url)

I have tried to write a custom function in google sheets. I tried to create a function to joint the content of two cells. It works for text, however it does not work if the text contains a web-link (...
0
votes
0answers
8 views

Hide played videos on YouTube

I have subscribed to some channels on YouTube and when I click on subscription I get an overview of all videos of all my channels. There are also videos that have already been played. Is there a view ...
0
votes
1answer
21 views

How to recover a long comment in Facebook after it has errored out

I typed a very long comment. Then I clicked post. I got a pop up message and it said only 8000 characters allowed. That pop up box had the message and a OK button that is it. So I click Ok and I came ...
1
vote
0answers
9 views

Data has both text and number, I need to move to another sheet from master but only the numbers show up…I need both

I've used this formula =query('Form Responses'!1:136,"Select * Where E='name'") but all I get is the numerical value entered in a cell. If someone enters both a number and text the cell is blank. In ...
-1
votes
0answers
9 views

“'IDBIndex' is not defined” in Edge Private window with VUE, Firebase [migrated]

I am facing a very weird issue and I don't know what is the root cause or how to investigate it further. I created a simple website with VUE, initialized Firebase with firebase init, using Firestore ...
0
votes
0answers
10 views

Why does Facebook increase the number of friends I have

Facebook says my friends are 693 in number but when I count,its only 423. I have sent a complaint to them yet nothing has been done. Does anyone know why this is so?
0
votes
0answers
10 views

IMPORTHTML - unable to import table

I try to import on my sheets a table o this url http://travian.kirilloid.ru/build.php#b=18&mb=1&s=1.45 I use this sintassi: =IMPORTHTML("http://travian.kirilloid.ru/build.php#b=18&mb=1&...
0
votes
1answer
20 views

What's the opposite of a 'static' website? [closed]

I attempted to explain that a particular challenge required the ability for a website to run scheduled background tasks, and therefore a static web site host would be inadequate, and a website / ...
1
vote
1answer
70 views

Find the last instance of multiple values

I really need some help with this. I need to search for the value of A2: B2 in another tab in google sheets and it needs to return the row number of last occurrence/entry of the values in A2: B2 in ...
0
votes
1answer
9 views

Ignore the cells which are blank [closed]

Making a test report | Need to count the cells which have value as Pass - If I have some blank cells inbetween how to ignore them
0
votes
0answers
6 views

Is there any good way to make room quickly for full Amazon Drive?

Amazon Drive says I've used up all my storage. I've deleted and then, manually, "permanently deleted" over 40,000 files, average 3 MB per file, in Amazon Drive. Yet, my backup keeps getting file ...
-2
votes
0answers
13 views

Using AWS to capture and store data (Python)

i have one script(Python) that get data from an specific web page, do the ETL and save the archive as .CSV on my desktop. I need to put this code inside AWS Amazon (I believe it must be AWS Glue), ...
1
vote
0answers
8 views

How to get date from my Garmin ForeRunner 225 or Garmin Connect?

I just switched to a Garmin running watch (ForeRunner 225), and am missing some very basic stuff. As far as I can see, Garmin Connect (online), only shows a pokey little map of my run (actual size): ...
0
votes
1answer
9 views

GitHub pages displaying markdown as plain text

I have a GitHub repository that uses GitHub pages. However, if you visit the README page, for example, you can quickly spot that it is showing up in the plain text, not markdown. Have I forgotten to ...
1
vote
1answer
16 views

Conditional Formatting w/multiple conditions and partial text match

I am working in google sheets and have a manual input quantity in column E. I am trying to write a conditional format that will highlight each cell in column E (or the whole row) that is greater than ...
1
vote
1answer
114 views

How to stop Google Chrome from highlighting things I click on?

Since the update on May 28, 2020, Google Chrome has decided to do this annoying new thing where, on many sites: When I click on a box that I can type in, it surrounds the text box in a black outline ...
0
votes
1answer
17 views

Configuring SendGrid properly to send emails as Gmail sender

I am trying to set up emailing facility for a small non profit organization. We use a gmail account as our official email and all emails are sent from that sender. Steps I already followed in ...
-1
votes
0answers
7 views

Joining google photo videos

i have no clue how to join google photo videos I need help to make a youtube video about my morning rutin so can someone please send me a site on how to join google phot videos
1
vote
0answers
12 views

How does one automatically generate a hyperlink for a cell containing a path?

I'm familiar with the HYPERLINK formula in Google Sheets to create links in a column, using a value in separate column as seen in this screenshot in row #2. I want the user to have the ability to ...
-1
votes
0answers
8 views

italics printing as bold

When I type in a new Google Doc document, using Chrome Version 81.0.4044.138, my italics look correct. When I go to print, they are then also bolded in print preview and print bold and italicized. ...
1
vote
0answers
11 views

Sending a customised Google Maps itinerary - as-is - to Android phone

I'd like to have a customised route available on my phone for turn-by-turn navigation. BY customised I mean an A-to-B-to-C-to... itinerary that has been dragged at various points along the route, ...
0
votes
0answers
5 views

How to remove “personal ad account” from Facebook Business Manager

I'd like to remove "Your Personal Ad Account" from Facebook Business Manager so I never accidentally use it. Apparently, I am trying to do the reverse of How To Move A Facebook Personal Ad Account ...
0
votes
0answers
14 views

I deleted a friend request and now I need to retrieve it again

I did not except a friend request by mistake. Now when I go to his page, it does not all me to add him as a friend. When he goes to my page, he can no longer add me as a friend either. Both of our ...
1
vote
0answers
11 views

Google Sheets script Filter copy and paste with format

I am looking for help to create a filter on a Google Sheets Script. I want the following: I have a database Schedule which has table with information that I want to filter Once the database A is ...
0
votes
0answers
7 views

Copy google sheet data by link

is there any google script to copy sheet data by sheet link or can paste it to Microsoft excel newly opened sheet.
-1
votes
0answers
6 views

Cyberduck “No login credentials could be found in the keychain” despite being there [migrated]

I'm using Cyberduck to get a listing/upload/download from S3. The problem is that it prompts me for the Access Key ID and Secret Access Key on every single operation, despite being instructed to save ...
0
votes
1answer
14 views

How to replace or substitute one column of data with their corresponding value from a list

I'm trying to replace a column of data (Prodct SKU) on one sheet (a) with the corresponding value taken from 2 columns on sheet (b) (Product SKU & Product ID). I've attached the spreadsheet to ...

15 30 50 per page