All Questions

1
vote
1answer
16 views

How export a spreadsheet as XML?

How can I export a simple spreadsheet, consisting of a single column of data, as XML? Exporting as CSV is leading to other problems, so turning to XML as a workaround.
0
votes
0answers
34 views

Gmail default will not stay put, changes to a previous email address

Regardless of how many times I change my email default, following all of the wonderful steps the techies tell us, google changes default back to the same email address. Where is the deactivation of ...
0
votes
1answer
17 views

Autofill a cell when dates are entered in 3 other cells

I'm trying to create a way to keep track of our jobs by creating a Google spreadsheet. We can only order our final product when the digital and hard copy proof is approved and we have an order from ...
0
votes
1answer
17 views

How to make date automatically display only day number and suffix (1st, 2nd, etc.)?

Title explains it. I need to know how to create a custom number format in which a cell would display only the date and suffix of a full date entered into the cell example:1/05/2019 -> 5th I have ...
1
vote
1answer
15 views

Custom formatting with data returns what the cell shows but not what the cell contains

Basically I have this set up in one of my sheets in which these cells have data validation for "is valid date" so a calendar shows up when you double click them, then it has custom formatting so ...
1
vote
0answers
17 views

How do I get the non-mobile version of a Google site?

When I view my "new" google site on a desktop, I can see the content fill the entire page. When I view the same site on mobile, the layout is distorted and what used to be rows become columns. How ...
1
vote
1answer
23 views

How do I use the multiply line results from query or filter to get other values from an unsorted sheet?

I'm trying to take the results of a filter with multiple lines and use that results to acquire info from another sheet. Specifically, I'm trying to acquire Quantities in Customer Order sheet using ...
0
votes
1answer
17 views

Create sequential dates with each date repeated multiple times

For every day of the year, I need the day repeated in 10 rows. How can I accomplish this efficiently? e.g. 01/01/2019 01/01/2019 01/01/2019 01/01/2019 01/01/2019 01/01/2019 01/01/2019 01/01/2019 01/...
0
votes
0answers
28 views

How do I share private YouTube video? [duplicate]

It's been asked already in many places but all the answers literally everywhere are out of date, eg. How do I share a private YouTube video with someone? Here's how it looks like today, I have a ...
0
votes
0answers
23 views

Prevent YouTube seeking video upon tab-switch shortcut?

To reproduce bug: On macOS Chrome or Firefox (but not Safari); View a video (playing or paused) on YouTube; Press command-number to switch tabs (eg command1 for tab 1, command2 for tab 2, etc); ...
0
votes
0answers
25 views

Shared Reminders on Google calendar

Is there a way to add reminders to a shared calendar where both parties can see the reminder? Currently when I add a reminder on the shared calendar on my computer, the other person can not see the ...
0
votes
0answers
7 views

Email sheet and keep data validation format intact

I created a sheet in Google with check boxes and drop down menus. Now I need to email that sheet to another organization. But when I do, it drops all of the "special" formatting I put in place. Is ...
1
vote
1answer
25 views

How does one search a picture online?

If one has a picture file, like .jpg, how does one search (maybe Google) if this picture is around online?
-1
votes
0answers
61 views

Can't get my Gmail account back [duplicate]

My Google account got changed it's password from another device and I don't know whereabouts of that device. I actually can't do anything with the alternative ways. I'm totally left helpless. My ...
1
vote
1answer
20 views

How to include multiple IF statements with different data validations

I'm currently stuck trying to script a formula to populate a total value cell the factors in two different data validation columns (below): The first column is to deduct a certain value per hour, the ...
1
vote
1answer
18 views

Combining 3x IMPORTRANGE with dynamic range

I have 3 Google Sheet and want to combine all of them with: Sheet 1: 480 rows Sheet 2: 40 rows Sheet 3: 20 rows The sheet keeps expanding by the day since the sheet's data comes from a Google Form ...
0
votes
3answers
21 views

Select last entry from spreedsheet

So I have a Google Form dumping data into spreadsheet tab form responses 1. I have created another tab labeled summary. I need to have the summary tab only show the latest entry for a given pilot ...
0
votes
0answers
14 views

YouTube is listening on [command] + [n] key. Is there any way to disable it?

This issue started two days ago. I don't think I changed any of my settings. I tried focus out off the video frame but it still happening. My operating system is MacOS High Sierra v10.13.6.
2
votes
0answers
24 views

Google Profile Photo “certain types of Google Accounts can't change photos”

I am trying to change my profile photo for a Google Drive account, and I know how to do so and have done so before. However, for some reason, whenever I try to change it, either it says there's an "...
-1
votes
0answers
13 views

Creating a Facebook Page for an Association/Club

This looked like the place to ask Facebook related questions. I did a search for my question and didn't find a similar one. Feel free to direct me to the correct place if it's already been asked. My ...
1
vote
1answer
19 views

How to view full images on hover in Google Sheets?

Given a URL to an image, how can I easily insert images into cells into Google Sheets and then have the full images viewable on hover? I'll be doing this on the fly with many images throughout the ...
1
vote
1answer
12 views

How to insert cell text from one cell into an ImportRange Function

Hello! so I have an issue where I am trying to do is have multiple functions in C, D, and E where a link is required. Instead of copying and pasting the link inside all the functions in specific ...
0
votes
0answers
16 views

Regex Matching for Google Sheets Query Formulas

I'm trying to return a limited list of cells using a query that references another tab in my Google Sheets book. Please find a sample book here. The returned cells represent social media posts -- I'm ...
-2
votes
0answers
11 views

Compare two separate files in Google Docs?

I know you can track changes/suggestions in Google Docs using the suggestion tool, but is it possible to have a similar functionality where Google Docs can compare 2 files, similar to the compare tool ...
0
votes
0answers
11 views

Google Drive File Stream kicks regular Google Drive out of Windows Quick Access

I run Google Drive File Stream (GDFS) and Google Backup and Sync (GBS) simultaneously on Windows 10. I'd like to have both in the Quick Access list at the left of the Windows Explorer window. But it ...
0
votes
0answers
7 views

How do I search unread messages in outlook.com (Office 365)

How do I filter search results to only include unread messages in Office 365 outlook.com? I've tried read:no, but that looks for messages containing read and no.
0
votes
1answer
46 views

Split multi-line (comma-separated) cell into new rows + duplicate surrounding row entries

Based on: Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries) How can I rewrite this for use of a comma as separator and remove blank spaces? Input sheet: ...
0
votes
1answer
17 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 ...
0
votes
2answers
12 views

Match word in a cell with a column of words

I need to match a word to a list of words and then insert the category name in the cell next to it. Eg. I will in Column A type a list of words like Apple, Red Apple, Coke, Carrot The formula must ...
0
votes
0answers
14 views

Google Families Notifications

I am trying to turn off email notifications so that I don't get an email each time my son installs something. I have gone to all the steps guided in the support link: https://support.google.com/...
0
votes
0answers
32 views

Contact form submission reply to my self instead the lead

In my website I have a Contact form where people fill out the form and that info ends up in my Gmail. Up to a point till two days ago when I hit the reply button I will be replying to the lead as in ...
-1
votes
0answers
17 views

How to sync or import all contacts from various social media into Google contacts

Is it possible to either synchronize or simply import and merge all contacts from various social media into Google Contacts? I am working on a Windows computer, but have an Android phone in case I ...
1
vote
1answer
23 views

Custom Script in Pivot Table Value Formula = Error Loading Data forever

I am very new to the Google Sheets platform, but I am not new to programming, and am comfortable creating and managing javascript code, and reading API documentation. I am working on a side project, ...
2
votes
1answer
26 views

How can I contact another YouTuber?

I need to contact another YouTuber for a business purpose. But this YouTuber doesn’t have anything in their “About” section (no Business Inquiry Email). And YouTube removed the “About > Send Message”...
0
votes
1answer
27 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
vote
1answer
39 views

Find value of last non blank cell in a row (while skipping specific columns)

So basically I have a list of data in a row. They are totaled weekly statistics numbers and at the end of every month, there is a "total" column. The column where the 8 is at is where this formula ...
1
vote
1answer
9 views

Merge variable rows into one cell

I have the following data and I would like to have it organized by individual parts while merging the parts IDs into a cell is there any way of doing this with Google Sheets?
1
vote
1answer
25 views

How to combine FILTER with TRANSPOSE in data validation custom formula

Cells A2, C2, and E2 contain the data I want to make my custom list for data validation. Cells B2 and D2 have data I don't want in the list (just text - "vs" - in them). So, I'm trying to use the ...
0
votes
1answer
10 views

Can I move my filter beyond the first row?

I need to filter a spreadsheet but don't want my filter to be present on the first row as it's including the filter headings within the sort. Is there a way to filter a sheet but exclude the top 3 ...
0
votes
2answers
17 views

How to merge Google documents with PDF files automatically?

I am trying to merge different file sources into one Google doc, in a programmatic way. That means I should use Google scripting. So far I do not have problems inserting text files, images, MS Word or ...
-2
votes
0answers
28 views

I can't access my jsmith@rnran.com account - I don't have the password. [duplicate]

I have had this account for a long time but only use it occasionally. The I pad I had it on died and now I can no longer access it.
-1
votes
1answer
20 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 ...
0
votes
1answer
10 views

Unable to share YouTube videos to groups of users

We have a Google G Suite Basic account (company). I would like to share some videos to a group of users (a subset of domain accounts). Although I can share with individual users, there seems to be no ...
1
vote
1answer
20 views

GitHub markdown shortcut to treat text as code?

While writing an issue in a GitHub repository, how can I: Select a piece of text And press something so that it is treated as code? For example, here in Stack Exchange I can select a piece of text ...
2
votes
1answer
22 views

Find cell that contains some phrase

I'm looking for replacement of Excel formula: =if.error(lookup(1000;search($B$1:$B$2;A1);$B$1:$B$2); "NONE") The sheet looks like this: So in column A, I have a long product index, in column B, I ...
-1
votes
0answers
15 views

Which Google ᴀᴘɪ to use for searching a single specifc keyword over more than 5000 unrelated websites?

Being essentially in the same situation, I think I found a generic search keyword for finding if the website of bank allows registering non resident aliens. As I downloaded the official full list of ...
-3
votes
0answers
32 views

How to convert a fb://page/PAGE_ID link to a URL? [closed]

How to convert a fb://page/PAGE_ID link to a URL to use on my website linking to my facebook page? I want it to be opened in the app instead of the browser
1
vote
1answer
38 views

How to get direct download URL link for directory in Google Disk?

I know how to create a link from shared file https://drive.google.com/file/d/FILE_ID/view?usp=sharing to direct download link https://drive.google.com/uc?export=download&id=FILE_ID However, I ...
1
vote
1answer
17 views

If cell contains then

I need to create a formula that will check for a word in a cell and return a value or if the word does not exist then check for another word. Eg. Check Cell A1 contains the word "red" then print "...
0
votes
0answers
12 views

Is there a way to hide token in authy?

I may have accidentally deleted some authy accounts. I wonder if I can just hide those I think I won't need instead of deleting them?

15 30 50 per page