2
votes
0answers
11 views

Avoid redundancy in formula in Google Sheet [duplicate]

Say I have a long expression (i.e. with a lot of characters) expr. I want to give a cell the formula =if(expr>10,expr,0) (this is an example, the condition could also be =if(iserror(expr),expr,0)). ...
2
votes
0answers
158 views

Google logins from unknown device/location

A few months ago, I forgot to log out of my google/gmail account from a "friend's" Samsung Galaxy Tablet. I noticed shortly after that, there was a login to my account from a device..a Samsung Galaxy ...
2
votes
0answers
47 views

Google Sheets <copy Data from one spreadsheet to another>

Could you help me to understand how to made next couple: Table M Table 1 Name -> Name Qty <- Qty Table M has original field Name, Table 1 takes this name and ...
2
votes
0answers
12 views

Is it possible to import cell data AND cell format from one Google sheet to another? [duplicate]

I'm trying to import data "and" formatting from one sheet to another. I'm using =importrange("docID", "sheetName!A1:A30") to get the data, but it doesn't get the format. Suggestions?
2
votes
0answers
82 views

How can i reduce the CPU usage of Google's Inbox

Even with all my extensions disabled Google Inbox takes 2-5% constantly and 20-40% in spikes every so often. This is also without the tab having focus. Currently I just open Inbox when i need it and ...
2
votes
0answers
35 views

In Google Sheets is it possible to print to a custom paper size?

I have a spreadsheet that I'd like to print on a single 8.5" x 22" sheet of paper. This is not a standard paper size, but my printer can print on it. The Google Sheets print settings dialog only ...
2
votes
0answers
52 views

Notify Trello action to different Slack channels

I enabled the Trello integration in Slack and I was able to create notifications that goes in a newly created #trello channel in Slack. But this channel receives the notification of actions performed ...
2
votes
0answers
51 views

Gmail autosuggests contact's Google+ name, not manually entered name/nickname

A professional contact I know has a Google+ profile which must be for personal use. The name listed must be one he uses non-professionally. However, he goes by a different name professionally (it's ...
2
votes
0answers
14 views

Search in the books of one's own library

In Google Books, we can search for some keywords among the books. In Google Books and Google Play, we can add books into our libraries. Can we search within the books in our libraries?
2
votes
0answers
62 views

Edit existing shape in draw.io

Is it possible to edit an existing shape in draw.io? I'd like to use "Group" shape (mockup containers > group). However, the blue group heading is too narrow to write any longer word. I need to ...
2
votes
0answers
35 views

Disable Gmail “muting” feature to prevent accidental muting

Is there a way to disable muting in Gmail altogether? I recently muted a conversation by accident and thus didn't see replies to it, so I went back and found others via https://mail.google.com/mail/u/...
2
votes
0answers
26 views

How can I get an alert when a specific post appears in Facebook?

When The Hungarian Opera House has a new promo, a post appears on its page https://www.facebook.com/Operahaz/?ref=ts&fref=ts and the first 10-50 people who click and answer a simple question get ...
2
votes
0answers
16 views

Is there a way to get Google Search to give you definitions for words in languages other than English?

If I google perspicacious, Google Search correctly infers that I want a definition and just includes it at the top of the results. For more common words, like vanish, I would have to write define ...
2
votes
0answers
22 views

How to mark as done but keep resnooze until particular date in Inbox by Gmail?

Steps to reproduce the above example screenshot: Snooze a conversation This will make the conversation disappear from your inbox Let us assume the other person responds to this conversation while it ...
2
votes
0answers
34 views

How can I upload my animated GIFs to Facebook (in 2015) [duplicate]

According to this Mashable article, Facebook only recently started supporting GIF support. From the article, here's how it works: "you need to paste a GIF file link into the "status update" screen" ...
2
votes
1answer
19 views

Filtering all matching locations in Google Maps

I am looking for a way to list all the physical in-range locations of companies which meet a particular criteria in Google Maps. For example, when I input "supermarket" into Google Maps I find out ...
2
votes
0answers
29 views

Making Google Docs into its own application on Mac

I've been trying to figure this out all afternoon... My dream is that I want to be able to open Google Docs on my Mac as if it's an application. Chrome's setting's has a built-in "Add to ...
2
votes
0answers
31 views

How to blur a section in a video that is already uploaded? [duplicate]

I realized I opened a Chrome tab that I don't want shown in the video. The video already had 500 views and thumbs up, etc. I don't want to take it down just to re-upload it. Is there a way using ...
2
votes
0answers
16 views

Creating exceptions in Cognito Forms

How do I create exceptions for more than one field to show up? I.e.: I own a dog kennel, and if someone is bringing 3 dogs I want them to click (3) in the "How many dogs will be staying with us?" ...
2
votes
0answers
24 views

How to keep relative links in GitHub subproject consistent in npmjs.org interface

The code of the npm package I'm developing belongs to a bigger repo, which contains a lot of different stuff. There's a README.md file with relative links to the documentation contained in the same ...
2
votes
2answers
251 views

“Incorrect range height” error in Google script when using setValues

I am trying to convert calendar dates to fiscal dates. I've been successfully able to do all that. My problem is trying to write the fiscal date values back into the spreadsheet. Here is the code: ...
2
votes
0answers
20 views

How to “Send as attachment” as default in Inbox by Gmail?

I would like to send images as attachment by default in Inbox by Gmail. Is it possible to define this as a default setting?
2
votes
0answers
76 views

Google Sheets - Dynamic Filter View by URI

I am using Google Forms to acquire "per-X" feedback, and want to dynamically produce customised reports that are filtered based on the URI. What I am looking to achieve is a unique URI per X that ...
2
votes
0answers
14 views

Splitting Multiple Multi Line Cells into new rows [duplicate]

I am working on employee data and the data I have received comes with two cells (Proj Name and Count of Hours) which have multiple names/ hours in the same cell separated by line breaks. I have ...
2
votes
0answers
14 views

Fields drop-down contain “$75” data in Cognito Forms

I have created various forms. One of the forms I created contains a $75 pricing for orders. Now, somehow all of my other forms drop-down menu fields have this data inserted. How can I rectify this ...
2
votes
0answers
48 views

Facebook notification exploit?

I recently got a notification for being tagged in a comment on facebook by a friend (on the actual facebook UI - I have not seen any emails pertaining to this). The notification seemed, and probably ...
2
votes
0answers
47 views

Swedish keyboard shortcut for Search field in Google Drive

The keyboard shortcut that takes you to the Search field on the Google Drive main view does not work on a Swedish keyboard. On an English keyboard the shortcut is / but pressing Shift+7 on a Swedish ...
2
votes
0answers
42 views

Is there a way to download all the Revision History of a Google Doc?

Is there a way to download all my Revision History as .doc documents from Google Docs (.xls from Google Sheets and PPT maybe from Slides)?
2
votes
0answers
33 views

Can I add custom connectors on Google Drawings shapes?

Google Drawings has handy connector points on most shapes. But sometimes there aren't connectors where I want, and complex drawings become really hard to work with as I'm resizing and moving things ...
2
votes
0answers
80 views

Google Form from Facebook Group

I have a a google form that I would like to only make available to members of a closed facebook group. The form is anonymous and members are free to use it as often as they would like. The problem is ...
2
votes
0answers
172 views

Is there a way to return to satellite birds-eye view with latest Google maps?

Using Google Maps with latest Chrome/Win10, two questions: How do I get to overhead satellite photo views? Currently I just have 'Earth' and 'Map'. How do I get to 'birds-eye' satellite photos ...
2
votes
0answers
1k views

Name changes to bold in messenger chat window

What does it mean when a name turn to bold in a chat window? Even though there is no conversation.
2
votes
1answer
67 views

How to delete a pulse post in Linkedin?

I have written an article on LinkedIn. I do know how to update (and publish) it however, I'm not able to find a way to delete it. Does anyone know the work around?
2
votes
0answers
33 views

Import site URLs to Google Sheet (and add new row each time)

I am trying to make a list of site pages that will automatically update in Google Sheets, while keeping the full history rather than overwriting older rows with new ones. I see two possible ways of ...
2
votes
0answers
87 views

Shortcut For Right-To-Left In Microsoft's Word Online?

As a Hebrew Mac user, I'm used to Office For Mac without RTL support. But it turns out Word Online has this button: As a translator, I need to use it aplenty - what shortcut do I use for it?
2
votes
1answer
347 views

Tumblr glitch with ask page CAPTCHA

I've been trying to find out details on how to fix this with Tumblr: I'm trying to allow anonymous people to send me messages. However, when people try to send me something they need to fill a ...
2
votes
0answers
32 views

Need to move a copy on Google Drive to new folder without leaving copy behind in original folder

When I make a copy of a document in a shared folder and then move the copy to another shared folder, the copy shows up in the new folder but also stays behind in the original folder. When I delete the ...
2
votes
1answer
114 views

Formula to use in Google sheets to count all cells containing specific texts

Here is a link to a sample spreadsheet: https://docs.google.com/spreadsheets/d/1LcfqPxsnQGEVZKd2imM1WPYRvgbZBiEQ18mHVd3znjE/edit?usp=sharing What I want to do is count all unique values in column C (...
2
votes
0answers
36 views

Adding an embedded HTML5 YouTube video to my “likes”

I am slightly annoyed that the only way that I can bookmark an embedded HTML5 YouTube video is by pressing the "watch later" clock (🕓) on top right. I believe this has changed with the HTML5 player, ...
2
votes
0answers
564 views

Can’t change my name in Google Accounts

When I go to my main Google account to update my name (which I've never done since I set it up) it is not changeable. The comment below my last name says This setting can't be changed for your ...
2
votes
1answer
72 views

Delete messages from a group chat

A member of a group chat in FB messenger has deactivated his profile for a while. Will he be able to see the messages in the chat exchanged while his profile was inactive if I delete those messages?
2
votes
0answers
70 views

Google Maps Service Area Business - How many areas can I add?

I am adding our business to Google Maps, and since we're a web shop I am selecting that "I deliver goods and services to customers within this area: Now, there are two options. One is to set a radius ...
2
votes
0answers
15 views

YouTube Auto Caption Option Missing

I used to be able to upload a video to YouTube and let it auto caption for me. Now, it seems that this feature is no longer available as of about a week ago. I can't find anything on this. Does ...
2
votes
0answers
22 views

Google drive is creating duplicates on the cloud

We are a company of about 43 users, spread all over the country and we not only get duplicates on our local drive, but on the Google drive itself. So a directory might contain a few hundred files that ...
2
votes
0answers
103 views

How to comment on YouTube without your name, but send from Gmail with your name?

I have a friend whose Gmail account name is a fairly cryptic series of letters, and who filled out equally cryptic strings when Google asked for his first and last name, so that emails come from ...
2
votes
0answers
161 views

How to display a date range on Google maps timeline

On the new Google timeline I can only seem to select a single day or month or year. https://www.google.com/maps/timeline On the previous version, I could choose a date range. Any ideas how to do ...
2
votes
0answers
80 views

Force Google Maps to display my location with correct zoom

Whenever I open Google Maps (by typing maps.google.com URL) in Opera, I always see map of Central Europe, not my location. How can I force GM to display my location? The "Give Maps permission to use ...
2
votes
1answer
203 views

Dropdown list based on the result of another cell's dropdown

I want to populate a dropdown list based on a selection of another cell's dropdown list. Here is my spreadsheet. E.g., if user does not make a choice from D20 dropdown menu, therefore F20 dropdown is ...
2
votes
1answer
65 views

simple page host on github.io returns 404

My GitHub URL is https://github.com/qiaoba, and https://github.com/qiaoba/qiaoba.github.io is the repository on my master branch. But I get a 404 page returned when I'm trying to visit qiaoba.github....
2
votes
0answers
41 views

Additional details in address field of Google Contacts to be ignored by Google Maps

I need to have additional details in the address fields of my Google Contacts. These additional details interfere with Google Maps finding the address. For instance: Street Street Name 24, etaj 2, ...

15 30 50 per page