All Questions

0
votes
0answers
4 views

Merging data sets

In a google sheet I have multiple tables containing a list of dates. I want to create a single (sorted) list containing all the dates and the table they came from. Table foo: 1.1.19 3.1.19 Table bar:...
0
votes
0answers
7 views

Edit Sheet data for interactive Google Maps My Places

I am trying to edit the google sheet that feeds Google Maps my Place from a mobile device. I can do it from a desktop application. I have seen this. And my questions is about this. It says we can ...
0
votes
0answers
3 views

Link to view PDF version of a Google slides in browser

I'm trying to create a link to a google slides doc that will open in a browser as a pdf. I've tried changing the end of the URL from edit?usp=sharing to export?format=pdf and a few variations with no ...
0
votes
0answers
6 views

Calculate Discount Based on Total

I’m new to Cognito Forms and am trying to give a discount once a Total is met? I have a FormTotal calculation field but it doesn’t seem to be calculate all the fields! I would like to Total the ...
0
votes
0answers
5 views

Why the instagram story cannot be viewed?

There are three Instagram accounts: A, B, C. A is public. A and B follow each other. C is freshly created, it doesn’t follow anyone and is not banned by anyone. A posts a story. B can see that ...
-1
votes
0answers
21 views

Google contacts in photos recovery

.. trying to recover my contacts and my photos from this phone I lost my other phone it was an iPhone 6 s now I have this phone and it will not let me sign in to Googlej
-1
votes
0answers
6 views

Domain hoster with reverse-proxy functions? [on hold]

Hello dear Web App Users, sometimes I have a domain registered with a (random) domain hoster and want to re-write requests to this domain to a different backend. Most providers only let you do ...
2
votes
1answer
11 views

How can I turn a list of comma separated values into an array?

If I have a formula: ={1,2,3,4,5} I get a 5 column set of numbers with 1 in the first, 2 in the next and so on. However, if I have a cell that contains the string 1,2,3,4,5 in cell E2 and I try ={...
0
votes
1answer
3 views

Is there a way to organize the photos in Google photos besides creating albums manually?

I have a bunch of folders on my Android. I've selected multiple photos to backup to Google photos. However, I notice that everything gets backed up into one common folder. This is very messy. All my ...
0
votes
0answers
15 views

Google Docs Section Break Page Setup

Can page setup be performed on a section in Google Docs? I create a document, and create a section break, then click File -> Page Setup, and click "apply to this section", but literally every option ...
0
votes
1answer
9 views

How do I remove custom currencies in Google Sheets?

In Google Sheets, you can add custom currency things under the formatting tab and google sheets with keep them saved. I was playing around with this function and added a few ones to test it out but ...
0
votes
0answers
14 views

Need a Gmail filter that ignores older emails

I want to set a filter that: Sets filter for matching new emails Does not filter emails before a set date This is because I have 1000s of old emails that I don't want to filter. But seems setting "...
1
vote
1answer
11 views

Filter and display duplicates in a table

Here's the link to my Google sheet: https://docs.google.com/spreadsheets/d/1SBD0_Ca0r_p3810u1ZNlbG6MXsvhFlLcwEJndVQJRP0/edit?usp=sharing The master data will show: And I would like to have a table ...
0
votes
1answer
11 views

Email non-empty cells in tabular format

I'm trying to trigger an email to send all data on a sheet in columns B:F. I've found this tutorial quite helpful but can't quite get my head round it. /** * Sends emails with data from the current ...
1
vote
2answers
13 views

How to make sequential list of months?

I want to fill column names with a sequential list of the last day of each month. For example, 3/31/2018, 4/30/2018, 5/31/2018, etc. Is there a formula that can do this? If cell B1 = 3/31/2018, I ...
0
votes
0answers
11 views

How to escape the Google Adsense login loop

I am trying to get Google Adsense for my blog. I complete the form and click "Save and Continue" and it goes back to the homepage. I click "sign in" and it asks for my email and... surprise surprise......
0
votes
1answer
7 views

Google Form Abandonment

If someone abandons a Google Form survey before submitting, can I still see their responses up until the point where they dropped off?
-1
votes
0answers
10 views

Need a recommendation for Course videos with piracy / download protection (could involve a javascript video player or something else) [on hold]

I'm really stuck on this one and would appreciate some help! I am a video course creator and need to protect my video content (which will be embedded on my website) from being downloaded or shared on ...
-1
votes
0answers
15 views

Problem login into Gmail [duplicate]

I am a retired college professor and yet (or therefore) have not been able to log into my Gmail account for >6 months. I forgot my password and have followed all of the recommendations to make a new ...
0
votes
2answers
13 views

How do I Specify the Scientific Notation Power in Google Sheets?

In Google Sheets when I enter 10E-12 in a cell formatted for scientific notation, it automatically turns the number into 1E-11 Though technically correct, this is really annoying when comparing ...
0
votes
2answers
11 views

Cannot Find Function 'getRange' in Google Script

I'm working on setting up a series of scripts for a google sheet where I want to be able to auto sort based off of when something gets entered into the third column, sorting first by the first column (...
0
votes
1answer
9 views

Sending an email to ALL email addresses of EVERY member in a group with new CONTACTS

I used to be able to add multiple email addresses for a single contact to a group label. Now - you can just add the label to the contact and it selects just one email address to use. How do I get ...
-4
votes
0answers
10 views

what is formula for blue sky day? [on hold]

tradingview (blue sky day 90% strategy indicator) this indicator formula please tell me friend and how to work this strategy are this indicator alternative.
0
votes
0answers
7 views

Is it possible to upload folders to the Drive while maintaining folder hierarchy?

Issue: When I upload select folders to Google Drive, they're all on the same hierarchical level. For example, from "D:\folder\subfolder" and "D:\folder2", if "subfolder" and "folder2" are selected ...
0
votes
1answer
8 views

Importrange (or maybe another part of formula) behaves differently after a short time period

I am using this formula to look for data in column F related to data in column A between two spreadsheets. =ARRAYFORMULA(IFERROR(VLOOKUP(A2:A; {IMPORTRANGE("spreadsheetID";"sheet1!A4:A")\ IMPORTRANGE(...
0
votes
0answers
3 views

Apps Script to skip files that have no blank rows

I created a script to delete blank rows from many spreadsheet files. the script I created like this: function delRow(id, name, startRow, blankRow){ SpreadsheetApp.openById(id).getSheetByName(name)....
0
votes
0answers
6 views

Link to specific part in Google Doc

How can I add a link programmatically to a specific position in Google Doc? E.g. to the string "ABC XYZ" so that is automatically scrolls to that position when use clicks on it? I want to achieve ...
1
vote
1answer
12 views

ArrayFormula stops working after shuffling rows

I have a pretty extensive sheet wherein many columns I use an array formula to automatically fill data in from various other spreadsheets. The problem I have is when I need to rearrange rows then what ...
-1
votes
0answers
25 views

How can one recover a locked Facebook without asking one's friends for help?

I logged into Facebook from a different country where I am typically located: the account got locked. It seems that one can unlock the account with different ways but as shown in the example below, it ...
-1
votes
0answers
15 views

I cannot logout of Facebook

The usual logout setting is gone. Am directed to the General setting page. Have gone into Security and login to try and logout from there however there is no option to logout or end session.
0
votes
0answers
17 views

How can I keep emails received from certain email addresses out of my “promotions” tab in Gmail?

I'm OK with GMail's promotions tab keeping away most of the corporate newsletters I receive out of sight whenever I want to read my email. Sometimes, however, Gmail thinks an order confirmation ...
-1
votes
0answers
10 views

angular 8 fails going to lazy loaded modules directly after prod deploy [on hold]

I have downloaded lazy-loading-ngmodules.zip from https://angular.io/guide/lazy-loading-ngmodules. I ran the app using ng serve with no problem. I can browse url http://localhost:4200 and click on ...
1
vote
0answers
12 views

How to map a device to specific folder in Drive [on hold]

I have an ebook reader, and I have a Google Drive folder like this: work education books lectures videos ... I would like to somehow map the folder books to the device, as in everything in the ...
1
vote
1answer
11 views

How to add an outline border to a table in Google Docs?

I am trying to add only a border outline to a table in Google Docs however when trying to make all lines except the border lines another colour, this happens: As you can see, white spots where the ...
1
vote
1answer
13 views

Dynamically update cell contents by merging incoming Google Form submissions

I have a google form where multiple students will anonymously submit comments/feedback for another peer. Currently I am using the formula below to essentially concatenate all of the student comments ...
-1
votes
0answers
12 views

I changed my SIM card overseas and changed my number by mistake. Can revert back to my old number in WhatsApp?

Arriving in Ireland from US, I got a new SIM card with an Irish phone number. When prompted, I said yes to change my number in WhatsApp, but now no one from home can text me. Can I just use the ...
0
votes
2answers
24 views

Cannot find archive in Gmail even when looking in All Mail

I seem to have tried everything suggested in answers to this same question. Today, June 13th, 2019, I accidentally moved some messages into the archive, and I know I've done the same thing in the ...
0
votes
0answers
9 views

Folder Pane Spazzing out when hovering

When my mouse is over my folders and inbox pane, it starts scrolling up and down on it own and will not stop unless I move my mouse away from it. This is making selecting a folder real hard. It ...
0
votes
1answer
8 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/...
0
votes
0answers
12 views

How to keep “HH:mm:ss” as “HH:mm:ss” when archiving to new sheet

I am trying to script a function that pastes values into a new google spread sheet, one of the rows is a time in CST and in the archive sheet gets pasted as "12/30/1899" with the regular time. e.g 11:...
1
vote
1answer
23 views

Comparing two cells and adding text to matching values

I have two columns, one with all items in a set and another with the items I currently have. I would like to compare those and for the matching results to have a bit of text added if they match. So ...
0
votes
2answers
10 views

Is there a way to insert Keyboard Glyphs in Google Docs?

Here on the StackExchange framework we have a nice feature, which is apparently called "Keyboard Glyphs" (cf. https://meta.stackexchange.com/questions/5527/keyboard-glyphs): CTRL+Z Is there a way (...
-1
votes
0answers
6 views

How to Change Language of Addresses in my database? [on hold]

I have a very large customer database with an address for each customer. My postal service however, requires the addresses to be in Hebrew. Is there any sort of batch process that I could run that ...
0
votes
1answer
15 views

Assigning rank in another sheet based on Average

I have a list of names with an average beside it for every day Monday-Friday. A subgroup of names within this list will be highlighted. I want a macro to assign ranks of the highlighted individuals ...
0
votes
0answers
4 views

How Can I find only WIP ID's (Except done) from raw data in Google sheets [on hold]

I just need small formula in Google sheets and the output should be as per below highlighted bases Raw data. https://screenshot.googleplex.com/ZLoKgHKdKFy
0
votes
0answers
11 views

com/serial port on windows 10 [migrated]

I am using weighing software on windows PC where my weighing machine communicate through com port with my computer this same software was earlier installed on windows XP PC and was working perfectly ...
-1
votes
0answers
10 views

PROBLEM TO LOGIN IN MY ACCOUNT PLEASE ASSIST [on hold]

I tried a lot to confirm my pascord codes sent to my email and number but fail pay pal told sorry cant confirm if its you in deed even i put email or number den click next to receive codes but cant ...
1
vote
1answer
15 views

Dynamic Master sheet that grabs red formatted cells from another sheet

The title may be a little too ambiguous but I'll try to give a rundown as best I can; I have a Google sheet with multiple "Sheets" or Tabs (as I'd like to call them) within it. The Main tab is blank ...
0
votes
0answers
4 views

Data is not populated when website add in Google Analytics account

Here I am trying to add this website "http://www.ngi.ae/" in Google Analytics. For this first I created account and added this website then when I click on audience all figures are displayed as 0. ...
2
votes
1answer
16 views

Suggest/Recommend/Search Google Doodle featuring topics

How and where do we suggest or recommend Google Doodle featuring topics? For example, today is June 13, which is the birthday of one of the greatest physicists, James Clerk Maxwell. As far as I ...

15 30 50 per page