All Questions

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
17 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
42 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
24 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
10 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? [closed]

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 [closed]

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
12 views

PROBLEM TO LOGIN IN MY ACCOUNT PLEASE ASSIST [closed]

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
22 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
9 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
10 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
14 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
32 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
13 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
2answers
17 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
27 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
15 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
14 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? [closed]

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 ...
0
votes
1answer
27 views

How do I activate monetization on my YouTube channel?

I want to make money on youtube, and I heard that you have to enable it but didn't know how to. So I searched up "how to make money on youtube", and it brought up this tutorial guide: https://...
0
votes
1answer
8 views

Script to copy range transposed to another sheet

I need to copy a range from the sheet 'Source' to the sheet 'Database' but transposed. It should be the range B1:T9, not the whole sheet. I need to do it with a script as it is going to be a database ...
-2
votes
0answers
55 views
0
votes
1answer
18 views

Why does Google Docs make some H1 headings bold in the Table of Contents and some not bold?

In my Google docs document I have added a Table of Contents. It's the kind with page numbers. In the Table of Contents, some of the Heading 1 (top-level) headings are bold, and some are not bold. Why? ...
0
votes
1answer
18 views

Generate Google sheet with selection from other sheet

I want to make a list of vegetarians in Document 2 from information in Document 1. Document 1 Columns A and B. Bill Meat Jane Veg Tony Meat Sarah Veg I want Document 2 to search ...
0
votes
0answers
10 views

How Syncing affects multiple Gmail accounts

I have multiple Gmail accounts and recently added a GSuite account for a non-profit with which I'm working. I'd like my bookmarks/folders to appear the same on both laptop and desktop computers for ...
1
vote
1answer
11 views

If a cell equals to this date, then filter through another sheet and grab that cell that has the same date

When you input a date in sheet 1, I want it to automatically grab data from sheet 2 and input text that matches that date back into sheet 1
0
votes
0answers
10 views

If I score lower when retaking an aptitude test on fiverr.com, does it display that way on my profile?

In fiverr.com (for sellers, at least), there is a "Take a test" option on my profile where I can take aptitude tests for various skills. The test results are displayed on my profile. I'm allowed to ...
0
votes
1answer
23 views

How do I share a private video with 170 people

Hi I have a relatively big group (about 170 people), and we want to share videos only within this group (i.e. we do not want people outside of this 170 people group to access these videos). Now here ...
0
votes
0answers
6 views

Is there any way to add sanskrit99 font to googledocs [duplicate]

I would like to copy the contents of pdf which is using Sanskrit99 font to google docs. Any idea please on how to achieve that, thanks for your help.
0
votes
0answers
48 views

Can my employer access my device's hardware info or control it in any manner even after I unregister? (On the Google apps/ business platform)

I added a new Google account on my device and signed in with my work account. It said that my device info like IMEI number, Mac address etc will be shared and the admins will also be able to control ...
0
votes
0answers
26 views

Facebook Leads to Salesforce through Zapier. Is it possible to specify a lead queue as the owner ID?

Zapier doesn't show lead queues in the dropdown box. I have tried using a custom value for the owner ID... which I got from the url address in salesforce when I click a lead queue e.g. 00B1400....., ...
0
votes
0answers
6 views

Why are there reviews for different types of products on Amazon than the product page they are displayed on?

Why are there reviews for a 'tumbler' on a kitchen thermometer item page? https://smile.amazon.com/FoodOMeter-Cook-Thermometer-Backlight-Calibration-Thermometer/dp/B07NV7FXY4/#customerReviews This ...
-1
votes
0answers
7 views

Node Package Manager (NPM) website how do I favorite a package

Is there a way to favorite a package on npm.js either through the web or command line interface? I want to save a list of packages that I really like, so that they are easy to remember.
0
votes
1answer
18 views

Google Sheets Cell Reference +1

I am wanting to enter a bunch of cell references that are affected by a change in only one of them. On one sheet tab, I have a list of dates in column C, and dollar figures in both D and E. In another ...

15 30 50 per page