All Questions

Filter by
Sorted by
Tagged with
-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
580 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
625 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
264 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
459 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
477 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
147 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
123 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
441 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
23 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
670 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
130 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
558 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
92 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
336 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
339 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
200 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
72 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
79 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
372 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
332 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 ...
-1
votes
1answer
71 views

How do Facebook comment plugins in other websites know my Facebook account?

Some websites embed Facebook plugins, e.g., comment with Facebook, Facebook messenger live chat, etc. The first time I visit one of those sites, they already know my currently logged in Facebook ...
-1
votes
1answer
164 views

Return temperature data in Google Sheets for a specific time of day for each day of the month

I have a column for date and time formatted like so: [3/4/18 1:09] (verified that this is stored as date/time values), and a column for the temperature data at that time in °C like so: [11.536] There ...
-1
votes
1answer
2k views

Got logged out of account, don't remember password and don't have the email address or phone number listed [duplicate]

Can't get into my account can't remember password and don't have email account and phone # on account
-1
votes
1answer
133 views

getEditResponseUrls - hyperlinks from second linked form not inserting

I am new to scripts, but I was able to find a one that uses getEditResponseUrls to insert the edit link from a form into a Google Sheet. I've now been asked to add a second sheet to my spreadsheet ...
-1
votes
1answer
35 views

Wikipedia article's semi-protection has expired, but it is still semi-protected

I thought the semi-protection status expires automatically, but I guess this is not so. Who is responsible for enforcing that an article whose expiration date has passed for semi-protection is in ...
-1
votes
1answer
24k views

Forgot my mail id & password of my google account , how recover id & password? [duplicate]

IForgot my mail id & password of my google account , how recover id & password ? my phone was rebooted and it cant start without google account & not accept any other google account pls ...

15 30 50 per page