All Questions

6,910 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
3k views

In Google sheets, how to calculate elapsed duration between two cells, each containing date and time and display as days and hours

There is a built-in duration format, but Elapsed days is not an option. I want to display "2 days, 3 hours"
0
votes
2answers
54 views

Suming values in a column if value in cell next to it matches another cell

I'm trying to create a sheet to maintain a small inventory of servers. I created a segment where each type of component will be listed at the top. Below it is a series of copy-pasted chunks which ...
0
votes
0answers
15 views

Everyone in my organization call see *all* of my Google Sheets (spreadsheet) documents. How do I prevent default access from within my organization?

A few minutes ago, I hopped on a co-workers computer who was working with Excel for inventory tracking, trying to get her to use Google Sheets instead. After logging her in, I was (very) surprised to ...
0
votes
1answer
1k views

Facebook declined friend request wanted back

I accidentally hit the remove button on a friend’s request to Facebook and now he cannot add me again and I cannot even bring him up at all. What did I do? What can I do?
0
votes
1answer
5k views

Google Sheets macro for printing

I wrote the next macro, but isn't working. For example: I have a button on the sheet (invoerblad) for printing, the button must print the sheet (Printblad), and when the print action is finished, it ...
0
votes
1answer
94 views

Fine tuning a find and replace code

I have this code that works to find the word “Yes” and replace it with a 1. How do I also add in a line for it to find “No” and replace it with a 0? function fandr() { var ss=SpreadsheetApp....
0
votes
1answer
3k views

How to prevent duplicate entry in google sheets per row

So using the example data below, how can I prevent a duplicate entry with an informative message. The duplicate entry should be based on the row and not the whole sheet. So, if I was to add a second ...
0
votes
0answers
165 views

Search tweets and filter by maximum number of replies

I'm searching popular recent tweets with some keywords and I want to filter out the noisy ones (those with a lot of drama). Matching tweets with a lot of replies or by verified users tend to be ...
0
votes
1answer
35 views

How can you share a CRM-like phone book with Google Contacts?

We'd like to share contacts stored in Google Contacts with the entire company. We have 1,000+ client records and phone numbers that we'd like everyone in the company to have access to. We've been ...
0
votes
1answer
1k views

Archived emails still taking up space in Outlook

I am having some problem with the archive option in Outlook. My mailbox is almost full and I am archiving all the emails which are one year old. But, archiving is also taking up space. Do you know ...
0
votes
1answer
68 views

Need to trigger form submit when data is already populated in Google Sheet from another source

We have tried many thing to do a job basically we have a Google Sheet to collect information from Google Form once the form is submitted the data get inserted into the sheet and document studio start ...
0
votes
1answer
1k views

How to create alias addresses in Gmail without registering a new email address for each one?

It appears I need to actually register new email address in Gmail, and then I can service them all from one Gmail login by adding them in Settings. Is there a quicker/simpler way? I do NOT mean ...
0
votes
1answer
68 views

Count unique tags

I’m trying to list and count all tags in my table. For some reason, anything after comma, is getting a white space before the word. So if the tag is found on the beginning of a record, it is seen as ...
0
votes
2answers
81 views

Duplicating sheets with simple date from a named range

When I run the script to duplicate sheets with a date is give the tab a long date name Thu Oct 18 2018 00:00:00 GMT-0400 (EDT). I would like it to read in a 10/18/18 format.
0
votes
1answer
1k views

Google Sheets intersection query

I'm trying to write an intersection query in Google Sheets that lists all the rows in sheet 1 that contain a cell in sheet 1, column A, that matches at least one cell in sheet 2, column P This is the ...
0
votes
0answers
133 views

Stop Gmail notifications for specific senders

I'm using Gmail in a Chrome tab on Windows 10, and it's set up to produce notifications for new emails. There are some senders for which I'd like to not get notifications for. There is a trick based ...
0
votes
1answer
2k views

See my post's new likes (or see likes in chronological order)

Day 1 morning: I post something on my personal Facebook wall. Day 1 evening: 200 likes, I check them quickly because I am interested in seeing who among my friends have liked my post. Day 2 morning: ...
0
votes
1answer
83 views

Formula for adding sum total from multiple sheets for a specific name

I am stuck in terms of how to set a formula to get the sum total for a specific "name" from multiple sheets.
0
votes
1answer
75 views

How to calculate hours per date

I am trying to use A Google Sheet generated by Google Forms to track total attendance time in lab for a robotics team. I have created a form with the following questions: Checking in or Checking out ...
0
votes
1answer
1k views

How can I change task color in Google Calendar?

I have google calendar with google tasks enabled. I want to change color of some tasks. For example most important tasks will have red color and all others tasks will have blue color. So how can ...
0
votes
2answers
651 views

Is it possible to contact Facebook asking them to recover an account?

If someone can't recover his Facebook account by any mean. Is it possible to send his ID to Facebook and ask them to recover his account? Because earlier this year I filled a form asking Facebook to ...
0
votes
0answers
44 views

Gmail claims that link pointing to my blog leads to a not trusted website. What can I do?

Starting today I started to see in Gmail following message: each time I click on approve / trash / spam links generated by Wordpress as a response to a new comment appearing in one of my blogs. This ...
0
votes
1answer
241 views

Customize priority inbox in new Gmail design

For the last few years I've been using this method to customize my priority inboxes the way I like. However, with the new Gmail redesign this no longer works. Does anyone know a way to get this to ...
0
votes
2answers
77 views

How to find Facebook users who followed someone?

Is there any method to find users who followed someone's account on Facebook?
0
votes
1answer
3k views

How do I wrap/unwrap text in a table in Google Docs?

Apologies but this is driving me crazy I just want to unwrap the text in this cell so that it is on one line. How is this done in Google Docs? I don't see the button for it
0
votes
0answers
25 views

How does IFTTT know when an external event has happened?

I want to put together a simple tool to sync some documents with GitHub issues. I can do this using APIs on a timer say hourly. I notice IFTTT has GitHub support like "when a new issue is raised..." ...
0
votes
1answer
547 views

Duplicate values in dynamic sorting

I have an issue with duplicate sorting values for a formula in Google Sheets. I'm using two tables to order 10 scores (see pic). The values in Column D are dragged from another sheet. The values in ...
0
votes
1answer
506 views

QUERY remove column and column header if blank

The attached document is a time-sheet document. There are 2 tabs, TimesheetData and InvoiceData. I want to pull through data from TimesheetData tab to the InvoiceData tab using a query. The query I ...
0
votes
1answer
336 views

outlook web: how to mark search results as read

I just came back from vacation, and I have a few thousand messages to go through. Is there a way for me to run a search in Outlook Web, and then say "mark all these results as read"? If I click on ...
0
votes
1answer
44 views

How do you delete certain cells before copying?

I want to copy IDs and dates and have written this script so far. function copy(){ var s1=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); var s2=SpreadsheetApp....
0
votes
1answer
894 views

How to create a 3 column chart in Google Sheets with one numerical column and two text columns with customization?

Consider this data: +---------+----------+-----------+--+--+ | Food | Quantity | Type | | | +---------+----------+-----------+--+--+ | Apple | 3 | Fruit | | | +---------+-----...
0
votes
1answer
630 views

How can I make a hyperlink from Google Spreadsheet cell to an Excel file?

How can I make a hyperlink from Google Spreadsheet cell to an Excel file? For example the hyperlink is in Google Spreadsheet and opens the Excel file. The Excel file is on the hard disk not on Google ...
0
votes
0answers
623 views

Excel spreadsheet hyperlinks change when uploaded to Google Drive

I've produced an Excel table with hyperlinks in cells from sheets to other sheets. I can't share the Excel document because its confidential but the anomalies are very unusual. One cell contains [11] ...
0
votes
1answer
491 views

How to extract a link URL from one word within a paragraph element in Google Docs with Google Apps Script

I'm trying to pull the URL of a hyperlinked word from within a paragraph element in a Google Document using Google Apps Script. Below are two GAS functions. The 1st doesn't work. The hyperlink is only ...
0
votes
0answers
56 views

Is there a way to just pull out all of a certain index without going through the results and rebuilding a 2nd temp array?

I've got multiple sheets with anywhere from 500 - 10,000 rows each that I need to find specific values in a given column. Ex. Sheet A, B, C have information about a bunch of products. I search for ...
0
votes
1answer
813 views

Date Query in Google Sheets with importrange

I have two tables. Table A= Customer Feedback Table B= KPI In Table A I have a column for a date with format mm/dd/yyyy and in Table B I have 2 columns as from date and to date with the format. I ...
0
votes
1answer
55 views

Gmail conversation replies displayed in mailbox

Is it possible to display all the replies in an email thread in the mailbox, such as how Outlook does it:
0
votes
2answers
2k views

How to move OneNote files from OneDrive to Google Drive?

I have around 20 OneNote files which are my personal reference. It contains almost 10 years of data. I recently got the unlimited space in Google Drive. Now I would like to move all my OneDrive to ...
0
votes
1answer
217 views

How to keep Gmail alias account settings separate?

The company I work for gives us Gmail addresses which are company managed. For a project I am doing, I have to work with an alias address. It wasn't my choice for it to be an alias, rather than a ...
0
votes
2answers
866 views

Searching for a name when missing some chars of it

I was wondering if there existed a way to search for the name of somebody when some letters of its name were missing. For instance, let's say we know the profession of somebody but only have the first ...
0
votes
2answers
537 views

Google Sheets checkboxes not rendered correctly on mobile

I am using columns of checkboxes on some Google sheets that I have shared for read-only access. On a mobile device, the users see TRUE or FALSE in the columns instead of the boxes. On a PC it looks ...
0
votes
0answers
237 views

Google maps aerial view

Is it possiblet to access google maps aerial view? I know that pictures and functionality are still there somewhere. When accessing from desktop via browser google maps now offer two views: map and ...
0
votes
1answer
268 views

Fetch Random String From Array For Each New Form Entry

!Sheet1 is populated with entries coming from a Google form !Sheet2 has an array of 12 employee names in array A2:A13 How can I automatically populate the cell on the right column of every new line ...
0
votes
1answer
914 views

Draw.io: How to move selected arrow object

For any object, after I select it, I can move it by dragging with the mouse click. However this is not working for a simple straight arrow object. When I try to move it, the waypoints are getting ...
0
votes
1answer
412 views

Formula for custom number format in Google Sheets (e.g. 5M --> 5,000,000; 50k --> 50,000; etc)

I've been trying to figure this out for a bit but everything I've tried doesn't work. A quick search brought me to the conversion from full number format to condensed format (5,000,000 --> 5M; 50,000 -...
0
votes
1answer
873 views

How to not count cell if cell contains sub-string

I have the following formula to count cells within a range B10:B1095 which do not contain certain strings =COUNTIFS( B10:B1095, "<>", B10:B1095, "<>Manual", B10:B1095, "<>TODO"...
0
votes
1answer
883 views

Adding link / image to Trello card

I am new to Trello, and I am really wanting a way to add a link to a webpage, but instead of renaming it, would like to use an image that you could click to go to that web page. This is not for a ...
0
votes
1answer
2k views

Gmail doesn't show entire message

I have a large email message, and whether I am on Desktop/Laptop or Android app, clicking the Show Entire Message link only opens a new tab which either prompts me to sign-in to Gmail or takes me back ...
0
votes
1answer
34 views

How do Amazon AWS websites determine localization?

After short trip to Russia all websites insist on showing me Russian versions in Chrome. IE, I open the following in Chrome Incognito window https://aws.amazon.com/ec2/spot/pricing/ And I'm ...
0
votes
1answer
2k views

How To Delete a Private Channel

I created a slack work space for my team. I just recently managed the channel permissions. I found out that my team members created a private channel that I can't see. How can I delete it without them ...

15 30 50 per page
1
118 119
120
121 122
139