All Questions

Filter by
Sorted by
Tagged with
1 vote
1 answer
36 views

How to apply "sendAlertEmailWhenCellValueIsNotEmpty" script to multiple tabs in Google Sheets

I would like to apply this to let's say "Weekly" and "Monthly" tab. Here's my script: function sendAlertEmailWhenCellValueIsNotEmpty(){ //send an email alert when cellToWatch is not empty //set ...
0 votes
0 answers
3 views

Filter out emails that don't have attachments [duplicate]

At my company, we are sent a variety of daily emails. These emails only contain valuable information if they have an attachment. Is there a way I can label, but archive (Skip inbox) the emails with no ...
1 vote
1 answer
2k views

Google Sheets Calendar Monday start of week

I don't want my weekday to start on a Sunday, who does? I want it to start on a Monday like most normal people, but impossible to find a way to do this. It's Ok on Google Calendar, you go to 'settings'...
0 votes
1 answer
18 views

Does forwarding e-mails to Tuta through Gmail compromise privacy no matter what?

I am using e-mail forwarding from Gmail to a tuta address (e-mail service with encryption) with 'delete Gmail's copy option'. Does that mean, that e-mails that get to my tuta inbox through Gmail are ...
0 votes
1 answer
235 views

How do I find out the total time spent on a Google Doc? [closed]

I'd like to find out the total time spent on a Google Doc. This is a similar question, How can I track the time spent and the number of words written in Google Docs?, but without any answers. There is ...
0 votes
1 answer
241 views

How to transfer the ownership of a Google Sheets document to another account outside of the Google Workspace organization without losing cell history?

I have a Google Workspace domain that I want to close in order to move completely to my a Google Workspace domain. Under the old account there is an important Google Sheets document, a list of client ...
1 vote
2 answers
4k views

How To Add Multiple Clickable Links in a Gmail Signature

I have an image of a signature that I'd like to add as my Gmail signature. That very image contains two small icons, LinkedIn and a globe (for my website). Now, what I want is the ability to add the ...
1 vote
1 answer
952 views

Using array formula in Google Sheet

Trying to make an ARRAYFORMULA that executes a query function which takes a reference to the current position of the row number and the specified column name. This is my version of formula: =...
1 vote
1 answer
1k views

Regex to match new lines created by automatic word wrapping

Google Docs find/replace supports regex but I've been unable to find a regular expression that will match new lines created by automatic word wrapping. Is there any way in Google Docs to match new ...
1 vote
2 answers
16 views

Printing the date of a cell in the Google Apps Script console

I wrote in cell D1 the function "=today()", and in google apps script I'm trying to print it in this way: function myFunction() { const ss = SpreadsheetApp.getActive(); const ws = ss....
2 votes
1 answer
293 views

Is it possible to get SMS texts for tweets from a specific user that match certain words?

I know that you can send an SMS text from Twitter for all tweets that you get from a specific user. But is it possible to only send texts when a tweet is from a specific user and that also match ...
0 votes
1 answer
31 views

"Mirroring" data across google sheets

Is it possible to "mirror" data (example below) between separate google sheets? If not, is there another application that would allow me to do something like this (preferably within google ...
-2 votes
1 answer
11 views

Get list of files from Google drive into google sheets based on date range using app scripts

Hello I am looking for a script to get list of files from google drive within a specific date range. I have got a script on this site here: List new files from a specific Drive folder and subfolders ...
9 votes
2 answers
19k views

How do I increase the page size in draw.io?

How do I increase the size of the page in draw.io? I'm making a flowcart and need the page to increase vertically.
2 votes
1 answer
220 views

Chat backup of my WhatsApp account#Whatsapp

I did WhatsApp chat backup to my Google Drive in the months of November 2019 but in the month of December my phone display has gone. So when I am trying to install WhatsApp in new phone and get the ...
4 votes
2 answers
27k views

How to get a list on an instagram accounts followers?

Is it possible to get a full list of all followers of a 3rd party Instagram user (eg not an account i control) through the instagram website ? I know i can click followers, but it only loads around ...
0 votes
1 answer
677 views

Specifying the position of an element (e.g. line) in draw.io

I'm wondering if it's posssible to specify the exact position of a line in draw.io. It seems that the only way to do that is the reduce the size of the grid.
1 vote
2 answers
2k views

Catch-all email on G Suite AND send a reject / bounce notice?

I've set up a Catch-All with the new G Suite Routing. (Specifically, I have a Routing rule with Modify Message, Also deliver to, an email address, and only on non-recognized addresses) I'd like to ...
3 votes
2 answers
2k views

Conditionally format if date is same/greater or smaller than current date

I'm trying to get my Google sheet to automatically colour a cell red if the current date is the same or greater than the date in the cell. Example: today is 21/02/2020. The date in the cell is 25/...
1 vote
1 answer
401 views

Conditional Formatting in Google Sheets based on the same rows conditional format

I have a spreadsheet where I have tasks, and I prioritize those tasks based on high, medium, and low levels. I currently use conditional formatting for this, so if I select from a drop-down "HIGH", ...
1 vote
1 answer
82 views

Calculate percentage change between two values

I've searched a sea of results but haven't found a solid answer to my specific question. Hopefully someone can help me out. I'm using cells C2,D2, and E2. Here's what I'm after. In cell E2, if C2 is ...
1 vote
1 answer
87 views

Script to automatically change the active sheet after user completes populating a range of cells

I am looking for a solution to merge text fragements in Apps script to automate a process. I have 3 sheets (sheet_1, sheet_2, and sheet_3). In each of these sheets, I have 10 cells (A1:A10) to be ...
1 vote
1 answer
191 views

Cannot create pie chart in which all values are identical

I am unable to create a pie chart in which all responses are identical, or, in other words, in which 100% of the responses are represented by a single value. When I try to create such a chart, for ...
1 vote
1 answer
36 views

Next 5 working dates

I’m trying to find a way in Google Sheets to list the dates for the next 5 working days. I’ve got it to show me the next working week, however as today is a Wednesday ideally I would like the date for ...
0 votes
1 answer
741 views

Is there a way to add a new sheet tab to a Google Sheet based on the timestamp date?

Students take a weekly survey on Google Forms, and it is transferred to a Google Sheet. I want the Google Sheet to automatically generate a new tab based on the date (timestamp) so that each week has ...
1 vote
0 answers
3 views

#enable-portals Tag Missing in Chrome? [migrated]

My question is pretty straightforward: what happened to the enable portals flag in Chrome? Tried both Chrome and Chrome Canary (latest version of each) and couldn't find the tag, despite it being ...
2 votes
1 answer
70 views

How to change Google Sheets interface language?

When for example opening some Google Sheet in a private tab without signing in to Google, the interface language is determined by the IP. So how to change the interface language to English?
1 vote
1 answer
95 views

Unable to create an ARRAYFORMULA that will AVERAGE the results of a QUERY

I have a sheet data that tracks client transactions. Each row is a transaction The columns are: LAST NAME PHONE NUMBER SUB TOTAL TIP PERCENTAGE The TIP and PERCENTAGE columns are calculated based ...
-1 votes
0 answers
15 views

What is Malwarebytes' "Super Secure Special Secret Permission?" [closed]

I see this org.malwarebytes.antivirus.SUPER_SECURE_SPECIAL_SECRET_PERMISSION on the permissions list for Malwarebytes after v. 2.1.2.1 and up to v. 5.x when it up and disappears, no longer needed, but ...
1 vote
1 answer
42 views

Facebook limits my reach when I have a history of paying to promote or boost a post?

Is it true that Facebook limits your audience reach AFTER you've paid to promote or boost a post because they know you'll pay them again to promote?
21 votes
8 answers
34k views

How to convert non-clickable links into clickable in Google Sheets?

My colleague has a spreadsheet full of links. She copy/pasted them from a variety of different sources. For a number of reasons, I want to convert these from just plain copy/pasted links to HYPERLINK ...
-1 votes
0 answers
23 views

How to dynamically change the font-family for incoming messages based on sender address

In Outlook on the Web I receive report e-mails that I'd like displayed in a monospaced font. Can the font-family for incoming messages be configured based on the sender address? Or, is there another ...
0 votes
1 answer
1k views

List new files from a specific Drive folder and subfolders in Sheets

I've seen some helpful answers, but none that have a script that lists only new files/folders from a specified parent folder. I think what I'm trying to do is combine @Tedinoz's WebApps answer to &...
2 votes
2 answers
13k views

How to change your public profile name in AliExpress

I cannot find any piece of information about it in the AliExpress help pages or anywhere else online. Assume you use your real name in name section. There is no alias possibility. One option is then ...
0 votes
2 answers
44 views

How to sum total sales for a store dependent on max date

I'm trying to sum the sales for different stores with the criteria to use the maxdate in a column, in google sheets. Below is the data I have: Column A: Dates (Weekly) Column B: All store names Column ...
14 votes
3 answers
7k views

How do I prevent websites from prompting me to sign in with Google?

I'm using Firefox 102.5.0esr (64-bit) on Linux How do I prevent websites from prompting me to sign in with my Google account: "Use your Google Account to sign in to X"? I've followed Google'...
8 votes
1 answer
9k views

Find out when a Google document was shared

In Google Docs, is there any way to find out exactly when a document was shared with somebody that I created and shared? This would be useful, at least for me, in finding out exactly when a document ...
0 votes
1 answer
38 views

How do I use a query to show a row with a name and also show the next 8 rows below it on Google Sheets?

I am using google sheets to have a group of people fill out when they are available and what it to show up on another spreadsheet and be able to move as well. 0 signifies they are free and 1 means ...
0 votes
3 answers
25 views

Finding strings from a list between 2 string conditions that are part of the list

In Google Sheets, I have a list of unique strings that I want to filter based on two conditions. These conditions are two strings within that list. Ultimately, I want to find all the strings, ...
0 votes
0 answers
2 views

Embedded content in website [migrated]

As far as tracking users and cookies etc, how does an embedded content in my website work? Such as an embedded YouTube video in one of my posts or anything else. I am writing my site privacy policy ...
-1 votes
0 answers
6 views

I would like to not recommend mix on youtube

I would like to not recommend mix on youtube, they say something for me but I don’t like , so I would like not recommended
5 votes
4 answers
7k views

Multiply duration (in hours) by decimal value

I have the following data in a Google Spreadsheet: +----------+------+--------+ | Duration | Rate | Value | +----------+------+--------+ | 16:15:00 | 55 | 893.75 | +----------+------+--------+ I ...
12 votes
1 answer
3k views

How can I stop getting suggestions for a specific group?

Meetup.com is useful, but it never forgets anything, even when I tell it to. If I mark down an interest and then later remove it, or if I join a group and then leave it, or even if I just look at the ...
1 vote
1 answer
236 views

Gmail account works on Outlook, but not Outlook.com, after updating google password

I use Outlook (Windows) as well as Outlook.com to access mail and calendar in my Microsoft and Google accounts. Last night I updated the password for my Google account and was able to update the ...
0 votes
1 answer
33 views

How to separate YouTube chapters text to columns and rows in a spreadsheet?

Some YouTube videos have a list of chapters in their description. How can these chapter descriptions be split or separated into columns and rows? Usually the format in the description is as follows: ...
1 vote
0 answers
109 views

Google Data Studio Scrolling up and down is not working in the present mode

I have used Google Data Studio for years now, and lately, I've noticed that when am presenting with the Actual Width option, I can't scroll down to see the rest of the page. I have a lot of reports ...
10 votes
3 answers
10k views

How can I view the number of files in a folder from Google Drive?

I'm using the web version of Google Drive, which is not synced with any computer. I want to view the number of files inside this folder. There are hundreds of files in this folder, so scrolling ...
1 vote
1 answer
342 views

Google sheets import columns based on date value

Google sheets for simplicity's sake say I have two tabs, one with master data and one that is a search function to display a certain part of the master data. The issue is I only want import certain ...
1 vote
1 answer
171 views

Will sub-folder contents be restored under respective sub-folders?

My wife's hard drive crashed recently with a bunch of pictures in sub-folders under the Pictures Library. IF they had been backed up with Google Drive, would they have restored with all pix in ...
2 votes
1 answer
92 views

How to turn a TYPE of Facebook notification back on again?

I’ve used Facebook function to turn off certain types of notifications under the bell icon... Basically you chose type of notification you don't want to see, click on the three dots and click "...

15 30 50 per page
1
2 3 4 5
682