All Questions

Filter by
Sorted by
Tagged with
2
votes
1answer
32 views

Unable to send emails

I am getting the following error message when attempting to send emails: Error The address "essentialphysicaltherapy.net" in the "To" field was not recognized. Please make sure that all ...
0
votes
0answers
4 views

Concat text from one column with text in non-empty cells in range

I need a formula to concatenate the text from column A with each non-empty cell in B1:Z. The number of rows in the input data will change, so that has to be accounted for dynamically. Also, the rows ...
0
votes
2answers
102 views

Expand folders in Google Drive

In Google Drive's folder pane, how do you expand a folder together with all of its subfolders at the same time? In other words, I'm looking for the Google Dive equivalent of macOS's option + right ...
0
votes
0answers
4 views

Google Sheet hide emtpy cells

So I have a simple formula I use for my tabletop game. I have Player names in A2-A26 and their turn number in B2-B26 In E2 I have the formula =Sort(A2:B26,B2:B26,False) Now this makes a list of ...
1
vote
1answer
200 views

Google Finance Historical Data with Multiple Attributes?

=GOOGLEFINANCE("NSE:"&A2, "all",(TODAY()-($N$2)),TODAY(),"DAILY") The above code returns OHLC data for specified days with the date column. What I want are only high, low and close columns. =...
0
votes
0answers
3 views

How to retrieve Google lost account

My phone was stolen for2 3 months ago and now I've forgot my google play games password n g mail
0
votes
1answer
114 views

Show insignificant zero

I want, when I write a Number in a Cell, that the zeros are still visible. In a Google sheet. e.g. when I write 1.050, or 1.0 or 1.2000 there should stay exactly that. Not 1.05; 1; 1.2 or something ...
13
votes
3answers
7k views

Is it possible to attach a label to a line in the Google Drawings app?

Is there a way to attach a label to a line (straight or curved) in a Google drawing, so if the line is moved to a different location the label automatically goes with it? I can place a textbox next ...
3
votes
1answer
30 views

Is it possible to add a new Lane or do I need a separate Board

We have a bunch of DevOps tasks on our Board. We'd like to add Marketing tasks, but not mix them in with DevOps as that would confuse our management of capacity. Our desire is a separate "lane" of ...
10
votes
2answers
49k views

Calculating shaded cells

I am using Google Spreadsheets to create a matrix (time/activity) as a daily schedule for staff to sign into. Is there a formula to calculate the number of cells in a column that are shaded (or not ...
0
votes
1answer
15 views

Spreadsheets: How do I only select non-empty cells in function?

I use this function to find a random content of a cell: =index(A3:A100, randbetween(1, counta(A3:A100) ) ) Some of the cells in A are empty. How can I change this function so that only those cells ...
2
votes
1answer
236 views

Forward Telegram messages to e-mail instantly

I am now using google to find a way to forward telegram messages from a group or channel to an email address?! I haven't found one solution. Does anyone in here know if that is possible? I am looking ...
1
vote
0answers
3 views

Google Sheets - How to reduce number of X axis labels?

I have a chart with dates along the X axis, but the chart displays them quite close together, producing a rather ugly graph. How might I reduce the number of visible labels to increase the readability ...
2
votes
3answers
3k views

How can I transfer Google contacts with photos to another account?

When I export my contacts from Google Contacts (contacts.google.com), none of my contact's photos are included. Additionally, when I attempt to import a VCF file containing photos, the web interface ...
0
votes
1answer
80 views

How to correctly show contact names in Gmail

Most of my contacts are businesses, I was able to find the field "Archive as" in my Google Contacts which helped in organizing them. However when entering a contact in Gmail, it still shows the ...
1
vote
1answer
14 views

Trello checklists

I have topics as my lists, i.e - PR, Marketing, Comms Projects are listed as cards under each heading and in turn each card has a checklist. I'd like to turn checklist items into cards on a Daily ...
0
votes
0answers
9 views

Sheets-select range of cells relative to current cell

I am trying to calculate the sum of a range of cells relative to the current cell. This is what I have, and it works: =SUM(INDIRECT(ADDRESS(ROW()-6,COLUMN()-1)), INDIRECT(ADDRESS(ROW()-5,COLUMN()-1)),...
2
votes
1answer
53 views

How to use Jekyll locally to create/edit posts on remote WordPress?

How do I use Jekyll on my local machine to create/edit posts on my remote WordPress blog? More specifically: I want to write posts in plain text, use Jekyll's markup parser to create HTML, and then ...
3
votes
3answers
18k views

Adding birthdays and anniversary to Google Calendar

I know how to add a yearly event but is there an option to add birthdays and/or anniversaries to Google Calendar? I am not talking of the "Birthday calendar" but manually adding a birthday event to ...
0
votes
0answers
8 views

Conditional Formatting based on another sheet, tying a value to a colour, Google Sheets

Does anyone know how I'd be able to make a specific value always appear with the same formatting & colour in my sheet, based on another tab in the sheet? The spreadsheet I'm trying to do this on ...
2
votes
3answers
1k views

Stop Gmail automatically checking for new mail

Using the web browser version of Gmail, is it possible to stop Gmail automatically checking for new mail? Occasionally, I need to access my inbox to retrieve information but don't want to be ...
0
votes
0answers
10 views

Change Google Sheet cell background color based on hex value within

So I've been looking online and I am not able to find an answer that is working for me. I have a Google Sheet, and some of the cells within that sheet have hex values in them. What I am trying to do ...
0
votes
1answer
165 views

How to change the size of an embedded Google Docs document?

Preamble By embedding a Google Docs document into a web page using the provided iFrame data <iframe src="https://docs.google.com/document/d/e/your_google_doc_id/pub?embedded=true"></iframe&...
2
votes
2answers
2k views

Cannot create Facebook account: “cannot register with that email address”

I'm trying to create a Facebook account with a Gmail email and it's giving me the error You cannot register for Facebook with that email address. To go back click here. Any ideas? I cannot find any ...
6
votes
1answer
1k views

Prevent 'reply all' in Facebook group message

I'm the admin for a Facebook group of approximately 50 members, and I want to send a single message to everyone in the group. I need to use a message because most members of the group do not receive ...
0
votes
0answers
11 views

Can I create a new Facebook account if my old one is disabled?

Will any new account I try to make be locked by Facebook (due to terms) if my old one still exists?
0
votes
0answers
5 views

Why twitter.com dont show my content preference?

Before 2 days i was able to see my content preference from twitter.com. Here is a current screenshot taken from twitter.com. Then i downloaded twitter app but here i am able to see my content ...
1
vote
0answers
11 views

Filter Gmail Updates folder

Spent a couple of hours sorting out my mailbox in MS Outlook. Emptied the bin/deleted folder, cleared sent items etc. Log onto gmail.com and noticed my storage is exactly the same. Checked all the ...
1
vote
0answers
5 views

Can I rename an entire neighbourhood in Google Maps?

My entire neighbourhood (est. 20k+ citizens) is incorrectly named in Google Maps. The whole neighbourhood's name is incorrectly taken after a single historic point being part of it. Can I rename it? ...
0
votes
1answer
58 views

Facebook eliminate country code from phone number and then ask for verification?

Basically, facebook suddenly asks for verification. However, they eliminate the country code from the verification. One obvious explanation is that the guy do not put the country code in his phone ...
1
vote
1answer
14 views

Google Calendar: Invited to recurring event, how to mark as free?

If I'm invited to an recurring event on Google Calendar, how can I mark myself as "free" for the whole series and not only for individual events? If I click on one event in the series and edit my ...
0
votes
0answers
5 views

Why the Gutenberg Editor is Not Available In My WP Site?

I have been hearing a lot good about the Gutenberg but unfortunately, it's not available and might be disabled on my site https://grabhosts.net. It's a coupon site that is running by a WP Coupon theme ...
5
votes
1answer
3k views

List the Facebook comments that I liked all the time

How can I see all the comments I liked on Facebook? I looked on the Activity log< pages, but I didn't find something useful.
1
vote
2answers
984 views

Move cursor to cell in all sheets

I have the following script: function setActiveCells() { var wb = SpreadsheetApp.getActiveSpreadsheet(); var ws_names = wb.getRangeByName('an_sheets').getValues(); var ws_cells = wb....
0
votes
0answers
15 views

Google Spreadsheet cell value dependant on other cell value

I am trying to make on cell value dependent on another cell value in the same row. I have a Project List spreadsheet with Data Validation list in column B with several Project Status (IE: Urgent, ...
0
votes
0answers
16 views

UNIQUE ,INDEX AND IMPORTRANGE

I am stuck. I use the import range to get a set of data however now I need to the unique values that that matches the import range that I have. Say for example below is randome sample. I have import ...
0
votes
1answer
14 views

How to center images in a WordPress gallery?

Inherently, inserting images in WordPress galleries puts the given images to the left most in their respective zones. When working with different sizes of image, this makes large images "stick" to the ...
1
vote
2answers
31 views

Find and place in a column, the first non-blank cell in each row from a range of columns

I'm attempting to create an ARRAYFORMULA that can extract the first non-blank cell value on each row in a range of columns. My latest attempt is this: =TRANSPOSE(QUERY(TRANSPOSE( A2:D6),"select * ...
0
votes
1answer
12 views

How to Redirect to another Website upon Google Form Submission?

I have a Google Form which is backed by a Google Apps Script with an onFormSubmit function, which fires when the Form is submitted. The next thing I want to do is, after the Form data processing is ...
0
votes
0answers
6 views

How long does one have to wait to be able to connect to web.wechat.com?

When trying to connect to connect to web.wechat.com, I get the error message: For account security, newly registered WeChat accounts are unable to log in to WeChat for Web. To use WeChat on a ...
0
votes
0answers
3 views

MINIFS using multiple ranges

I am trying to find the smallest positive value for multiple ranges. Essentially I want to find it in column J without including cells J7,J14,J21,J28 and J35. This is what I have so far: =...
1
vote
1answer
125 views

Gmail conversation sender

I like conversation grouping very much, but there is one problem that bothers me quite often: in email list view the sender shown is always the sender of the first message in conversation while I ...
23
votes
9answers
104k views

How can I see who has access to my Google Drive folders?

I have a main folder in Google Drive with lots of sub folders that also have sub folders. The main folder is shared with my team. Some of the sub folders are shared with external people (temporary ...
0
votes
1answer
11 views

How do you reference the entire google spreadsheet into another?

So, I have two workbooks, one with multiple sheets(W1) and one empty(W2) I want the empty one (W2) to have all the data (all strings, chars, and SHEETS) that (W1) has. IMPORTRANGE only takes data ...
0
votes
0answers
4 views

Where can I see the message I sent to someone whom I asked to sign a document as a replacement signer in Adobe Sign?

I replaced a signer in a Adobe Sign form: By doing so, I had to write a message for them: Where can I see the message I sent to someone whom I asked to sign a document as a replacement signer in ...
10
votes
3answers
10k views

How to ask questions on GitHub?

I am using the Flickr4Java library, which is hosted on GitHub. I have a question to the authors. On the main page it is written: Comments and questions should be sent to the GitHub Repo. How do I ...
1
vote
1answer
20 views

Color or group the same kind of data in a Google Sheet graph

I have the following data: | Test Combination | C-Score | Memory | Reasoning | Verbal | |------------------|---------|--------|-----------|--------| | ABCD | 13.70 | 10.51 | 13.04 |...
6
votes
3answers
102k views

How can I share my shopping cart with someone else on Amazon?

Do I have to click on "save for later" and create a wish list, which I know I can share, or is there a more direct way to share my shopping cart?
49
votes
14answers
88k views

How to prevent cut and paste data changing references in formulas?

Google Sheets has a feature where if you have a reference to a data cell in a formula, and you cut the data from that cell and paste it in a new location, the reference in the formula is updated to ...
0
votes
2answers
32 views

Average of only the numeric part of cell values when some of the cells contain text and numeric values

I am trying to figure out a formula that will allow me to find the average of a group of cells, where some of the cells only contain numeric values, and some cells contain both numeric values and text....

15 30 50 per page