All Questions

0
votes
0answers
5 views

How do I track UTMs in Google Analytics

Scenario : I create a URL with the following parameters example.com/abc?utm_source=Advertising&utm_medium=MyStore&utm_campaign=Content I email it to colleagues to use in articles they write. ...
19
votes
2answers
66k views

How do I create a box plot chart in Google Spreadsheets?

I want to create a simple box plot from 1D data, which doesn't seem to be supported by the default Insert → Charts. There is a histogram gadget but I haven't seen any box plot gadgets. Do I ...
1
vote
1answer
9 views

Why does Google Maps give different coordinates from what was entered

When I enter the coordinates 37°01.67'N 027°25.12'E into google maps it gives me the pin in the correct place, but seems to change those coordinates and gives conflicting results
0
votes
0answers
6 views

Slack: is there a way to know how many people viewed a particular message?

I'm trying to figure out if it's possible to know how many workspace members have viewed a particular message in slack?
0
votes
1answer
80 views

Hebrew Calendar in Google Spreadsheets?

Does Google Spreadsheets support the Hebrew Calendar in any way? If not, are there any workarounds for representing dates in this format?
0
votes
0answers
3 views

Zenodo s new OAuth application [on hold]

where to find redirect URIs, adding a new application on Zenodo s user account?
0
votes
0answers
13 views

Facebook page policy regarding sharing of same url & description with different infographics

My website is centered around a single product. I usually create several infographics (images) relevant to my target audience and share on my website. I am thinking of sharing these infographics on my ...
0
votes
0answers
3 views

How do I access the Google login page for a non-SSO account, if an SSO IDP is redirecting me?

I have a work google account and a personal google account. The work google account uses a SAML identity provider (like Auth0, Okta, OneLogin, etc). The personal google account is just a regular non-...
0
votes
1answer
16 views

Query Function Not Putting Consolidated Data in the Right Place

So I don't know how to explain this completely, but basically, I'm using the query function to consolidate data from multiple sheets into one Master Sheet. The function itself seems to be working fine ...
-2
votes
0answers
9 views

Catphishing / cat fishing while using Hangout

Someone played me on Word With Friends and started a conversation there and then suggested we move the conversation to Hangout. After a few weeks of talking we're in love, don't laugh, and he is ...
0
votes
1answer
6 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 ...
0
votes
1answer
19 views

Multiplying a cell value on edit

I am trying to make a functionality that allows me to enter a value into a cell and have that value automatically be multiplied by another cell, overwriting the original entry. For example, if Cell ...
0
votes
1answer
13 views

Importrange when copied to other cells automatically change range

I am using importrange to pull data from my responses page to my spreadsheet. I have completed the first sheet but I now need to go into sheet to to follow on where sheet one has run out of space. The ...
5
votes
2answers
6k views

Add a CheckBox with a script

How can I use a script to add a CheckBox to a Sheet? This is probaly trivial but I could not find a single example online and the CheckBox class isn't even mentioned in the docs. From the GUI, I ...
77
votes
7answers
316k views

Is it possible to add a checkbox/button equivalent?

What I'm looking for is a one click enable/disable or toggle in some form. The closest I've come is manually editing a cell to enter a 0 or 1, but I'm hoping there's a nicer pattern. I know there's ...
166
votes
6answers
494k views

How do I link a cell in Google Spreadsheets to a cell in another document?

I have a monthly spreadsheet that relies on figures from the previous month. I'd like to import these values dynamically rather than cutting and pasting them. Is this possible? How do I do it?
0
votes
0answers
2 views

Prevent like emoticon

How can you prevent the like emoticon from appearing on Facebook if you write (Y)? I would like the text (Y) to be visible in the comments.
1
vote
0answers
5 views

How can I ignore notifications for @everyone and @here for all Slack channels?

How can I ignore notifications for @everyone and @here for all Slack channels? I know that this can be configured for each channel but and looking for just 1 setting for all Slack channels, as it ...
2
votes
3answers
363 views

Code invoked too many times

My goal is pretty simple: take the value in column U and check if it's within particular ranges. If it's 1–100, put a 1 in column A. If it's 101–200, put a 2 in column A. The problem is, I have almost ...
2
votes
1answer
1k views

Prevent “invoked too many times per second” error in Google Apps Script

I have a Google spreadsheet consisting of different months on each tab. Every month, I add a new tab and another 50-75 rows. There are many tabs. There is a cell on each row which calls a custom ...
3
votes
3answers
3k views

Disable HTML5 on YouTube without account?

YouTube seems to be defaulting to HTML5 for me (using Chrome), such as this video. I'm unable to login to YouTube ("You are not eligible to create an account." on “Sign In”), so how can I turn off ...
0
votes
0answers
11 views

How to generate Backlinks? [on hold]

I'm trying to generate backlinks for my website but I don't know how to find blogs or websites where I can search the list of websites.
0
votes
1answer
26 views

Why would I be getting the error: Too many simultaneous invocations on a simple once a day trigger?

I've searched around and still can't find anything directly related to the failure message I'm receiving. The script hasn't changed and it used to run just fine, but now in the past week or so it's ...
0
votes
2answers
22 views

Empty cell reference when “Loading…”

I want to do a calculation with imported data from an HTML link. The data is imported every minute. There is a loading time and this ensures that the cells are empty during loading. Because my formula ...
0
votes
1answer
75 views

How to use the “Make a Copy” trick when sharing a Google Form?

I want to share a Google Forms file with customers and, when each one of them open it, I want the file to automatically ask them if they want a copy of the file in their own directory.
0
votes
1answer
384 views

Can I use conditional formatting to highlight a cell for dates less than 30 days away?

I have a large spreadsheet where I need to keep track of coming expiration dates and I would like dates which are within 30 days from today's date OR which have already passed to be highlighted in red....
14
votes
2answers
12k views

How to remove accounts from “Choose an account” list in Google sign in?

When signing in with Google (OAuth), it shows a list of accounts it already knows about. How can I remove some accounts from this list? I know I can nuke all of them by deleting all cookies, but I'd ...
-1
votes
0answers
10 views

On Deleting a label through google contact api v3, it deletes the label however moves all the contacts to other contacts

On Deleting a label through google contact api v3, it deletes the label however moves all the contacts to other contacts. I want to delete the label and all its contacts instead. The URI invoked is ...
0
votes
1answer
815 views

Cell values ​do not update

I want to update every minute a cell with data from a HTML link. The problem is that the value does not update unless I manually empty the cell or make changes to the script. I tried to add NOW() to ...
0
votes
1answer
316 views

What is the difference between accounts.google.com and myaccount.google.com

(EDIT: Linked to https://support.google.com/accounts/thread/6363189?msgid=6363189) I have my old Email address X@gmail.com Initially I used an eight char password, but later I changed to an 11-char ...
4
votes
2answers
6k views

Google Calendar: Recurring Event Every X WEEKdays?

I need to create a Google Calendar event that repeats every 3 days, but NOT counting weekends. For example: Mon, Thu, Tue, Fri, Wed, Mon, Thu, etc. I know how to do a "repeat every X days" but it ...
1
vote
3answers
6k views

Formulas in Google Sheets won't execute

I can't seem to get formulas to execute in a Google spreadsheet. Whenever I input a formula, it does not return any output, but rather leaves the cell blank. I have tried the following troubleshooting:...
5
votes
1answer
277 views

How can I make a personal Google calendar show times as busy when coworkers of mine schedule appointments with our Google Apps at work?

I have a personal Google calendar, associated with my own personal Google account, and a work Google calendar, as part of my office's Google Apps setup. Whenever co-workers of mine try to schedule ...
-1
votes
0answers
39 views

Cannot access google account [duplicate]

I have an account associated with an email. I have forgotten the password. It is associated with a mobile phone that I no longer own. I go through the steps looking for another way to verify. I ...
3
votes
1answer
17k views

How do I disable the add friend button for mutual friends on Facebook?

I have seen on Facebook that it is explicitly possible for a user who shares mutual friends with another user to somehow disable the ability to become added as a friend. This is regardless of recent ...
-1
votes
1answer
24 views

Google Maps XXXXXXXX [on hold]

I go to Google Maps to direct me to a location. It does not show the street names and therefore is useless to me. Is there a way to do. Get the street names on the map? If there is I hope it is easy....
0
votes
0answers
11 views

Filter “one of the following keywords” in Tweetdeck doesn't work

I created a Twitter list with some accounts. Now I wanted to filter "one of the following words mentioned" by one of those accounts which the list includes. I tried: "keyword" or "keyword or "keyword....
8
votes
2answers
16k views

Enable posting by email

I am participating in a Google Group, and it is not possible to post by email: Delivery to the following recipient failed permanently: foo@googlegroups.com Technical details of permanent ...
-1
votes
0answers
108 views

Changed my Google password, but google drive (Backup & Sync) from PC has still access [on hold]

I changed today my Google Account password (from my Phone at the website), after that i started my PC and recognized that google drive (Backup & Sync) from PC has still access to my Account and is ...
2
votes
1answer
402 views

Aggregate results by week and month for charts

Is there a way to convert daily values into weekly averages for charting? Sample source sheet --------------------------------------------------- | Data 1 | 1/1/2018 | 1/2/2018 | 1/3/2018 | etc......
0
votes
1answer
509 views

Lost phone number and PayPal need verify by phone number

My account was locked I can't log on my account and my recovery option was my email only but I made my account when I still had my old number, and have no way of accessing that number, and can't send ...
1
vote
2answers
3k views

Can't add a secondary Facebook email because it's “owned by a disabled account”

I'm trying to change my Facebook email, by first adding a secondary email to my account and then make it as primary, but I can't seem to do it because "The account that owns the email address you ...
0
votes
1answer
56 views

Move ROW upon selecting a specific option from drop down menu

I am looking to use Google Sheets to keep track of my jobs. I have a spreadsheet set up so the status of a job is indicated by a dropdown menu. When a job is completed I would select "Closed" from the ...
13
votes
2answers
5k views

Custom Gmail labels sort

I want to sort the labels in my own order instead of the default abc order, so that, for example, the label named bills should come up first. Any way to do that?
0
votes
1answer
8 views

How to paste a comma separated string into one column in Google Sheets?

For example, if I have (bob, china, bing, bong). I want to put bob on top of china on top of bing on top of bong.
0
votes
1answer
520 views

Can I request to remove a Facebook page that were hacked/hijacked from me?

I tried everything from Facebook support to recover my page but they said since it was a friendly hack, they couldn’t give me back my admin rights and there’s no hope for me to recover the page ...
1
vote
1answer
24 views

How can I track the time it takes for someone to fill out a Google form?

I am running a study for my thesis, and would very much like to track the time it takes to complete a Google form to compare against how long it takes to fill.
0
votes
1answer
85 views

Is it possible to use checkboxes to determine what data is in a list?

This is hobby related, so feel free to ignore. I want to learn how to use Google sheets, and am doing so by building a partial DnD character sheet, piece by piece. I am trying not to use scripts as ...
1
vote
1answer
204 views

Change text case so that first letter of the sentence is capitalized

Want to automatically change text case as I type on Google Sheets so that first letter of the sentence is capitalized.
0
votes
1answer
18 views

Youtube player shortcut or extension to change to next higher or lower video resolution

I watch general videos on youtube at 720p and programming/ tutorial videos at 1080p I have searched a lot and its almost certain there is no keyboard shortcut to jump to the next higher/ lower video ...

15 30 50 per page