All Questions

5,900 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
2answers
147 views

inputBox in onEdit does not work for users

I have a strange problem... Simple function like: function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet() var sheet = ss.getActiveSheet() var ui = SpreadsheetApp.getUi() var response = ...
0
votes
2answers
3k views

How to allow file upload without login in Google Forms?

I would like to create a Google form for submission of abstracts. Participants should have the option to add images, Excel files, or PDF. However, as soon as I add the File upload field in Forms, one ...
0
votes
1answer
62 views

Formula not working on Google Sheets #error! Formula Parse Error

I have uploaded an excel spreadsheet that works fine but shows as an error on Google Sheets. =SUM(H12,N12,T12,Z12,AF12,AL12)/INDEX(FREQUENCY((H12,N12,T12,Z12,AF12,AL12),0,2)) Its calculating average ...
0
votes
1answer
59 views

How to merge G Suite Gmails on separate domains?

Company has a G Suite account with all the services, e.g. user007@a.com emails. Company changes name from A to B and gets another a G Suite account with emails user007@b.com. Now it is time to c**) ...
0
votes
1answer
228 views

Testing out different scenarios in google sheets

I created a spreadsheet that calculates salaries for employees using a few different models of growth (different base, different rate of increase per year) . It takes a date and calculates monthly ...
0
votes
1answer
25 views

Adding numbers to a cells formula?

Let's say A1= X+Y Now I'd like to add +Z with a script so I end up with A1= x+y+z. I know how to copy it, or overwrite it, but not sure exactly how I would add to it with a changing formula in A1. ...
0
votes
2answers
78 views

Replace value in field automatically (auto-correct?)

I'd like to replace occurrences found in Column A (cells A2:A200) so that if I enter 2/02/002 or 343 or 98/098 it auto-replaces it with UKD002/UKD343/UKD098. Is this possible?
0
votes
1answer
15 views

How can a forumula be converterd to array formula in Google Sheets?

How can you convert these to array formula? =IF(COUNTIF($I:$I, $A:A)=0, "No", "Yes") and =CONCATENATE(C3," ",D3)
0
votes
1answer
26 views

Sum of time in Google Sheets' chart

I tried to show a chart where the values are the sum of times. It looks ok in the spreadsheet with for example 19 hours and 25 hours but in the chart, the 19 is ok but the 25 is shown as 1. The format ...
0
votes
1answer
86 views

Arrayformula for running MAX of separate column

I'm trying to use ARRAYFORMULA in Google Sheets to get the max figures from a separate column only up to the row being calculated each time but can't for the life of me figure out how. It sounds more ...
0
votes
3answers
377 views

Google Sheets COUNTIFS Range of cells as criteria possible?

In the Google Sheets Formula =Countifs, is it possible to have a range as a criterion, for example: =COUNTIFS(ExampleSheet!A1:A10, "Some criteria", ExampleSheet!B1:B10, List_of_Names!C1:C) I couldn'...
0
votes
1answer
149 views

How do I switch Gmail from top-posting by default to bottom-posting by default?

I can't seem to find any option for switching Gmail from top-posting by default to bottom-posting by default. I can do it by manually expanding quoted stuff and moving the cursor, but I'd rather be ...
0
votes
1answer
14 views

How to sum values of the same row from different columns in a separate sheet with QUERY?

I'm trying to add up the value of cells in the same row but different columns to another Google sheet. Example below:
0
votes
1answer
10 views

filter BCC emails

I have been reading a lot of emails that I should filter the heading for bcc. The prob is no one shows the steps. Can anybody help? I'd like to filter my bcc's in my email.
0
votes
1answer
2k views

How do I see a list of archived emails in Gmail in the order of when I archived them?

The "Done" view in Inbox by Gmail (sunsetting in March 2019) allows me to review my recently archived emails, in the order I archived them (with the most recent at the top). Is there a search I can ...
0
votes
1answer
21 views

Data Validation for Sheet1 from Sheet2 list

I'm trying to figure out how to validate data entries in one column on sheet 1 from a database I created in sheet 2. In column A sheet 1 the user is allowed to type in a string, upon completion it ...
0
votes
1answer
294 views

Google Sheets function returns an incorrect value

I have a very simple function for every cell in column D, for example: D24 =C24-(B24*N$2) Example with values: D24 =10-(1*6,5) This works; however, not all the time. For cell D24 this returns a ...
0
votes
1answer
369 views

How to import data from Investing.com into spreadsheet?

I want to import the live individual stock price in the Google Sheets as highlighted on the image. Is that possible? https://in.investing.com/equities/jagson-airlines-bo
0
votes
2answers
1k views

Can you block someone on Instagram if their account has been deactivated?

This is kind of petty but I cannot understand how a deactivated Instagram account can be blocked. A friend claimed to have blocked me after deactivating my account. He assumed I blocked him. My ...
0
votes
2answers
235 views

How to make date automatically display only day number and suffix (1st, 2nd, etc.)?

Title explains it. I need to know how to create a custom number format in which a cell would display only the date and suffix of a full date entered into the cell example:1/05/2019 -> 5th I have ...
0
votes
2answers
838 views

How to merge Google documents with PDF files automatically?

I am trying to merge different file sources into one Google doc, in a programmatic way. That means I should use Google scripting. So far I do not have problems inserting text files, images, MS Word or ...
0
votes
1answer
26 views

Adding people to my group in Facebook

I have over 5k people who like my page. The group I created within the page only lets me invite one person at a time. When I click "invite people who like my page" the screen comes up but I'm not able ...
0
votes
1answer
123 views

Is there a way to tell if a person is on Messenger or Facebook

Is there a way to tell whether a person is on Facebook or Messenger?
0
votes
1answer
72 views

Working with multiple If statements, data validation and multiple sheets in Google Sheets

I'm working on a spreadsheet and could really use some help. I'm trying to populate cells in a main worksheet with cells from another worksheet within the spreadsheet. Currently I'm planning on ...
0
votes
2answers
216 views

Are permissions granted by IMPORTRAGE bi-directional or one-way in Google Sheets?

If I want to import "Sheet A" from one workbook into "Sheet B" in another workbook by using =IMPORTRANGE() inside of Sheet B - when I grant it access to Sheet A is that permissions only 1 way? Meaning ...
0
votes
1answer
12 views

Can I stop all comments on Facebook posts on a page I manage

I am having issues with one person making inappropriate comments on a Facebook page I manage. I know I can ban/ block this person but feel we would get more repercussions. Can I stop everyone/anyone ...
0
votes
2answers
529 views

Is The Facebook “Keep your account secure” Checkpoint Authentic?

I don't use Facebook often, but I'm logged in all the time on my primary browser, so I can access it whenever I want. A few weeks ago I was on my timeline, browsing and making the occasional comment, ...
0
votes
1answer
1k views

Searching dropdown list in Google Forms

Is there a way to search for items in a dropdown list in Google Forms? If you have a lot of items to choose from, can you start typing to either eliminate other choices or search for choices with the ...
0
votes
1answer
93 views

How can I complete disable Google Hangouts from all devices?

How can I complete disable Hangouts in my Google account? I want to close Hangouts, without disabling my entire Google account. I don't want anyone to be able to message me. If anyone tries to ...
0
votes
1answer
874 views

Moving bulk saved places in between labels in Google Maps

I have a lot of places saved in my Google Maps, which are currently saved under Starred places which is a list that can't be shared. Is there an easy way to move multiple saved places to another list ...
0
votes
1answer
984 views

How to open tweet-embedded YouTube in new tab directly?

I often see tweets that have embedded YouTube videos without an actual link to them in the text contents. Example: https://twitter.com/SCSsoftware/status/996772457125240832 My followees mostly ...
0
votes
1answer
58 views

How can I agglomerate similar rows in a pivot sheet?

I have a data sheet where are stored numerous matches that I played. Each match has a number of relevant columns such as Opponent and Result. I have made a pivot sheet that counts for each opponent ...
0
votes
1answer
37 views

Mediawiki extension: moderation

I have added the extension and installed it according to the instructions given on the page but cannot find the Moderation page on Special Pages.
0
votes
1answer
628 views

Steam Webapi & Hours played for a specific game - Google Sheets

So I have managed to get a list of owned games and total hours in each game with =importJson. The only issue is I only want data for one game. The json query returns all owned games. The api wiki says ...
0
votes
1answer
101 views

Can I eliminate redundent totals in google pivot tables?

Given the general difficulty of doing much with google pivot table, I expect the answer to be "No". In the snippet below I would like to keep lines with the totals in green shading and not see the ...
0
votes
1answer
341 views

People and Skype contacts not synchronized in Outlook.com

Recently I decided to move back to my old Microsoft account from another Microsoft account and make is absolutely clean and organized. I've run into a couple of issues which MS support cannot (or don'...
0
votes
1answer
170 views

How to check whether sample rate really work in GA Dashboard?

I have a bit issue after set up sample rate on site as below, ga('create', 'UA-XXXXXXX-X', 'auto', {'sampleRate': 6}); we don't see the message at the top of the report that says "This report is ...
0
votes
2answers
228 views

I cannot comment on YouTube after I watch a video. I'm using my Kindle and it says “…oops something went wrong”

I am unable to comment on videos I watch. It says "..oops something went wrong". I watch on my Kindle. What can I do?
0
votes
1answer
32 views

Does your Facebook posting frequency determine how your content is shown to others?

This is purely anecdotal, but I used to post and engage with Facebook a lot more earlier in the year, both with my own posts and liking others, commenting, etc. Whenever I posted an event or something ...
0
votes
1answer
46 views

Google Group made me subscribe with a strange email?

I was trying to join a Google Group for my university. I added my Yahoo email address and got an email on that Yahoo email saying "you requested to join a Google Group blah-blah-blah Join This Group" ...
0
votes
1answer
505 views

Compound Interest Daily Google Spreadsheets

How would I take a fixed rate such as 1.5% use daily compound interest in order to exponentially grow another number? For example, I have an interest rate of 1.5 every day I want 1.5% of 1,000 to be ...
0
votes
1answer
1k views

Two Gmail accounts exist with same email id

Two weeks ago I created a Gmail account with id example@gmail.com in my Chrome browser. I was able to login to the account from the same browser but when I tried to login using a different browser or ...
0
votes
1answer
163 views

Use one e-mail address for login and different to send/receive e-mails

I am the administrator on a G-Suite for Education domain. We have a domain name set up (say ourschool.org) and students use username@ourschool.org to log in to their Google accounts. Our MX records ...
0
votes
2answers
175 views

Keep posts on Friends' timelines from appearing on mine

When I post on friends Facebook Timeline, whatever I put there appears on my own as well, how can I stop this. I'm not putting it on mine, only theirs.
0
votes
2answers
252 views

How to calculate the average of values in Col. B, if Col. A contains a unique timevalue of Col. C?

This is how my table looks: (in column A) (in Column B) (in Column C should be) (in Column D should be) 2016-01-01 08:00:00 80 08:00:00 240 2016-01-...
0
votes
1answer
2k views

Insert cell's note from a relevance cell of another sheet

I am making a few of matrix of educational programs. I need to insert cell's note (for example in sheet D1) from a cell of another sheet (for example sheet "dict_LO") by key cells of both sheets with ...
0
votes
1answer
22 views

If I manually paste files into Dropbox that are already synced on other machines will they create conflicts?

I've got 200gb of files saved in Dropbox and synced across various machines. One of the machines is about to have a hard drive swap (500gb to 1tb) and clean install of OS. We don't have the fastest ...
0
votes
1answer
102 views

Move a Facebook chat window horizontally

In Facebook I sometimes read my news feed while chatting. I also have chats that I don't want to close because I haven't replied yet. This leads to situations where the chat window of the person I ...
0
votes
1answer
51 views

Email messages incorrectly marked as spam

Frequently, emails that are from a person on my whitelist, are sent to spam, so I have to check spam countless times a day, in case I miss them. Does anyone know: How do I stop this? Why is it ...
0
votes
1answer
182 views

Submission of form in two stages

I don't think this feature is part of the Cognito Forms system, but inquiring here to see if I'm missing something. We need to be able to have a two-part form, where users will submit the first part ...

15 30 50 per page