All Questions

6,124 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
-1
votes
0answers
13 views

12 Week Scheduled Contact Sheet

I'm trying to create a sheet that will have data imported from Zen Planner through webhooks. The data will be for new students at a martial arts academy. There are 5 of us that will be working in ...
-1
votes
1answer
6 views

IF THEN Google Sheets - referencing different workbook

I'm hoping to do the following: Spreadsheet 1, cell A1: pull in data from cell A1 in Spreadsheet 2, but ONLY if cell B1 contains exact text of "partner". Is this possible?
-1
votes
0answers
8 views

Consolidated Calendar Management Across Providers?

Presently and in the past, I've had to manage many different calendars across multiple providers, as I work in consulting. Here are the calendars I currently have to manage: G-Suite: my personal ...
-1
votes
0answers
8 views

How to prevent auto-complete from inputting an obsolete address

How can I stop the auto-fill function from automatically inputting an email address that is no longer current and preventing me from poutt
-1
votes
0answers
16 views

Formulas in Google Docs Table( not spreadsheet)

i need to plug in the SUM formula, but in google docs instead of spreadsheets.i can't just use a calculator, i need to be able to plug in the formula like this: SUM (20,35,90) and have it appear as ...
-1
votes
0answers
10 views

Google One Expired But I can't seem to Renew it

My Google one storage is expired and went from 100GB to 15GB. It was unfortunate as I moved to a new country and was waiting for my new bank account and card to come in. But the it is still expired. ...
-1
votes
1answer
25 views

google sheet need formula to go backward directory of URL link

example i have data in colum https://www.mybookStore.com/images/products/80/1020/40422/2/279/howtocookegg8.jpg https://www.mybookStore.com/images/products/80/1020/40422/2/279/howtocookegg9.jpg i ...
-1
votes
0answers
5 views

Page scrolls to middle section on load

I changed the order of some elements in my theme. I flipped the first and second items. Now, when the page loads it automatically scrolls to the second element.
-1
votes
0answers
14 views

What free webapp allows recording videos from a phone's camera and saving them to an online storage?

I'm looking for a way to collect videos from a group of non-tech-savvy people. They should get a link that when opening it in their mobile or desktop browser, allows them to record a video from the ...
-1
votes
1answer
13 views

Google Sheet - Hide cell value if not authorize

I had a GSheet file with a vote system like this |user1|1|4|6| |user2|5|4|1| |user3|2|4|4| ... Actually, each user can only edit his line with cell authorization. We want to "hide" cells of other ...
-1
votes
0answers
12 views

How to black list websites in a Chrome user profile?

I want to have two user profiles, a work and a personal ones. For work, I'd like to blacklist social media websites. How can I do this in Chrome?
-1
votes
0answers
5 views

Form to get multiple time ranges per day

I need a web app where I can create a form on which users can define multiple time ranges per day. For example User 1 can say that they are available from 9 am to 3 pm and from 5 pm to 7 pm on ...
-1
votes
0answers
11 views

copy and paste problem in google docs and google sheets

Why are Cut/Copy, and Paste unavailable in the Google Docs and Google Sheets in the firefox browser? FYI, I am using Ubuntu OS
-1
votes
0answers
30 views

How to use consistent contrasting color when replying in Gmail?

Sometimes I would like to respond inline, with my font always in blue, for example (i.e. different from the color of the message I'm replying to). I've seen people do this effortlessly (apparently) ...
-1
votes
0answers
25 views

How to set Gmail's default incoming font as sans serif?

Some older correspondondents use annoying serif fonts in their email messages. I would like them displayed in a sans serif font. Is there a way to set this up, preferably automatically?
-1
votes
0answers
7 views

Chrome Popup disables my video speed controls, how can I prevent that?

I have tons of training videos to watch - many are simply drawn out blah blah story lines and later I have to complete a test on the subject material. I have other training videos I can speed up with ...
-1
votes
1answer
24 views

White pages while printing

I've made a simple sheet to generate a random list of words to be printed. I don't know why but even if I've made the formula to check the number of words in column A of "lista" tab, on the print tab, ...
-1
votes
0answers
12 views

How to make my github.io site Google searchable

As with previous questions about this topic, I am a broke boy who cannot afford domain names so I use free online services. I am trying to publish quotes in a way that they can be googled. How can I ...
-1
votes
0answers
7 views

CICIDS2017 dataset for Flash events records

I am working on DDOS attacks and flash events. I need flash event records. Can I use normal traffic in CICIDS2017 dataset for flash events?
-1
votes
0answers
9 views

How can I select which font I want to be available in the font selection dropdown menu in Microsoft Outlook web application?

How can I select which font I want to be available in the font selection dropdown menu in the Microsoft Outlook web application? I would prefer to be able to have a small list of available fonts ...
-1
votes
0answers
25 views

Facebook Live problem

Text is shown backwards in the "Connect" (say something about this video) window of Facebook Live but shows correctly in the Title window.
-1
votes
1answer
39 views

UNIQUE ,INDEX AND IMPORTRANGE

I am stuck. I use the import range to get a set of data however now I need to the unique values that that matches the import range that I have. Say for example below is randome sample. I have import ...
-1
votes
0answers
9 views

How to disable automatic hyperlink creation?

Not sure if this is the right stack. Feel free to down-vote/migrate if needed. On several sites, such as YouTube, if I type a comment with multiple sentences and inadvertently forget to add a space ...
-1
votes
0answers
6 views

Google Line Chart Showing only Last Values

I am currently trying to get a line chart with data from a DB. I have the data showing and am able to retrieve a single line but the issue is when I add multiple columns it is only showing the last ...
-1
votes
0answers
4 views

Averaging cells if cell contains “Word” AND the word equals a “#”

Okay, here's my issue: My students are receiving scores every week in 5 different categories. The scores are listed as "Expanding", "Competent", "Developing, and "Beginning". I need a formula that ...
-1
votes
1answer
14 views

Is there a way to sum a bunch of IMPORTDATA() outputs?

I am attempting to sum quite a few different ranges of IMPORTDATA() I want to do something like: =SUM(N9:N14,N16:N21,N23:N36,N38:N53,N55:N106,N108:N113) My issue is it can't sum up a bunch of ...
-1
votes
1answer
36 views

GAS MailApp.SendEmail - include multiple attachments using ss cell value

I have file names separated by commas (no spaces) in a google sheets cell 'filez1.pdf,filez2.pdf'. If I assign a variable as a string; flist = "filez1.pdf,filez2.pdf" or an array flist = ["filez1....
-1
votes
1answer
40 views

Can Google Spreadsheets cache images?

I want to create a resource for a browser game and I need to export a ton of character portraits. The url of those portraits is automatically generated with character's id, so you can just load them ...
-1
votes
1answer
17 views

Can I use photos on my personal google drive account for my business website?

Hi I am thinking of images that are used on my website on to the public folder of my google drive account and access it using <img src="some.gdrive.link.com">. Can I use google drive in such way ...
-1
votes
1answer
43 views

how to sign into google mail in one step

I only have gmail, but last week my mail opened with an extra step, by asking me to choose an account. I clicked on the gmail with my name on it, and then the password request came up. How do I ...
-1
votes
2answers
37 views

Mark all line if checkbox is true

I will give an example: I have checkboxes in B3:G3. This is a checklist, I want to change the background color to green for A3:H3 if B3:G3 boxes are checked. Can someone please tell me how to do ...
-1
votes
3answers
18 views

How do I sort data by size and not in ABC order

I am new to Google Sheets and have only used Excel a little, so Google Sheets is a bit different. I want to sort our band uniforms in size order from smallest to largest but Google Sheets only sorts ...
-1
votes
1answer
34 views

Google Spreadsheet Trigger which will fire when the active selection changes for a given sheet

This would be equivalent to the Excel Worksheet_SelectionChange event.
-1
votes
1answer
37 views

How to categorize/tag cells containing long text according to a list of phrases?

I have cells in a google sheet which have long abstracts. I need to mark/categorize these abstracts in an adjacent column, according to a table of phrases and corresponding tags in another sheet. As ...
-1
votes
2answers
33 views

Query the result of a query in the same cell

I don't know how else to put it of phrase it, I am really stumped here. I will put what I have down below and hopefully, someone will understand what I am getting at. =QUERY(Sheet3!A:B,"select B ...
-1
votes
2answers
17 views

How to archive cell changes in new tab?

I have a Google sheet that I'm collecting some statistics in. There is a particular cell that I'd like to track changes in a separate tab. I'm looking for a function to copy cell if the cell data ...
-1
votes
1answer
32 views

Google Sheets images

When I insert an image in a cell in Google Sheets from my camera how is that image stored in the cell? I know it creates an image in my phone in a folder called images, but if I want to link that ...
-1
votes
1answer
21 views

Which event can I use to detect remote form submission into sheet?

I'm using the WordPress Contact Form 7 plugin as a website contact form. The user's date is submitted to a google spreadsheet and stored as a new row. Which event can detect that that information was ...
-1
votes
1answer
37 views

Scraping currency conversion rate from Oanda.com

A currency conversation formula for example: =GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,) Will display the closing price by default under "price". There is no option for the Average price. ...
-1
votes
2answers
135 views

Strange Event in Google calendar

⏳ПОДТВЕРДИТЕ ПОЛУЧЕНИЕ ДЕНЕЖНОЙ ВЫПЛАТЫ. Уведомление от Центра Безопасных Электронных Платежей. Вам начислена денежная компенсация. Получите денежные средства сегодня ➡ [spam link] This is the event ...
-1
votes
1answer
24 views

How do I find latest invoice number & dates?

Trying to find a formula for the latest date and invoice number. Here is my sheet: https://docs.google.com/spreadsheets/d/1T_rFYDCQhqfrsU9claYPHQTrEz68zpUFKG9HZqqV4Z8/edit?usp=sharing
-1
votes
1answer
102 views

Using SUM in Google Sheets with indirect ranges

I need to use SUM formula to fill the Total formula until next Total comes in Google Sheets like this: Total 6 A 1 B 2 C 3 Total 15 A 9 B 6
-1
votes
1answer
38 views

How to nullify empty output errors in Google Sheets?

I am using the following code in many cells of the sheet, =SPLIT(REGEXREPLACE("" & S2, "(\d)", "$1,"), ",") not all are going to contain data at any one time. How do I stop the empty cell value ...
-1
votes
1answer
15 views

Stop drop-down box errors

So I'm trying to use the drop-down menus to restrict human input, but there is a formula than can fill in those cells with information that I don't want humans to be able to enter in. The formula does ...
-1
votes
1answer
17 views

Automatically name current version when Google Sheets is opened

I'd like to automatically maintain the original version of a Google Sheets file whenever the file is opened. Manually, this would involve simply opening the file and selecting File/Version History/...
-1
votes
1answer
18 views

How to display a text after a choice is selected in google form?

So I have my drop down connected to spreadsheet. There are two column which is ID and Name. In my google form, I want the user to select the ID but not the name. The name should be shown according to ...
-1
votes
1answer
82 views

Function OnEdit run slow and timeout error

I have a short timestamp script for my google spreadsheet. But it run quite slow and make a lots function onEdit(e) { var TIMERECIEVE = [0,-29]; var DATETRECIEVE = [0,-28]; var DATEDONE = [0,-...
-1
votes
1answer
462 views

Lost phone contacts after deleting Gmail acount

How can I restore my Gmail account once I've deleted it and it's been almost a month since I deleted from my iPhone 10? I have lost most of my important contacts and no other way to recover
-1
votes
1answer
56 views

How do I copy a friend's Facebook profile picture to Google Contacts?

How do I copy a friend's Facebook profile picture to my Google Contact entry for my friend?
-1
votes
1answer
256 views

Why doesn't google forms recognize responses manually added to the responses sheet

I'm trying to see if I can add responses to a sheet manually through a proprietary application but whatever response I add to the sheets document is pushed down and isn't recorded on the responses ...

15 30 50 per page