All Questions

Filter by
Sorted by
Tagged with
-1
votes
1answer
44 views

No option to reply to calendar invitation

I received a google calendar invite but there was no option to reply "yes, no, maybe"
-1
votes
1answer
39 views

Find the corresponding date of first cell with a number

I am trying to create a resource/capacity planner that allows me to play around with when team members are assigned to the project. I want to be able to add in a number on the days they are assigned ...
-1
votes
2answers
217 views

How accurate is GitHub traffic analytics?

It seems to me that GitHub analytics is not very accurate. I have some repositories with 1-3 visits in 14 days, and one that gets 5-20 visitors a day. Even for repositories that get little to no ...
-1
votes
1answer
308 views

How to re-calculate a Google Sheet every time a Google Forms questionnaire is submitted?

I used Google Forms to create a questionnaire, and I created a formula for Google Forms answers using Google Scripts. After that, I want to re-record the calculated result on the Google Sheet every ...
-1
votes
1answer
113 views

Facebook - Page Activity and Messenger Notifications

How do I get notifications via Messenger of activity on Pages I manage? I think I used to get them but I don't seem to be anymore. If someone posts, likes a picture, messages, etc... I should get a ...
-1
votes
1answer
201 views

Retrieve fund price from Vanguard website using importxml in Google Sheets

This was working in Google Sheets but now I get #N/A message: Imported Content is Empty A1: https://institutional.vanguard.com/web/c1/product-details/fund/1680 A2: //*[@id='dailyNavValue'] A3: ...
-1
votes
1answer
80 views

In Gmail, sending email through Fastmail's SMTP modifies From: header

In Gmail's settings, under "Accounts and Import", I added a new email address under the setting "Send mail as". This email address using my own domain, foobar@example.com let's say. I've configured ...
-1
votes
1answer
75 views

Test if value of cell is used in a formula [duplicate]

In a google sheet I have some values that are used in formulas in other cells (until now, nothing unusual...). I would like these cells to have a special color to be aware that if I modifiy them, ...
-1
votes
2answers
554 views

Conditional formatting by using the note in Google Sheets

How can I use conditional formatting by using the note on a specific or many cells in Google Sheets? For example, I would like to set up conditional formatting to a specific cell and when I use a note ...
-1
votes
1answer
623 views

Google Sheets Multiple IF statements

A1 = 2 B1 = 5 I would like to say: If "A1<B1" and "checkbox C1 is ticked" do "this sum" on a Google Spreadsheet. Everything I have tried so far is returning "N/A". Seems stupidly simple but I ...
-1
votes
1answer
47 views

How can view details of a Google Docs' document while editing it?

I want to be able to view the Folder (location) and other info (file size, etc.)
-1
votes
1answer
24 views

Can we choose to view other people's posts sorted by “latest” or “most popular” on Facebook, like on Twitter?

Facebook seems to choose to show you what it thinks are "hottest", but can you choose to view friends' and groups' posts sorted by "latest"?
-1
votes
2answers
31 views

Empty cell reference when “Loading…”

I want to do a calculation with imported data from an HTML link. The data is imported every minute. There is loading time and this ensures that the cells are empty during loading. Because my formula ...
-1
votes
1answer
51 views

How to return cell address? [duplicate]

Basically, I have this function that finds the last non-blank cell in a range while skipping columns I don't want it to search. The value is returned, but I want it to return the cell address (for ...
-1
votes
1answer
263 views

IMPORTXML error - empty table

I am trying to import a table from the lower part of the following website to Google Sheets: https://vistacapital.com.br/ I used the formula: =IMPORTXML("https://vistacapital.com.br";"//*[@id='sos-...
-1
votes
1answer
448 views

Google Sheets IMPORTHTML parse error

I want to use the IMPORTHTML function of Google Spreadsheets. There is this example by Google itself: =IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4) Unfortunately (like ...
-1
votes
1answer
50 views

Is it possible to redirect messages from a business Facebook page to my personal profile or email?

Specifically, the messages would not even appear in the page's inbox. I'm sure this is not possible but I'm just checking for some paranoid people!
-1
votes
1answer
4k views

How to delete own Telegram's group/channel?

I've created a group and a channel on Telegram, but they're no longer in use. I can leave a group/channel, but it doesn't solve my problem. How do I remove them completely? I've tried Telegram ...
-1
votes
1answer
466 views

My Facebook was disabled by mistake, how long does it take to get it back? [closed]

On November 20th I was first told you send a photo of me for security and it was being reviewed. Now on December 24th my account was disabled when I had to wait a whole month to wait so I sent a ...
-1
votes
1answer
39 views

Facebook: default news feed to just pages

Is there a way I can set my news feed to show only pages by default rather than friends' profiles? I've seen there is a way to 'prioritize' specific pages but that's not really what I'm looking for. ...
-1
votes
1answer
146 views

Im trying to make a automated script, that auto sends emails with an pdf attachment

This is my script function sendEmails() { var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 2; // First row of data to process var numRows = 8; // Number of rows to process // ...
-1
votes
1answer
1k views

What does active 4h ago mean on Facebook?

Does it only apply to messenger, or to scrolling as well? How accurate is it?
-1
votes
1answer
122 views

Google Script Editor apply to all sheets except 1st, 2nd and 3rd sheet [duplicate]

Currently this code is only applied to the sheet called "Name" I wanted applied to all except for 3 sheets (Template,Summary and Count): function EqualValue() { var ss = SpreadsheetApp....
-1
votes
1answer
25 views

Getting the highest value sequential number in excel

I have a list of values in one column. But this contains obsolete entries: PIL.7762.25.xml PIL.7762.24.xml PIL.7762.23.xml PIL.7762.22.xml PIL.7762.20.xml PIL.7762.19.xml PIL.7762.18.xml From this ...
-1
votes
1answer
438 views

Google Sheets get row number of visible row

I want to get the row number of the first visible row on one of my sheets. So for example if rows 1 - 499 were hidden then I want to write a formula that returns the numerical value 500. I know this ...
-1
votes
1answer
22 views

How to navigate to a specific sheet in Google Sheets based upon a cell value

What I am hoping to do is take the =Now() date that is located on my default sheet and in the Row 1 Column 1 cell and somehow when the sheet is accessed onOpen() have it automatically change the ...
-1
votes
1answer
24 views

Indexing in Google Sheets

I wanted to find a way to add a string into the middle of emails in Google sheets. For example: We have 5 rows: bus@email.com car@email.com truck@email.com train@email.com plane@email.com I ...
-1
votes
1answer
665 views

Avoiding an authorization request for Google Scripts

I'm in the midst of trying to custom code some script that will automatically hide some sheets from some users in a shared company spreadsheet. Yesterday it seemed to be working fine, but now it seems ...
-1
votes
1answer
128 views

Setting ImportRange on a delay

Is it possible to set a timer or delay for the importrange function on Google Sheets?
-1
votes
1answer
1k 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"
-1
votes
1answer
14 views

DAY function does not work as expected in google sheet

I have a issue with Day function; I am extracting date from text string and storing it in a column; say Sep 30, or Sep 23; I want to see DAY of this date and put it in next column; something like ...
-1
votes
1answer
34 views

Return the column header of the last >0 value in a row

I need help with a Google Sheets formula to return the column header of the last >0 value in a row (the yellow highlighted cells below are hard-keyed). Example:
-1
votes
1answer
556 views

Unprotect ranges [duplicate]

I am trying to create a script to protect my formulas in sheets that co-workers will use. I have 10 workbooks with 26 sheets each, all are virtually identical as far as the the locations of the ...
-1
votes
1answer
91 views

Swapped product listings on Amazon

I'm seeing more and more occurrences on Amazon of the following phenomenon: a product with good ratings (usually 4/5+) has reviews that refer to a different product. (Sometimes this happens for brands ...
-1
votes
1answer
324 views

Gmail 'All Mail' only showing 10 days of mail

Yesterday I went into the 'All Mail' folder in Gmail and I noticed that the mail listed only went back 10 days. I try to follow the "Inbox Zero" approach to mail management and archive all the mail ...
-1
votes
1answer
334 views

How to find the closest date to today from a list of dates

I have a list of dates on column A. Each day I need to automatically put the date of today or the next closest date on cell B1. 20/8/2018 6/9/2018 25/9/2018 28/9/2018 11/10/2018 30/10/2018 31/10/2018 ...
-1
votes
2answers
223 views

Using SUMIF to add amounts over a given number

I am trying to calculate the total number of overtime hours worked by staff each week. I have a formula that seems to do the job OK, but I feel there could be a better or more concise way to write it....
-1
votes
1answer
47 views

Can you set a cell to have a price on it linked to the main website?

I work in the parts department of an auto-repair shop and have been charged with organizing everything and creating an inventory sheet. I have done all of that and am now trying to improve the system ...
-1
votes
1answer
199 views

Having syntax trouble with IMPORTXML Google Sheets function

I have been studying the various IMPORTXML examples posted however I have not been able to solve for the actual data I wish to pull in to my sheet. The page is here: https://aemo.com.au/Electricity/...
-1
votes
1answer
1k 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 ...
-1
votes
1answer
24 views

Lookup using multi criteria

If anyone can help with this: sheeet2 has the data sheet4 is how I want to see the data. Need to search by column A and row 1 to get the value in sheet2 column E Sample spreadsheet
-1
votes
1answer
19 views

How to force Gmail to refresh after un/starring a message?

I have set my Inbox type to be "Starred first". When I un/star a message I expect it to go immediately up (to Starred) or down (to Everything else). Now I need to refresh the Inbox in order for ...
-1
votes
1answer
47 views

One time check to see if document is shared with a specific user

I'm trying to figure out how to write an Apps Script that checks "IF" a Google Drive URL is shared with a specific user. I do not want this to be a continuous check, just a "one time check". Example ...
-1
votes
1answer
27 views

Google Sheets Column Wrap

I have 3 columns of data but I don't want them to carry on down the page. I want the columns to fill the page (3 rows of 3 columns) and then carry on to the next page. Is this possible? Added image ...
-1
votes
1answer
71 views

If I change the privacy of a photo on Facebook from “Only Me” to “Friends”, will my friends get notified about it?

If I change the privacy of a photo on Facebook from "Only Me" to "Friends", will my friends get notified about it? What can I do if I don't want them to be notified?
-1
votes
1answer
366 views

Google Groups Invitation Error

I have received an invitation to a Google Group by my boss (who is a manager of the Google Group) to my work email. I have created a Google account using the work email address and am receiving the ...
-1
votes
1answer
76 views

Google Search results vs. full page of spam links

I've searched for ext:PDF (filetype version) of a probably popular = commercial successful book and got full page (maybe more) of spam links - it's more than 100! How to deal with a full page of spam ...
-1
votes
1answer
366 views

YouTube enable old layout

I am not happy with the new YouTube layout: it is very slow to load compared to the old version. Can I switch back to the old version somehow?
-1
votes
2answers
30 views

Separating out posts from friends, groups, and pages on Facebook

Is there a way to setup Facebook so that in my default stream I only see posts from my friends? I get so many things popping up from pages and organizations that I've liked as well as posts to groups ...
-1
votes
1answer
330 views

Dynamic VLOOKUP + COLUMN + IMPORTRANGE

I need to keep updated a COLUMN number into VLOOKUP formula with IMPORTRANGE. =vlookup(B5;IMPORTRANGE(url;"RIASSUNTIVO!B:CC"); column(IMPORTRANGE(url;"RIASSUNTIVO!C1:C10"));FALSE) The COLUMN ...

15 30 50 per page