All Questions

Filter by
Sorted by
Tagged with
0
votes
4answers
2k views

In Gmail how can I view images in long “clipped” messages?

I have a long email message come into my Gmail, often a newsletter. I click the "Display images below" link to see all the pictures, I read through it to the bottom, then see this: [Message clipped]...
0
votes
2answers
78 views

Facebook eliminate country code from phone number and then ask for verification?

Basically, facebook suddenly asks for verification. However, they eliminate the country code from the verification. One obvious explanation is that the guy do not put the country code in his phone ...
0
votes
2answers
39 views

How do I select all emails in on Gmail Category (like the Social tab)?

I want to Archive (or delet) all the emails in a certain Gmail Category (the horizontal tabs) like Social. If I just select all, it only selects the ones that are visible. I want to Archive all of ...
0
votes
2answers
67 views

How can I locate a sheet by name from Google Sheets [closed]

I have a Google Sheets spreadsheet with a large number of sheets. I want to find a particular sheet by sheet name from Google Sheets. I know how to locate a sheet by name using a Google Application ...
0
votes
1answer
234 views

Instagram account linked to Facebook, but cross-posting option not showing when creating Facebook Post?

I have a page on Facebook and it IS linked to Instagram. My Instagram account is a business account and it is also linked to Facebook. When I try to create a post on Facebook the option to cross-...
0
votes
2answers
33 views

Transpose notes / comments in Google Sheets

I've a Google Sheet. I've transposed the data. Is there a way to also transpose any notes/comments that are attached to cells in the original data set?
0
votes
2answers
18 views

Query twice in the same cell to receive a name next to a number in a row

Sheet link I posted before however, I don't think I was specific enough. I am sorry if I am wasting the time of anyone. In my sheet, you will see three pages. On the "Search Notes" page in C5 I ...
0
votes
1answer
23 views

I want to get values from multiple URL's in Google Spreadsheet. IMPORTDATA doesnt work

I have 9000 lines with URL's in my Google Sheet. Example: https://steamcommunity.com/auction/ajaxgetgoovalueforitemtype/?appid=233860&item_type=10). Every URL returns JSON like this: { "success": ...
0
votes
1answer
71 views

How to send to a list of people by bcc in Gmail, but Salutation begin with their first names

In Gmail --- How to: send to a list of people by bcc (blind carbon copy), but in the Salutation, writing Dear ... with their first names. For example, in Bcc: N1, N2, N3, ..., Nj, ... ...
0
votes
1answer
61 views

Replacing data in Google Sheets

I am new to coding! I have data in Sheet 1 of a Larger Spreadsheet that looks like this 25.06.18 and wish to change it to look like 26/06/18 I have tried to write a macro: function Dated() { ...
0
votes
2answers
65 views

Deleting files from Google Drive [duplicate]

I want to remove files from Google Drive, but I don't want them deleted from my hard drive. when I delete something from Google Drive it tells me that it will also be removed from my computer. I don't ...
0
votes
2answers
255 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
1answer
33 views

High performance Google Apps Script version? [closed]

I am planning a Web app tightly integrated with the Google platform. Calendar, Drive, Docs, you name it. My only concern is GAS processing time, as it is well known that script execution is slow. ...
0
votes
2answers
5k 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
69 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
62 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
24 views

Picking a Total from the Current Month

I have this working formula (below) =SUM(QUERY(QUERY({{A2:B},{ARRAYFORMULA(IF(LEN(A2:A), WEEKNUM(A2:A, 16), ))}}, "select *", 0), "select Col2 where Col3 matches '"&WEEKNUM(TODAY(), 16)&...
0
votes
1answer
173 views

How to list total files for every subfolder in Google Drive?

On google drive I have a directory with over 1000 subfolders. I want to list all subfolders with the total amount of files for each subfolder. This is the script I got so far but it doesn't work cause ...
0
votes
1answer
362 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
98 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
16 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
297 views

How to report suicidal comments on YouTube?

As well as contacting authorities, what option should I click?
0
votes
3answers
565 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
171 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
15 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
2answers
39 views

Insert column into Google sheet generated from a Google form to calculate the difference between two columns of data

I have a Google form where people track their company mileage and input "Mileage In" and "Mileage Out." I want to insert a column next to Mileage In and Mileage Out that shows the difference between ...
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
23 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
4answers
49 views

Show a Running Target Based on Today

I'm creating a running target from a quarterly Total divided by known trading days Current formula in I4 is =IF(H3<>"",I3+O$30,"") H3 = Yesterday's Sales Numbers I3 = Yesterdays Running Target ...
0
votes
1answer
435 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
2k 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
309 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
908 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
127 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
79 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
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
611 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
2k 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
172 views

2 timestamps in different cells at the same time [duplicate]

function onEdit(event) { var timezone = "GMT-7"; var timestamp_format = "MM-dd-yyyy-hh:mm"; // Timestamp Format. var updateColName = "Ext Warehouse"; var timeStampColName = "Date/Time Change";...
0
votes
1answer
101 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
934 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
1k 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
2answers
45 views

How do make regular backups of a shared Google folder?

I hope this is the good community to ask this question. I am sharing a Google Drive folder as a work folder for a number of people. They need to have the ability to edit, but I also need to assure ...
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
687 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
189 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 ...

15 30 50 per page