All Questions

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

Pasting timestamp for edits by multiple users in Google Sheets

I got a good Google Sheet script for pasting a time stamp at the designated column of the same row on editing any cells of another particular column. Here it is On Edit of column 11: timestamp is to ...
0
votes
1answer
35 views

Insert Blank Row after Every New Value in Google Sheets

I hope someone could help with this one. I’m not sure if this is possible but I would like to know if there is any way to insert a blank row after every change of Data in ColumnA(Country) which is the ...
2
votes
2answers
2k views

Email aliases on Windows Live Domains for custom domains

I have hosted my email on Google Apps and was trying to move it to Windows Live Domains. However, when I tried to create my email address as me@mydomain.com I received the error: The requested ...
-2
votes
1answer
20 views

Move cell values from one cell to another with scripts

Move cell values from one sheet to another using a button. Consider 3 sheets. One sheet is called "Tentative Attendees." It contains a column of names. Say cell A1 contains "John Doe,&...
0
votes
1answer
580 views

Arrayformula and Sum queries. Possible alternatives

I am using a sheet to list and summarise teachers absences and substitutions. Here's the worksheet Basically in the sheet "Substitutions" all absences and substituions are stored record by record: ...
0
votes
1answer
3 views

How to stop the youtube home page from suggesting videos I already saw?

Videos I already saw/viewed are the preferent things my YouTube home page likes to suggest. I know I already had to a video because youtube shows a filled red bar bellow the videos I already saw, and ...
1
vote
1answer
37 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 ...
0
votes
0answers
2 views

Fix for Youtube's cinema mode (it goes on full screen)?

Ever since Youtube stopped allowing user-agents to go back to the old interface, the cinema mode on my desktop is no longer the "middle" option, it basically expands just like the full ...
0
votes
0answers
7 views

Twitter not showing some “sensitive content” Tweets via search as guest

I've been looking across broad numbers of searches on accounts which have their content identified as "sensitive content" and have noticed that some tweets do not appear in the search as ...
0
votes
0answers
5 views

Microsoft Teams Switching To Wrong Account

Microsoft Teams keeps switching me to the wrong account. I created a free Teams account using my G Suite work email address. To set it up, it sent a code to my personal Gmail account, which is also ...
0
votes
2answers
19 views

Split function doesn't get the result that I expect

A1 value is 485065/1, 2, 3 and I expect 485065 and 1, 2, 3 but it comes out 485065 and 1, 2, 2003. =split(a1,"/",false) Please help me why it does.
0
votes
0answers
3 views

Make Google Calendar appointment shared to Outlook show as Out-of-Office

I have scheduled an appointment in my Google Calendar. I share that calendar with an Outlook application. Is there a way to make this appointment time appear as Out Of Office in Outlook? I can either ...
3
votes
1answer
5k views

Facebook account that only redirects to Facebook for Business

I have a similar question to this one: Facebook opens "Ads Page" instead of regular homepage after login And I'm asking again because the solutions mentioned in that question no longer ...
-1
votes
0answers
9 views

Custom Script For Google Sheets

I work for a company that is a dealer for another company. We use Google products for our workflow, so I was wondering if someone can help me out with a script. The inventory management system we use ...
2
votes
1answer
421 views

Using FILTER or IMPORTRANGE to bring in and filter data from another spreadsheet with a keyword instead of exact match

I would like to use the importrange formula to import data from "spreadsheetA" that contains "keyword" in columnD. I can get importrange to work but I cannot figure out how to filter it so it will ...
0
votes
0answers
3 views

Is there a way to hide the channel name from Slack notifications?

Say I'm working with client A and client B. I want to keep notifications on, but if I'm presenting my screen to client A, I don't really care that they can see my Slack notifications, but I do care ...
20
votes
7answers
4k views

Change Gmail date format to ISO 8601 (i.e., yyyy-mm-dd)

Is there any way to change Gmail date format to ISO 8601 (i.e., yyyy-mm-dd)? Instead of :
0
votes
1answer
95 views

Exclude original message from reply in Outlook 365 web app

I know there are options to do this in Outlook desktop, but I can't find an option in Office 365 online. I basically just want to reply to messages without quoting the original message in my reply.
0
votes
1answer
18 views

How can I open context menu for sheet in google sheets using only the keyboard

I know that there is a way to open the google sheets context menu via the keyboard, or there was one. However, I cannot seem to find it! For reference, this is what I am talking about (am I calling ...
1
vote
1answer
13 views

Google Sheet - Count Random Average

Number Of Invoice | From | To | Total 10 | $25 | $100 | ? I want the Total column to fill with the average number of 10 invoice with each invoice random between the ...
1
vote
1answer
371 views

Arrayformula for running MAX of separate column

I'm trying to use ARRAYFORMULA in Google Sheets to get the max figures from a separate column only up to the row being calculated each time but can't for the life of me figure out how. It sounds more ...
0
votes
0answers
6 views

Does gmail had a built in feature that it will only send out an auto response to another email account X times per day?

Ive got an email account on a custom domain running on Google Apps For Business (Gmail). Ive set up a vacation auto responder on one of the email accounts, but when testing it only seems to send the ...
1
vote
1answer
47 views

Managing OUs and features in the Google world

I work at a fairly large company (65k+ users) which has massively adopted Google G Suite and I work with the G Suite admin team to architect our environment. One of the things I'm struggling with is ...
-1
votes
0answers
9 views

How do you automate Google Chrome console activity at computer start-up?

How do you automate Google Chrome console activity at computer start-up? I have a JavaScript code that runs fine in Google Chrome's console. I was trying to automate the process of opening Google ...
0
votes
0answers
2 views

I tagged my Page in a post on my profile, but the post is not appearing on my Page's feed!

I made a post on my Profile and tagged my Page. Settings for the post are on Public. I went to the Activity Log on my Page, to show (unhide) the tagged post on my Page's feed, it says "Authorized ...
-1
votes
0answers
15 views

How do I block websites that contain specific words or phrase?

I need an extension/software that detects words from the body of the website The extension or software must to be free to use, and preferably come with password protection and an option to whitelist ...
9
votes
3answers
37k views

How do I get all comments of a YouTube video?

http://youtube.com/all_comments?v= stopped working and redirects to watch?v=.... A Reddit thread states that AJAX populator also does not allow to show all the comments when there are multiple ...
0
votes
1answer
239 views

Fetch Random String From Array For Each New Form Entry

!Sheet1 is populated with entries coming from a Google form !Sheet2 has an array of 12 employee names in array A2:A13 How can I automatically populate the cell on the right column of every new line ...
0
votes
0answers
4 views

Can't see all the photos in messenger shared media

I have a messenger chat of about 1 year and there's a lot of shared media. I am able to see all the photos in chat(even the 1 year old ones) but when checking the shared media in messenger, I can't ...
0
votes
1answer
530 views

Create triggers on recently programmatically copied Google Forms

I have this main Form that uses its responses to create several other Forms after it's been submitted, but I need that these Forms that were recently created to send emails on their submissions ...
0
votes
1answer
62 views

no pay link in paypal when going to a paypal.me link

I am aware that PayPal provides people with paypal.me links... I won't use the example of the specific person I want to pay, but it can be anybody, so as a demonstration example, suppose I want to pay ...
2
votes
1answer
339 views

How do I setup Gmail priority labels with intricate filters?

I have a filter for important, unread and starred. Every time I try to change my Gmail priority inbox to the that label, it changes to: "All Everything Else." It doesn't matter if I try inbox #1, 2 or ...
1
vote
2answers
808 views

Using REGEXREPLACE() and VLOOKUP() to search and replace using a pairwise list

Suppose I have a list of people with unique first and last names, in two columns, B and C. See example spreadsheet here. Cell E6 contains the following text: Firstname1 would like to say hello to ...
0
votes
0answers
4 views

How can I search for a term that will match only the “city” in Google Contacts

I am documenting a process to get one's Google Contacts in a given city and plot them on a custom Google Map. The first step of this is to search in https://contacts.google.com/ for the city. However, ...
1
vote
2answers
3k views

I keep on getting strange notifications on my phone from my Gmail account (Calendar). Is it a virus?

This is the second time I get this strange notification on my phone. In the notification panel I see a "calendar event notification" (from google) with a strange title, something...hot... Example "...
1
vote
1answer
10 views

How can I sort Quora answers by votes?

The more upvoted an answer, the higher I desire it to appear. If possible, please include screenshots to illume where to click.
17
votes
6answers
18k views

Can I make Gmail use the nickname as the primary method of autocompleting contacts?

Is it possible to make Gmail use the "Nickname" field as the first choice for autocompleting a contact when writing an email? And, if possible, also for ordering them in contacts? I don't know what ...
2
votes
2answers
1k views

Trigger onOpen() only for first instance of the sheet being opened for a user

I have a sheet that I want multiple users in my organisation to use as a dashboard, with the data displayed changing depending on the logged-in user. Everything works fine, and I have a simple script ...
10
votes
4answers
12k views

How do I prepend a string to a column of cells in Google Spreadsheets?

I imagine this is laughably simple but I just don't know what to do. I have a column (A) of cells with strings in them and I want to simply prepend each string in every cell with a web address: A ---...
0
votes
0answers
6 views

Zoom 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
0answers
14 views

Optimizing onEdit for checkboxes

I am trying to design a survey through google sheets and have set up some checkboxes, but noticed that there is some lag when changing selections/clearing previous selection. I was wondering if there ...
1
vote
2answers
17 views

Dashboard based on Todays Date - From a table

I have a list of students with responsibilities and I would like to create a dashboard in Google Sheets with information about the current month. As an example: then in September 2020, I want the ...
1
vote
2answers
42 views

G sheet How to jump over no value cells with SUMIF function

I would to get the sum of the duration of the column B +---+----------+ | A | 14:45:00 | +---+----------+ | A | #Value! | +---+----------+ | A | 13:34:50 | +---+----------+ | B | 23:41:00 | +---+-----...
1
vote
1answer
13 views

Applying a custom sort to Google Sheets string column

I am trying to sort a table of rows by their first column that is comprised of strings with this format (capital letters followed by a dash followed by numbers). Using the default string sort I get ...
0
votes
1answer
292 views

How do you interpolate data in a horizontal range that's non-linear?

I've been told what I'm hoping to do is called 'spline interpolation'. I've imported monthly youtube channel viewership figures from google API. And I've layed out the dates and views in a horizontal ...
3
votes
1answer
3k views

Auto Sort Google Sheet with onEdit function

The following function successfully sorts my file (containing 3 sheets) individually. When I hit the "play" button on the script, it properly sorts (as expected) the current (active) sheet. Since my ...
0
votes
0answers
6 views

Cisco Webex Events video recording: audio lags behind video for some participants

Learning my ropes with Cisco Webex Events and discovering one quirk after another. Just had a meeting with 1 other person. She's using a Mac with its built-in camera/mic. I was hosting using a Win 10 ...
1
vote
1answer
2k views

How do you delete shared drives from google drive

I recently worked with a file from a link, now it is indexed in my "Shared with me" folder and is taking up space in my drive folder. It lists itself as a shared drive but I can't delete it and if ...
5
votes
4answers
3k views

Add more fix points to a Data Flow Diagram using Draw.io

I'm trying to replicate a Data Flow Diagram using Draw.io. I'm using the oval basic shape but there are not enough fix points. Is it possible to add more?
0
votes
1answer
30 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 ...

15 30 50 per page
1
2 3 4 5
603