All Questions

0
votes
1answer
16 views

How to use .setBorder based on cell content?

I'm completely new to programming and I'm trying to write this ridiculous easy script but it just won't work.. Anyone who can help me out? I think the script makes clear what I want to do but let ...
1
vote
1answer
22 views

How do I conditionally highlight cells

Not sure if I'm sharing this right but below is a link to my sheet. Cell C3 is past today so it is red. What I'm trying to do is have it go back to white when I enter the next "Last change" date in ...
-2
votes
0answers
22 views

Facebook messenger time stamp on messages

I just want to know if the time stamp on each message and the time it send a notification of a message from messanger are correct or if the notification email time stamp and message time stamp can be ...
0
votes
0answers
14 views

Keep original timestamp when saving gmail attachments

When I save to disk an attached file from gmail, the timestamp on it is the time that I am performing the save-to-disk. In MS Outlook, with a similar operation, the timestamp is the original ...
0
votes
1answer
16 views

Choose which photos in Google Photos to change from Original to High quality

I want to save some space in my Google storage. For Google Photos, I am using Original quality, which counts against my 15Gb quota. I know I can Recover storage, which changes all photos from ...
0
votes
1answer
34 views

Are WordPress Jetpack stats accurate?

I have a blog on WordPress running for a few months now, and is a free subscription. It has only the default Jetpack Analytics which shows Page views, visitors and the same by country. This is a tech ...
0
votes
2answers
14 views

Is there anyway to find the time stamp of a YouTube thumbnail?

A lot of channels are generating views from clickbait thumbnails. Is there a way to scan a video beforehand and determine the timestamp of the thumbnail, if it is even in there?
0
votes
1answer
9 views

Is it possible to make comments visible only to author and owner on Google Docs?

I've been thinking about using Google Docs to share a novel with a few beta-readers because it is simpler than sending every one of them a separate text file and keeping track of the comments across ...
1
vote
1answer
37 views

Calculate Work Hours

Given work hours for each weekday (let's say 9:00:00-17:00:00 Monday through Friday), a start timestamp (e.g., 1/15/2019 6:15:15) and end timestamp (e.g., 1/21/2019 14:35:10)... How can I get the ...
0
votes
4answers
24 views

How to pull the page number and the number of images listed from one sheet and then populate cells in another sheet accordingly?

Sorry, I didn't know how to summarize it in the title. Basically, I have a spreadsheet where I'm keeping track of the number of images that need to be on each page of a document I'm working on. On ...
0
votes
0answers
17 views

Can I like in Tinder with my voice?

Without tapping/clicking on my laptop, can I use my voice to like a profile? I have Siri on my Mac. Alternatively, I could make use of Google Assistant on my Xiaomi Mi A1? Is it possible? If yes, ...
-2
votes
0answers
23 views

Smart Facebook post permission management

I try to change all of my posts' permissions (revoke or grant permissions), but I want to do it in a clever way, so previous permission changes will be left untouched (let say I want to revoke from a ...
0
votes
2answers
29 views

Problem with QUERY(IMPORTRANGE()) to retrieve data

I’m having a problem with the =QUERY(IMPORTRANGE()) formula while retrieving a column data from one spreadsheet to another. =QUERY(IMPORTRANGE("spreedsheetURL","Sheet1!A2"),"select Col2 WHERE Col1 ...
1
vote
0answers
28 views

Printing emails including the attached PDF documents in Gmail

I am desperately looking for a solution how to print from Gmail (webinterface, no email client as Thunderbird etc) an email together with the PDF attachments into a single PDF document meaning I do ...
0
votes
0answers
6 views

How to attach a google sheet and send it as an email using GmailApp.sendEmail

I have a google sheet in Google Drive called "Finance 101". I try to attach this file and send it through GMail. I am able to receive the email but it arrived without any file attached. Any help will ...
1
vote
1answer
23 views

Does Forward All forward the thread to the emails IN the converation as well?

I recently used forward all in Gmail to send my probation officer a thread that has the contact of a person I can't make contact with. Does forward all forward the thread to the emails IN the ...
0
votes
0answers
50 views

Google sheets GOOGLEFINANCE command doesn't access certain stocks anymore

Up until a few days ago, I had no problems. Suddenly, the googlefinance function can no longer access the VGI stock. The exact error is "When evaluating GOOGLEFINANCE, Google Spreadsheets is not ...
1
vote
2answers
22 views

Query using date range doesn't work for specific data

I have a spreadsheet (URL below). I've set up a query to make sure I understand how to do a query with a date range. Then I tried to create a similar query on the "real" data. The "Week 1" worksheet ...
0
votes
1answer
295 views

How to find signup date for Gmail account? [duplicate]

I would like to find out the month and year I signed up for my current Gmail account.
1
vote
1answer
22 views

IF statement not working in Google Sheets?

So I'm using Google Sheets and I'm trying to determine whether or not cells in a certain column AO have a higher value then cells in another column O. My formula is =IF(AO6 > O6,"UNDER","OVER"). ...
0
votes
0answers
106 views

“Your Access has expired Reload this document to gain access. If you still don't have access, contact the document owner.”

I receive the above message in a dialog box when using Google Docs. It appears every 30 seconds or so. I can't shake it. Having read a bunch of the prior user content, I deleted all meta data, logged ...
0
votes
0answers
17 views

What is the correct privacy setting for a Facebook group if I want it to be searchable but hide the member list?

I want to create a Facebook group for an LGBT employee network at my company. I want it to show up when people search its name. At the same time I want the list of members to be hidden because of the ...
0
votes
1answer
10 views

Will Apple ID password also be changed automatically?

There is an apple id testmail@yahoo.com and a MacBook has been signed in with testmail@yahoo.com. Recently yahoo account (testmail@yahoo.com) password has been changed. Please let me know, by default,...
3
votes
1answer
257 views

Is it possible to block Facebook's sponsored ads using uBlock now that they separate “sponsored” text onto different divs?

If you inspect the word "sponsored" on Facebook's sponsored posts, you'll see they break the word up across multiple elements to bypass uBlock Origin and other blockers. Is there a way to still block ...
-1
votes
0answers
37 views

How to get my contacts to Google Sheets via script without down-or uploading

How to get my contacts to Google Sheets via sheet script without down-or uploading or importing exporting method. getAddress() doesn't work for me this is not an answer, but i have to, because the ...
0
votes
0answers
50 views

Google has issued my email address to another person

I have had an active Gmail account for many years. I have used this address for both private and business use. I have other emails forwarded to it for convenience as well. I have started to receive ...
0
votes
1answer
21 views

Upload Limit of Drive.File.Insert

While I use the following app script code to upload file from URL to GDrive it is executed flawless but when I change the source URL with a large file's URL (more than 1GB) it uploads only 50MB for ...
-1
votes
1answer
28 views

Why doesnt Instagram show which people saw the stories in some accounts?

Suddenly and with no apparent change, Instagram stopped showing me which people saw the stories in some accounts. Is there a way to revert this?
1
vote
1answer
16 views

Hiding and Unhiding columns based on prompt

I'm trying to make a template that hides and unhides columns based the value in G2. When a user will value from 1-5 in G2, certain columns will be shown, and certain columns will be hidden. ...
0
votes
0answers
20 views

How to make my profile picture unlikeable/uncommentable or just unclickable

I’ve heard about the ”only me” option but what Exactly does it do? Just so that my friends can comment and like the profile picture? Makes it unclickable but still visual for everyone? I’ve come ...
1
vote
0answers
36 views

Business account claim another person's business page for which I am the administrator

Here is the scenario: Another person no longer associated with our business created some pages for the business on their personal profile. The owner of the personal profile is currently an editor for ...
0
votes
2answers
19 views

What are the limits for channels and supergroups?

I've received the following message when joining another channel: Sorry, you have joined too many channels and supergroups. Please leave some before joining this one. I'm not sure on how many ...
1
vote
0answers
12 views

Copy formula every other row and every column

I have been playing with scripts to try and figure out this tedious task as there are 600ish rows in my sheet, times 4 sheets. So far I have come up with this function myFunction() { var ss =...
1
vote
1answer
12 views

Conditional Google Sheet Checkbox

I am creating a spreadsheet which can track all of the replacement items I am sending out for my business, however, I also want to be able to track my refunds on the same spreadsheet. I have got it so ...
1
vote
1answer
10 views

How to block specific YouTube videos

I want to block specify videos on YouTube. To be clear, I do not want to block: The whole channel Some keywords Video recommendations I just want to block a specific video given its URL and I want ...
1
vote
1answer
11 views

Conditional Format Copying in Google Sheets

I am looking to copy over a conditional format that changes the colour of an array of cells when checking a checkbox. This works perfectly fine on the first checkbox. However, when I try to replace ...
1
vote
2answers
17 views

Given a shared Dropbox link to an Excel file, how can I easily open it in Google Sheets?

Scenario: I get an email every two weeks with a vendor's price list as a link to an Excel file in their Dropbox. At this point, I have to: open the link — This takes me to Dropbox, where the file ...
0
votes
0answers
48 views

How to create a (recurring) Gmail Calendar Out of Office Event?

I’m going through the Google Calendar API, and I can’t find a way to mark an event as "Out of Office". I work from home every Thursday — and by default in the Gmail Calendar one cannot make OOO ...
0
votes
0answers
13 views

Searching in archived channels in Slack

Is there a way in Slack to do a text search in all channels - including archived channels? I have a lot of archived channels, so don't want to search them all individually and don't want to unarchive ...
1
vote
0answers
9 views

WordPress database dump

I have an offline WordPress installation I am using to explore WordPress and its tools, and have constructed a simple site. This is off-line and not accessible from the internet. I had dumped the ...
0
votes
1answer
54 views

How do I change the realname connected with an email on GoogleMail?

How do I permanently change the name related to an email that I have recieved and sent email to in the past on GoogleMail (gmail.com)? The user changed their realname (examples: changed surname, ...
1
vote
2answers
60 views

Cartesian Product with constraints

I have a really big database that I have to sort and divide as the example below: F1 F2 F3 C1 C2 C3 C4 results P1 X X X X X P1 ...
0
votes
1answer
14 views

Number in a cell linked with a text

I would like to ask if there is a solution to my problem: I have 200 numbers from 1 to 200 which are linked with text. For example: 1 = car, 2 = bicycle and so on. I would like to write a number (1) ...
1
vote
1answer
36 views

How to get the dot in my email to appear in “send mail as”?

I don't have a dot in my email but I signed up an Amazon/Audible account with a dot in it. Now I am trying to get a refund but they need the email to be sent from the email address with a dot. I went ...
1
vote
0answers
17 views

Is there a way to use Google's advanced search parameters without triggering the CAPTCHA test?

When using Googles advanced search operators, I only ever get about three or four tries before I start getting harassed by these perpetual reCAPTCHA turing tests: Yes, I'm human. No, I'm not a robot. ...
0
votes
0answers
31 views

G suite login issues

when I create an account in google admin and try to login into that account, it fails and redirects me to google admin portal. The error message that I get is that "We are sorry, but you do not have ...
0
votes
0answers
25 views

Autoforwarding to Gmail addresses is not working sporadically

This is a new problem, only started happening about two weeks ago. We autoforward emails from our domain mailboxes to groups of people, some of whom have Gmail addresses. Autoforwarding to email ...
0
votes
1answer
14 views

Prevent the stretching from changing cells border in Google spreadsheet

Is it possible to prevent the stretching from changing cells border in Google spreadsheet? I mean that if I stretch a cell which has a border above it, then the same border will be added to the cells ...
0
votes
0answers
4 views

How do add transit modes to an entry in my Google Maps timeline?

My Google Maps timeline often shows a single mode (walking for example) when I've used several (a walk, then a subway ride, then a bike). Some entries show multiple modes correctly automatically with ...
0
votes
1answer
12 views

Data Validation for Sheet1 from Sheet2 list

I'm trying to figure out how to validate data entries in one column on sheet 1 from a database I created in sheet 2. In column A sheet 1 the user is allowed to type in a string, upon completion it ...

15 30 50 per page