All Questions

0
votes
2answers
18 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
16 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
12 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
11 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
8 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
10 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
4 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
7 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
14 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
42 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
21 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
18 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
15 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
14 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
15 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
34 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
13 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
9 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
13 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
11 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
16 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
18 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 ...
0
votes
1answer
8 views

How to preserve colors of each series from changing when inserting new data in Chart Editor?

This issue occurs in every chart type. As an example, I have a pie chart created from a long table of data where each column is assigned a specific text color, so each slice of the pie corresponds to ...
0
votes
0answers
17 views

Google Sheets - pull static value from cell that will change later

I have a sheet where I calculate the average of the daily value for the past 30 days with a rolling average. I'd like to be able to pull the daily values and store them in another sheet. I want to ...
0
votes
1answer
9 views

Display the borders of more than one city in Google Maps

If I click on a city's name in Google Maps, the area of the city will be highlighted, its borders are shown in red, and the view adjusted to center on the city. Is there a way to select more than one ...
0
votes
0answers
24 views

How to know in which region a film is available?

I want to watch a specific film. It's on Netflix. However, when I try to load it with the android app, I have a message stating the film isn't available in my region. I have a good free OpenVPN list ...
1
vote
1answer
14 views

Tracking clicks on link you do not own

Is there any way to look at a random link on the internet and find out how many times it has been clicked if the link is not on my website and does not point to my website? For example, the link www....
0
votes
2answers
13 views

Sum of LAST Column in Google Sheets

I'm wondering if there's a way to sum the last Column in a sheet. I add on data every month and have to re-do multiple formulas every time I do, as they're always based on the sum of the last column. ...
0
votes
1answer
27 views

Run Android (Web) App on Windows PC?

Gmail has a new beautiful design since January. However, it looks like the rollout takes some time since it didn't arrive yet for the regular web version. So my question/idea was: can I run the (...
0
votes
1answer
9 views

Merging GSuite Accounts

I have about 10 clients that I manage gsuite accounts for. In each of these accounts I have an admin@domain.com account that I use to manage the domain. I was thinking about it today and that means I'...
1
vote
1answer
13 views

Is there a way to force Google Photos to recognize new faces?

I have "Face grouping" enabled in my Google account and I can see around 10 faces successfully tagged when I go to my Albums. However, there's a lot of other people who are not tagged, as well as some ...
2
votes
1answer
24 views

Any way to stop the “outside of your domain” notifications across Google Apps?

I use a GSuite account as my primary Google account for everything and across calendar / hangouts / etc, I see a "outside of your domain" notification for a lot of random things. Sometimes it's just a ...
1
vote
1answer
12 views

Google Sheets color row if date is closest to today's date

If possible, I would like to have a color schema applied to the table. For instance, the cell that has the closest date to today will be green The cell that has the furthest date to today will be red....
0
votes
0answers
12 views

How can I add in a date macro to a Google doc?

Really grateful for this answer from Thomas Wiersema, but am keen to find out what the issues might be if the Utilities menu isn't showing up after you've followed his instructions via Google scripts. ...
1
vote
1answer
12 views

Google Sheets Conditional Formatting Formula

I am doing a formula in conditional formatting and I need it to be relative to each of the 1500 rows but it keeps retrieving an absolute value. how do I get around putting a new formatting formula for ...
0
votes
1answer
14 views

Displays data arrays with appendrow where other columns contain data

I wrote a script to display a list of names and folder IDs. The script that I wrote like this: function listFolders() { var sheet = SpreadsheetApp.getActiveSheet(); sheet.getRange('A2:B').clear();...
0
votes
0answers
6 views

How to get a choice in a Template in Confluence server?

I tried the HTML macro. But Confluence does not remember the choice state. <select> <option>Ok</option> <optgroup label="Errors"> <option>BIOS</option> ...
0
votes
0answers
13 views

Trying to figure out a Google Script

Looking for help on a script. To pull new rows from one sheet to update my report without duplicates or erasing manually made changes to current rows. I was originally using =ARRAY_CONSTRAINT() at the ...
0
votes
0answers
7 views

How do i connect my windows account on app annie?

How do I connect my windows account to my app Annie account? Actually, when I open app annie connections they will show me ios, google play and Amazon and tell me that select one option. why I select ...
0
votes
1answer
7 views

Navigate menu with keyboard shortcuts

In the past when I opened a menu with a shortcut key (for example Alt + f) the menu itself would open. Now the shortcut keys are displayed but the menu is not opened, this makes it way harder to ...
0
votes
1answer
12 views

Can I make a shortcut of Google Sheets files in my Android phone? [on hold]

I want to make a shortcut of Google Sheets file in my phone, so I want to click that file directly not through executing the Google Sheets app. However, although I know how to make a shortcut of ...

15 30 50 per page