All Questions

1
vote
1answer
7 views

Restrict entry to a group of cells based on the value in another cell

I am creating a work schedule where the staff enters their own schedules. I only want a certain number of staff each shift. I already use COUNTIF to show the number of staff signed up for each shift. ...
0
votes
1answer
17 views

How to apply scripting only to rows with data in them?

I have a Google Sheet that adds multiples rows per day as forms get entered. What's the best, most hands-off way to apply formulae to rows as they get added? I've built a script, but it applies the ...
0
votes
2answers
26 views

How to group data (by row and column) in a Google spreadsheet?

I have data as follows: Name | Value | Y/N | Value | Y/N A | 10 | Y | 12 | N B | 100 | Y | 120 | N A | 20 | Y | 10 | Y B | 200 | N | 120 | Y C | 1000 |...
1
vote
1answer
15 views

How can I create a unique list of data across multiple rows AND columns?

Google Sheets has a UNIQUE() function which when given a column of values, will output a column of all unique values. This works well for column-specific data, however, you have multiple columns and ...
0
votes
0answers
6 views

How to create a line chart from a key-value dataset?

I have created a script that tracks twitter followers over time, for many accounts, the data is saved to a table that looks something like this: +------------+--------+-------+ | DATE | USER |...
0
votes
1answer
22 views

Google reverse image search in a specific country

I want to use Google to search for a specific image inside a specific country (IP)! Using http://images.google.com/ gives me results for all sites, but I can't sort results by country. It would also ...
-1
votes
0answers
8 views

Instagram anonymity and hashtag posting and followers [closed]

I was wondering what percentage of Instagram users manage to remain anonymous. If someone grabs someone's phone and posts a hashtag with their picture from their profile everyone will be able to see ...
0
votes
0answers
31 views

How to prevent email sent by other accounts appearing in Sent

My setup is as follows. I have two Gmail accounts: a main Gmail account, and a secondary one that I have so I can use Google's SMTP server. This SMTP server account is used whenever I need a server/...
0
votes
1answer
55 views

Removed labels - where did my emails go?

I've been using Gmail for quite a while and I have about 15000 emails in total, only partially sorted using labels. Using Gmail itself to sort them is a nightmare for me, so I decided to use ...
0
votes
1answer
8 views

Can you make a sheet in Google Sheets visible for certain group?

I have a spreadsheet for a timetable where about 5 people work on. I want only the spreadsheet owner can view and edit certain (confidential) data. This confidential data is needed for formula's in ...
1
vote
1answer
16 views

Why is my Twitter Page in Arabic?

My Twitter page shows up on Google searches in a language I assume is Arabic, and Arabic is the default language when I log in. I have tried to change it back to English in settings, but it changes ...
-2
votes
0answers
13 views

How To Get E-Mail Notification Before 7 Days When Reserved Instance Expired in AWS [duplicate]

i tired to find the e-mail notification services when reserved instance going to expired. please send me link for that services/setting in AWS
2
votes
1answer
18 views

Timestamping purchase entries

I’ve created myself a budget tracker where I can track what I bought and how much I spent across a few categories. I specified column B (purchase entries are rows) to be the date and time at which I ...
-2
votes
0answers
27 views

I am not able to react or comment on my Facebook friends' posts [closed]

I do not understand my violations why is it I can no longer like, say wow, happy, love signs in my friends photos, stories and comments. It is important for me to express how I react on their posts. ...
0
votes
0answers
19 views

Get Google to resend my 2FA code without retyping my password?

Since I have two factor authentication on my account I have to use my phone to type in a code sent via text message. Sometimes it may not come in right away and after a while a message pops up ...
-1
votes
0answers
9 views

Need to download URLs of all Pinterest Pins [closed]

I am searching for a solution to this problem. I have collected links to web resources to support technology integration in education on Pinterest. Lots of them. I want to be able to gather the URLs ...
1
vote
1answer
16 views

Problem combining LEFT() and QUERY() functions

I'm currently working in Google Sheets and I need to import a part of a row from a spreadsheet to another. I'm importing the row with the QUERY() function and "cutting" the data from the row with LEFT(...
-2
votes
0answers
16 views

Why can't I see Facebook posts for one person?

I don't friend people on Facebook or really do much besides post in groups. When I go to an individual's Facebook page, I can usually see their latest post. For one individual that I know, I can only ...
0
votes
1answer
10 views

Can you add to a Github pull request after the source repo is deleted?

I've opened a pull request (PR) on a repo, but then managed to accidentally delete the branch I initiated the request from. The maintainer of the project has requested I make a couple changes.. now I'...
-2
votes
0answers
14 views

What make messages to Facebook page not delivered?

I know that if you send a message to a person who isn't connected with you in Facebook, then the message will only has the status Sent until the person accepts it. However, my message to a page is ...
-2
votes
0answers
16 views

Deleting messenger conversation on both sides [duplicate]

I need to remove a conversation history on both sides. Asking politely is not an option i'm afraid. This statement seems logical. Has anyone tried it and does it work? "start by accessing your ...
-1
votes
0answers
21 views

Facebook logs me into incorrect account when using mail that differs only in number

So my issue is, I have several emails, where all of them are in form: abc1@def.com abc2@def.com abc3@def.com ... When I log into Facebook with one of them, for example abc2@def.com, then log out and ...
-1
votes
0answers
10 views

Web test recorder [closed]

Hi I am a technical support,I had an issue I am in able to find web test recorder add on in internet explorer anyone please help
0
votes
0answers
5 views

How to change the username in Google Chrome profiles? [migrated]

I have two profiles in my Google Chrome: Joe and Sam. I would like to rename the name of my profile into "JoeJobs" but I can't find any way to do it. I'm only getting "Manage people" and "Remove this ...
1
vote
0answers
26 views

Can we use Google Drive to embed Mathematica CDF demonstrations in the new Google Sites?

I am concerned here with the exact premise of the following question on Mathematica Stack Exchange: How to embed a Mathematica demonstration in Google sites The very-helpful top-voted answer already ...
1
vote
1answer
21 views

How to subscribe to YouTube comments?

Is there a way to subscribe to YouTube comments under a particular video? I only see how to subscribe to the whole channel of a particular user.
-1
votes
0answers
10 views

Triggering Add-ons on Google Docs [closed]

I need to trigger an add-on on Google Docs for a batch of documents (100+) at once. Couldn't really find anything helpful on the triggers documentation on Google Apps Script.
0
votes
3answers
31 views

How can I delete my posted issue on GitHub?

I posted an issue on GitHub and I'm thinking, if I want to delete it, how can I do it?
0
votes
0answers
9 views

Multiple POP3/SMTP accounts in Roundcube

I would like to add some POP3/SMTP accounts to my Roundcube mail, in order to receive mails from different accounts and to be able to send from different emails (without having to login/logout between ...
0
votes
0answers
22 views

How do I find an AOL email that disappeared, due to an AOL error message, while I was saving it as a draft

How do I find very important AOL email that disappeared, due to an AOL error message, while I was saving it as a draft? I had worked many hours on it, and cannot possibly remember and rewrite the ...
1
vote
1answer
23 views

How to keep a copy of a Google Doc even after the owner deletes it?

I noticed that when the owner deletes a doc permanently, it becomes unavailable to users sharing it. How I ensure that I keep a copy of it even if it's permanently deleted and with latest changes. ...
0
votes
1answer
17 views

Calculations which won't recalculate

I'm trying to make a simple calculator in Google Sheets with checkboxes for certain values. For simplicity I'll refer to these Checkboxes as A and B. What I would like to have is the user selects A, B,...
1
vote
1answer
16 views

How to access help and support on Twitch.tv

I want to ask some questions and to ask for help for fixing my problems with my account on Twitch.tv but on their website, there is no link whatsoever to anything like "Support" or "Feedback" or "Help"...
0
votes
2answers
16 views

How do I tie an enum to a set of numeric values?

I created a list of items Data Validation in a sheet corresponding to time-frequency: weekly,monthly,annually I want to multiply values in a numeric column with the corresponding weekly values to ...
0
votes
0answers
22 views

Facebook Page linked to a deleted Instagram account

My Facebook page was setup with a Instagram business account (long story short, my page was hacked and deleted). I have tried linking a new Instagram business account but no success. I have unlinked ...
0
votes
1answer
18 views

Making Google Sheets script work on multiple tabs

Below is my script or code: function myFunction() { } function onEdit() { var s = SpreadsheetApp.getActive().getSheetByName('Sheet1'); s.showRows(1, s.getMaxRows()); s.getRange('H:H') ....
0
votes
2answers
15 views

ArrayFormula for consequential sum-up?

Here's a sample test spreadsheet - https://docs.google.com/spreadsheets/d/ What do I have to do in the ONE cell in column D such that I won't have to copy and paste the same formula in column C ...
0
votes
2answers
29 views

IMPORTXML error - empty table

I am trying to import a table from the lower part of the following website to Google Sheets: https://vistacapital.com.br/ I used the formula: =IMPORTXML("https://vistacapital.com.br";"//*[@id='sos-...
1
vote
1answer
9 views

Sum using two filter variables

So I have a ledger sheet that was set up to record costs for a single project. We've added a project column so we can track more than one project so every entry (row) now is identified per project. I'...
0
votes
0answers
9 views

How to change sender address in web.de mail?

How to add custom email sender to web.de mailaccount? This is the best that I could find in the options: Is it really not possible to add another sender mail from web.de like "bob@example.com" ?
1
vote
1answer
37 views

Gmail filters exact phrase matching

I'm having issues with my Gmail filter. It seems to be performing some type of fuzzy matching even though I explicitly defined exact phrase matching. My filter is: Has the words: {"unsubscribe" “...
0
votes
1answer
24 views

Running formatting script across multiple Google Sheets tabs

I have an onEdit script I'm using to protect/force formatting on a single tab within a google sheets document - and it works perfectly. The issue I have is that I'd like the same script to work on ...
0
votes
0answers
13 views

Thunderbird sending umlaute strangely, only from one account

My mothers Thunderbird sends special characters (specifically in this case, German umlaute) wrongly, but only from one account. She has a abcd@gmail.com, a abcd@ourowndomain.com and a abcd@aol.com ...
0
votes
1answer
30 views

Gmail shortcut keys overridden by DevTools shortcut keys

I can't get Gmail shortcut keys to perform the Gmail actions because (I think) the DevTools actions for that shortcut are performed instead. For instance, to mark an email as read is Ctrl+Shift+I, but ...
0
votes
1answer
42 views

Does adding another Google account to your Android phone also sync phone setting?

So today I am adding my dad Google account to my phone to check his email regularly because he is not very good with the phone. When I am done adding my dad account my phone automatically sync ...
1
vote
0answers
3 views

How can I use Google Apps script when advanced protection is on?

I recently turned on advanced protection on my Google account. But today I found out that my scripts embedded in Google Sheets don't run anymore, because they are denied access (Error 400). Does ...
1
vote
1answer
15 views

AVERAGEIFS parse error

=AVERAGEIFS(Sheet12!R:R,Sheet12!A:A,N5,Sheet12!B:B,">=9/16/2018",Sheet12!B:B,"<=10/3/2018") While giving cell range instead of a date value, it's showing error.
0
votes
0answers
5 views

How to send the mail to group by skipping one member

How to send the mail to group while exclude on member except creating rules (If we are creating rules that particular person knows that we are skip him..)
0
votes
0answers
7 views

How to add a single-line space in WordPress when using Visual Editor?

I am using the Visual Editor while editing my blog on wordpress.com When I push (Enter) the cursor will jump two lines down. Is there any way to convince it to jump only one line? At this moment, I ...
0
votes
0answers
3 views

How to prevent sites from overriding hotkeys? [migrated]

When I visit certain sites I notice they have implemented some custom search features, which is fine, but they also decide to use ctrl+f to invoke those features, which is not fine and makes it ...

15 30 50 per page