All Questions

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" ...

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?

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 ...

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 ...

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 ...

What happened, as of yesterday no one in my group was getting notifications when I post?

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 ...

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, ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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(...

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 ...

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 ...

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 ...

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 ...

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,...

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 ...

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 ...

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 ...

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 ...

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 ...

function onEdit(e) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); if(sheet.getName() != "Sheet2") { return; } var lastColoum = sheet....

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 ...

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?

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 ...

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 -...

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 ...

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 ...

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....

Need to change "December 23, 2019 at 08:31PM" to a date Google Sheets recognize.

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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: ...

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 ...

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-...

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 ...

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,...

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 ...

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 ...