All Questions

0
votes
0answers
13 views

G-suite passwords not accepted on bulk upload

I get this back after a bulk upload of children users: ACTION_FAILED:PASSWORD_INVALID I used a random generator and pasted its VALUE into the password column, so instead of =CHAR(RANDBETWEEN(65,...
0
votes
0answers
22 views

Lost Sent Mail from my gmail account

I sent emails to a clients on 1st June .. The client confirms to have received it yet the evidence is not available in my sent items ..Is there a way i can get it back since i need 1st June's mails ...
0
votes
0answers
9 views

Is there a way to allow access to Importrange at once to all the links in a worksheet?

I am importing data from more than 7 sheets and I have 10 such sheets. Can anyone help me if there is a way to "Allow Access" automatically instead allowing access everytime?
0
votes
1answer
15 views

How can I do an aggregate function with multiple columns with a Google Sheets query?

I've got two columns of 10 numbers in Google Sheets. I'd like to average the numbers in both columns using a Google Sheets query. Something like this: =query(A1:B11, "select avg(A&B)", 1) <- ...
0
votes
0answers
4 views

GitHub Pages theme for slides

I'm looking for a GitHub Pages theme that will allow me to present the markdown files on the repo as slides. But, Without having to run Jekyll locally on my machine (therefore only using GHP as a ...
-1
votes
0answers
18 views

Functon to join facebook groups as a page does not appear

I know that Facebook has enabled joining to people's groups as a page in 2018 but when I click on the button "Join" it gives me no option to choose whether I want to join as a page (my artist page) or ...
0
votes
1answer
21 views

How to disable auto-pause for YouTube

Originally I thought this was a browser issue, but it turns out to be an actual YouTube issue. I'm using Brave Version 0.62.51. Every time I play YouTube, after 10 minutes the video will pause and ask ...
0
votes
1answer
30 views

Cannot add Calendar Resource to My Calendars

I have a G Suite Meeting Room and I want to manage its calendar. I'm following the instructions on this page to add a Calendar Resource to "My Calendars", however the section My Calendars (capital C) ...
2
votes
1answer
21 views

Google Sheets sort question

I used to know this a few years ago and for the life of me can't figure it out and can't find an answer in Google help. I know how to sort columns, but only by the default A-Z format, how can I sort ...
0
votes
2answers
12 views

optimize onEdit managing set of many checkboxes

I have onEdit script that hides or shows rows by checking/unchecking checkboxes (yes/no values). Looks like this if(orpscscchbx.getValue() == 'no') { var rowsHided = 0; for (var i = 0; i ...
2
votes
0answers
16 views

Make Drive resources available to all users in organization

My company uses G Suite Basic. I have a handful of company resources that I'd like to make visible and available to everyone in the company via their Drive - things like employee handbook, benefits ...
-1
votes
0answers
8 views

How do I re instate my Gmail account? [duplicate]

How do I re instate my old gmail account?
0
votes
1answer
28 views

I accidentally labeled every single message in Gmail

I was recently trying to clean up my Inbox. When I did that, I used filters to clear out all messages and apply them to the correct label. While setting up a particular filter, Gmail crashed. I hit "...
0
votes
0answers
117 views
+50

Account Settings Action required

I don't think this has anything to do with gtag.js because it's the same for all my properties. I think it has something to do with my account itself. But I can't tell what action is required. Here's ...
-1
votes
0answers
44 views

I can't join a Facebook group as a page

I know that Facebook has enabled joining to people's groups as a page in 2018 but when I click on the button "Join" it gives me no option to choose whether I want to join as a page (my artist page) or ...
1
vote
1answer
16 views

How can I merge drop-down columns in Google Sheets?

Please see Investment Portfolio Tracker - TMOAP Official Version 5.2. If the three columns (in red rectangles) remain the same for rows 5-20, it's obviously foolish and unproductive to click on the ...
0
votes
0answers
13 views

Embed an interactive infographic in WordPress

I am not terribly sure if this is the right platform to ask this question but I'll give it a go anyways. Here goes: I am "amdin-ing" a WordPress homepage (mind you i am not terribly experienced in ...
0
votes
0answers
11 views

Highlight Google search results that are existing Firefox bookmarks?

I use Firefox for several hours daily. As a semi-prpofessional programmer, simultaneously learning several languages/platforms (yet cursed with a "handicappingly-poor" memory"), I find myself ...
2
votes
1answer
19 views

Perform functions (AVERAGE, STDEV) on rows grouped by unique values in Google Sheets

I would like to be able to group rows based on unique values and then output the AVERAGE and STDEV values for those groups. Using the table below as an example, I would like to determine the AVERAGE ...
0
votes
1answer
5 views

Validate that a combination of cells are unique in a row in Google Sheets

I'm looking accomplish the following but in a Google sheet. https://superuser.com/questions/902400/validate-that-a-combination-of-cells-are-unique-in-a-row-in-excel I have a column of first names ...
0
votes
0answers
8 views

How to remove duplicates from youtube playlist

How to remove duplicates from youtube playlist? is there any tool/ site to scan for duplicates in playlist automatically, then remove them?
0
votes
0answers
18 views

Facebook messenger seen bubble on the message before not message they sent

I went to message someone who last messaged me and when I went into our chat the bubble for where they have read up to in the messages (where they’ve seen) is on my message before the one they sent. ...
1
vote
0answers
5 views

Can you embed and link files that reside on sharepoint?

I have a Visio diagram I'm trying to link into a powerpoint presentation. Both files reside on the same Sharepoint site. I tried adding the Sharepoint document library to my local computer as a ...
1
vote
1answer
22 views

Why do calendar events created in a shared calendar have an incorrect start / end date for creator?

The setup: Account A has a calendar (Cal) shared to everyone on the domain with full rights of "Make Changed and Manage Sharing" Account B creates an event (Event) on Cal, Event is an all-day event. ...
2
votes
1answer
6 views

Is it possible to edit the column a Google Form response saves to?

I have a client who uses a Google Form to save data to a Google Sheet. They deleted and recreated one question, and the responses to that question are now being stored in a new column. This messes up ...
0
votes
0answers
5 views

How to export Slack conversation thread without admin account

The Slack UI is not ideal for some conversations/threads I participate in, where it would be better to have the text and images copied to another format that I can more easily read and process. I am ...
3
votes
1answer
23 views

How can I hide a paragraph of information in Google Docs?

I want to hide a blob of information or a paragraph. I identified two ways to try this neither of which worked. One was to store it in a comment which takes it outside the page but I can't use ...
0
votes
0answers
17 views

ffmpeg video does not play on whatsapp

I've been trying to get a video to play on whatsapp but I can't get it to work. I've read almost all the stackexchange posts on this topic but nothing seems to work. I use the following command to ...
1
vote
1answer
14 views

How to prevent cut-and-paste data from changing collapsed grouped cells?

I'm completely lost and don't know how to paste any data without affecting those collapsed rows. For example, I have such a list: And I want to paste numbers from 1 to 4 for every capital letter ...
0
votes
0answers
14 views

Google Form response is modifying a cell on another row of linked sheet

I have a sheet that is recording form responses on a linked Google sheet. The issue is that sometimes the form will modify a cell on the row above in addition to the row that is being inserted (see ...
0
votes
1answer
19 views

Is all the data of a 144p video also stored EXACTLY same as in a 720p video?

Whenever I switch between 144p to a higher resolution it's obvious I need to download more data to view the same youtube video. Suppose I have buffered the whole video in 144p and I switch it to 720p ...
1
vote
1answer
11 views

Comment section on my blog disappears

When there are no comments in a post, you can still see the comment section, for example: https://duonghoimanga.blogspot.com/2018/11/takane-no-ran-san-chap-14.html However, as soon as someone ...
1
vote
1answer
14 views

Date highlighting of a cell, separated by weeks, given only a starting date and a cell range

I am trying to build a "life calendar" similar to this - https://labs.coruscantconsulting.co.uk/life/weeks/ - in Google Sheets. I have the manually designed sheet finished, but want to add the ...
1
vote
1answer
12 views

Full Join 2 lists with 3 key values

I'd like to fully join 2 tables on 3 key values, there doesn't need to be 0 value on blank cells if it makes it easier to understand (Some Array Formulas can be really confusing) I have income: I ...
0
votes
0answers
8 views

Is there a way to link to highlighted sections in a Google Doc?

I have a large document that has multiple highlighted sections. The highlights are color-coded such that all blue highlights belong to one topic, while green highlights belong to another topic, etc. I ...
0
votes
1answer
11 views

Multiplying several numbers within a text string, is this possible?

I have cell A1 which is a text string: 100 blue cars, 100 red cars, 100 yellow cars In cell B1 I have a number which is a multiplier say 2. Is it possible to change the numbers within cell A1 ...
0
votes
2answers
30 views

Is there a way to protect/copy only some formatting in Google Sheets?

I have a spreadsheet that I use to track customer orders. It has the customer details on a row, their order number and a line of check boxes for the items that they want for that particular order. For ...
1
vote
1answer
19 views

Set link in email body

I have script that sends an email from google sheet and want to have link in the email's body but code like var html_link = "google.com"; var body = "<a href=" + html_link + ">Google</a>"...
0
votes
0answers
5 views

Excel Sorting Help

I have a large amount of data that needs to be sorted by number and then analyzed. Is there an easier/faster way than sorting all this data into separate sheets in excel? EX: I'm looking at breaking ...
0
votes
0answers
30 views

How to create a subdomain for sending and receiving email with OVH using Gmail?

I am trying to create an email with a subdomain as follow : @subdomain.domain.com. The domain provider is OVH and Google Product manages my emails. So far I only have my domain. Can you please guide ...
0
votes
2answers
27 views

Checkbox to activate a column in QUERY

Is there a way to activate/deactivate a column in QUERY function? I have a query to query and selection of several columns Select Col1,Col31,Col32,Col33,Col25,Col26, and want to have a checkbox for ...
0
votes
0answers
8 views

Profile Updated but nothing shared

I added my new position to the LinkedIn profile but even if the privacy setting is active, nothing was shared. Could you support me please
0
votes
1answer
24 views

How to see all files shared to a specific user Google Drive?

Context: You want to find all the files/folders that you have access to or are part of your organization which are shared to a specific user. This is an important ability to security if you need to ...
1
vote
1answer
14 views

How do I refer to data in a column under this month?

In the below screenshot, I'm trying to get B42 to show the value of whichever cell on row 40 is under the current month's column: As the dates are automatically generated using a transpose(...
-1
votes
0answers
16 views

How to recover a lost live video from Facebook?

Recently went live on Facebook but forgot to post the video and we lost the livestream. Is there any way to save the video?
0
votes
2answers
11 views

Dropdown list created from a list in one cell

Is it possible to create a dropdown list from only one cell as a source? Each element separated by commas?
0
votes
0answers
7 views

SUMPRODUCT inside ARRAYFORMULA in Google Sheets

I have a SUMPRODUCT equation that works fine on one row: =SUMPRODUCT(O4:O10-O3:O9,E2-P4:P10,N(E2>P4:P10)) However, instead of copying it for each E row I want to use ARRAYFORMULA to automatically ...
0
votes
0answers
17 views

Set boders to a range if first cell in row is not empty

I need to set borders to a range in row if first cell in this row is not empty. I have this code function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet (); var sheetmon = ss....
0
votes
1answer
25 views

How to create a line break in WhatsApp web?

The web interface does not respect the setting where 'enter' sends a message (or not); pressing 'enter' does indeed send the message. I have composed letters in Word (including line breaks) and then ...
0
votes
1answer
10 views

Select from current cell to end of row (a la SHIFT + END)

When I have a cell selected, how can I select from that cell to the end of its row? SHIFT + END works in most spreadsheet programs, but I can't get it to work in Google Sheets. I use Chrome on Linux.

15 30 50 per page