All Questions

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

GSuite user over storage quota - but numbers are below quota

Attached is a screenshot of what I see for a specific user. She is complaining of not receiving emails anymore so I guess it's true. But I am having a hard time understanding, how can she be "over" ...
2
votes
1answer
15k views

How to download attachments of Gmail mail automatically?

I receive mail every day with some attachments and I want to download those attachments automatically when they arrive to my mail box. Is that possible? and if yes, how?
-1
votes
0answers
19 views
+50

Git - Add multiple developers as collaborators to one GitHub account

I've been given a GitHub account details of our company boss. Let's say the account's username is OneUser. For one of the repositories present in that GitHub account, we've multiple developers ...
1
vote
1answer
56 views

Google Apps Script: Is it possible to log the use of the close button on a Modal Dialogue?

I'm working on a spreadsheet which opens a modal dialogue when a script begins to execute. Inside it plays a google-style "working" animation made with CSS: If I could remove the close button so ...
0
votes
0answers
11 views

Finding a cell value based on row and column

I have a little problem that might not be solved just with formulas. And I am not so advanced in JavaScript yet. I have a list of products, our salesmen, customers and time when and how much the are ...
0
votes
0answers
5 views

I have a group on Facebook, yesterday, no one was getting notifications, what happened

What happened, as of yesterday no one in my group was getting notifications when I post?
1
vote
1answer
68 views

How to concatenate several “filled” time slots in a spreadsheet and then check if they completely fill a “main” time slot?

For each row that represents a day of the month (month day 1, month day 2, month day 3 and so on...), I need this spreadsheet to answer NO at column C if no employee will be in the office for at least ...
0
votes
1answer
14 views

Continuation token: Generate file listing of a google folder into a google sheet

I have a folder on Google with 18k files and need to list some variables from them into Google sheet. A solution for this was found on Insert image from Google Drive into Google Sheets However, ...
2
votes
1answer
11 views

Touchscreen tap edits drawing object, doesn't run assigned macro

In Google Sheets, I created a drawing object and assigned it a macro. When I use my laptop in "normal" mode using the touchpad (or at my desktop using my mouse) I can execute the macro by clicking on ...
2
votes
2answers
198 views

How can I quickly change the color of text in a cell in Google Sheets?

How can I quickly, with either a single or double click, assign a color to the text in a cell in Google Sheets? In order to quickly determine the status of certain pieces of data in a spreadsheet I ...
1
vote
1answer
32 views

Is there a way to move forwarded emails back to the original Gmail account?

I have been forwarding emails from my university-based Gmail account to my personal Gmail account for years, and there are no copies of the emails in the original Gmail account. Now I graduated and I ...
0
votes
0answers
5 views

How can I search multiple terms for “text contains” using a custom formula with the Google Sheets filter tool?

I want to use google sheet's filter tool to search multiple words under the "text contains" option. However, it only let's you search one term at a time. I have tried using different formulas under ...
-1
votes
2answers
119 views

Google Search results vs. full page of spam links

I've searched for ext:PDF (filetype version) of a probably popular = commercial successful book and got full page (maybe more) of spam links - it's more than 100! How to deal with a full page of spam ...
0
votes
2answers
26 views

How to filter after parsing CSV values contained in Google Sheets cells

I would like to be able to match all cells in column A (titles) that have one of the comma-separated values in column E (Key Search Terms). This will involve at least two steps. 1) Parse each of the ...
1
vote
2answers
23 views

How to find a spreadsheet to which a form submits?

In my organization, we have recently found a form that is supposed to collect some kind of submissions from people. The problem is that we don't know who exactly created it and where are the answers ...
0
votes
1answer
21 views

Copying a cell and pasting in another app pastes the formula not the value

Excel-online is copying the cell formula, not the cell value to the computers clipboard, e.g. Given that I copy a cell showing a value in Excel online When I paste, the formula is pasted instead of ...
0
votes
0answers
13 views

Does WhatsApp Web Require Phone on Wifi

Does WhatsApp web require the computer and phone to be connected to the same wifi network simultaneously? Assume I've already authenticated and used WhatsApp web - then taken my phone outside the ...
0
votes
1answer
55 views

Average first 3 values excluding empty cells in google sheets

Trying to find the average of the first 3 values in the column. I'm already running a query to find the average data within the last 3 days =average(query({$A$10:$A$107,$E$10:$E$107},"Select avg(...
1
vote
1answer
82 views

How do I prevent or omit a negative value when calculating between times?

I've researched through the site to see if this has been answered but with no luck after reading: How do I calculate a time delta in my Google Spreadsheets? Calculating time difference Calculating ...
0
votes
1answer
28 views

Whats the reason that instagram doesn't allow direct messages from the web browser?

Whats the reason that instagram doesn't allow direct messages from the web browser from a PC? I guess for a company like facebook it would be no technical problem to implement this, so there seem to ...
0
votes
2answers
499 views

Consolidate columns from a dynamic range into a single column in Google Sheets

How can Google Sheets take a range of multiple columns and rows and stack or consolidate all the non-empty cells into one column? For this case, I want non-unique cells. Also, each cell in the range ...
0
votes
1answer
79 views

When editing a formula in Google Sheets, how do I resume 'range selection mode' so that I can select a range with the mouse or keyboard?

When you first enter a formula in Sheets you can use the mouse or cursor to select the range. If I want to sum the 5 cells below the cell with the formula, I just type =SUM( and then use the down ...
0
votes
1answer
36 views

Gmail error message disappeared before I could read it

I clicked "send" on a message in Gmail, and one of those black error message/info boxes popped up in the lower-left corner. I wasn't expecting it, and the length of error text was somewhat substantial,...
0
votes
0answers
5 views

PHP REST API not posting data

Hi I am making this simple PHP REST API, its getting records from database but it is not posting,putting(updating) or deleting any record from mysql. Below is sql for two tables in database one is ...
0
votes
1answer
39 views

Pull unique values from other sheets as new sheets keep getting added

I'm trying to get a unique list of values in a master sheet based on a list of values that appear in column A of other sheets. The tricky part is that every time a new column is added in the master ...
72
votes
17answers
98k views

In a Google Spreadsheet, how can I force a row to be a certain height?

In a Google Doc spreadsheet I would like to have each row the same height no matter how much text is in each cell. I have tried "resize row" but no matter how many pixels I put in, the row expands ...
0
votes
0answers
14 views
+50

Sharing Blogger blogs in Facebook shows blog title and article title

I have a blog on blogger (blogspot), and when I want to share an article on facebook, the name of the link (the gray fild under the image) appears as: [Blog Name]: [Blog Post Title] I would like to ...
0
votes
0answers
8 views

Selecting max value of a metric per given dimension in Google Data Studio

I am trying to compare the maximum value of a metric with a selected value of a metric. Consider this my data: Name Metric_1 John 50% Dave 60% Tom 55% I am trying to create a ...
0
votes
1answer
11 views

Google Sheets calendar script is timing out

function onEdit(e) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); if(sheet.getName() != "Sheet2") { return; } var lastColoum = sheet....
2
votes
1answer
102 views

Validate text field to hold only digits

Is there a way to check whether a textbox field contains just digits and not alphabetic or special characters? I need to have the user enter a player's Uniform Number, but need to allow the user to ...
4
votes
7answers
13k views

Is there a way to set a default font in Google Sheets?

I know that there is a way to set a default font on Google Docs, but I was wondering if there's a way to set a default font in Google Sheets?
0
votes
1answer
782 views

How to set cell value based on 2 conditions of 2 other cells?

I've got a spreadsheet where people enter in values into columns A through H with I being a checkbox. On another sheet, it keeps a running total of all of the values of column E based on the values of ...
0
votes
1answer
10 views

What's a google sheet formula for fractional part of the number

I need a formula to get only the fractional part of a given number. It should take any number and return its fractional part which is between 0 and 0.9999... For example 123.456 -> 0.456 0 -...
71
votes
11answers
11k views

Is there a way to remove sites permanently from (my personal) Google search results?

I regularly find sites that copy content from elsewhere (mailing lists, etc) while not providing any added value. Quite to the contrary, they are pretty heaped with ads. I'd like to remove those ...
1
vote
3answers
6k views

Google sheet limit, number of sheets per workbook

I know that Google sheets has a 2 million cell limit. https://support.google.com/drive/answer/37603?hl=en but was wondering is there a limit to the number of sheets? the old google sheet has this ...
-1
votes
1answer
16 views

No logger output in sheets

I am getting no output from the logger in sheets. I am a boob, although a 30+ year programmer. Here is my function: function onChange(e) { var spreadsheet = e.source; var cell = spreadsheet....
0
votes
1answer
27 views

Change a date reference as text to Google Sheets date format

Need to change "December 23, 2019 at 08:31PM" to a date Google Sheets recognize.
2
votes
1answer
2k views

How to add UK Mothering Sunday and Father's Day to Google Calendar?

I use Google calendar and the "Holidays in the United Kingdom" calendar doesn't include Mother's Day (in the UK) and Father's Day as they are not actual holidays. Is it possible to add events for ...
0
votes
2answers
51 views

How to Clear Cell(s) based on the Value of another Cell

I am looking for a script that will clear cell(s) when the value of another cell changes or is equal to ("X"). In the attachment I would like when Column "G" gets checked marked (TRUE), then ...
1
vote
1answer
30 views

How to locate a specific slide using a certain layout in Google Slides?

I have a 38 slide presentation. When examining the Master theme, I can see that there is 1 slide using a specific layout "Big Number". But I don't see any slide that is using that layout. I have ...
0
votes
1answer
18 views

Google Sheets: Fill out dates and replace blank cells with zeroes

I'm trying to make a timeline graph of seed sales, and right now it's almost completely unuseable: I think there are two reasons for this: Not all dates have values associated with them, and ...
0
votes
0answers
26 views

Trying to import CSV files (~2 KB) to gmail , but gmail says must be less than 20 MB! Any ideas what's going on?

Trying to import CSV files (~2 KB) to gmail , but gmail says must be less than 20 MB! Any ideas what's going on? Changed extension from .txt to .csv, but then got message that g-mail doesn't ...
0
votes
1answer
29 views

How can I sign in to someone's Google Domains account who is in a different geographic area from me?

I'm taking over hosting my sister's website. Her domain is registered with Google and she needs me to sign in to that account to update the A record to point to my server. Every time I try to sign in ...
0
votes
0answers
8 views

Accessing info inside links in google sheets

Background: I have a Google Sheet that has some links in it. Of course, links don't always have the contents of what you are looking for the URL, so trying to search for it later is hard. Question: ...
0
votes
1answer
20 views

Adding Positive Values Only (across multiple sheets)

The example formula below works perfectly in my spreadsheet if ALL the numbers are positive. However, I would like to pull the values from the cells indicated below (from 14 different pages), but ...
1
vote
1answer
225 views

How do you “Paint Format” more than once in Google Sheets?

In Google Sheets you can select a formatted row, click the "Paint Format" Tool, then click another row to apply the same format. You can drag down to do multiple rows if they are together (say rows 50-...
1
vote
1answer
21 views

Is there a shortcut for Edit Master in Google Slides?

Is there any shortcut (keyboard or otherwise) for quickly editing a slide master in G-suite? In Powerpoint one can shift-click the view buttons which works well. I'm looking for something similar for ...
1
vote
1answer
25 views

How to create comma and hyphen separated list of sequential numbers in Sheets?

How do I create a list of numbers, where consequential numbers are reduced to being separated by a hyphen? e.g. I have a column with numbers like 1 2 3 5 6 7 8 10 12 I want this to be reduced to 1-3,...
0
votes
0answers
18 views

Is it possible to acheive this in google sheets?

I want to implement the following in google sheets, but I don't know how to or if it is even possible I have a sheet, let's call it "products", in which every entry has an ID tag and a value I want ...
0
votes
1answer
42 views

If cell y contains any word from range x:x, mark cell y green

In Google Sheets, I have three columns (with different lengths!) Column1 contains firm names (50) Column2 containts firm names (100) I would like to mark a cell in Column1 green (or with a number in ...

15 30 50 per page