All Questions

1
vote
2answers
4k views

Google sheet limit, number of sheets per workbook

I know that Google sheets has a 2 million cell limit. https://support.google.com/drive/answer/37603?hl=en but was wondering is there a limit to the number of sheets? the old google sheet has this ...
0
votes
1answer
18 views

Generate Google sheet with selection from other sheet

I want to make a list of vegetarians in Document 2 from information in Document 1. Document 1 Columns A and B. Bill Meat Jane Veg Tony Meat Sarah Veg I want Document 2 to search ...
0
votes
0answers
9 views

How Syncing affects multiple Gmail accounts

I have multiple Gmail accounts and recently added a GSuite account for a non-profit with which I'm working. I'd like my bookmarks/folders to appear the same on both laptop and desktop computers for ...
1
vote
1answer
10 views

If a cell equals to this date, then filter through another sheet and grab that cell that has the same date

When you input a date in sheet 1, I want it to automatically grab data from sheet 2 and input text that matches that date back into sheet 1
3
votes
2answers
1k views

What happens to documents saved locally when they are deleted or unshared remotely

I am looking everywhere to understand how it works. Basically, I have some files I do not want to share anymore with some coworkers. I have revoked the permissions on Google Drive web interface. Now ...
1
vote
1answer
75 views

Gmail: group email, different content per user

I would like to create an email in Gmail where the recipients list is visible to everyone but it still gives each person slightly different email content. Is it possible? With an addon? Is it possible ...
0
votes
0answers
10 views

If I score lower when retaking an aptitude test on fiverr.com, does it display that way on my profile?

In fiverr.com (for sellers, at least), there is a "Take a test" option on my profile where I can take aptitude tests for various skills. The test results are displayed on my profile. I'm allowed to ...
0
votes
2answers
68 views

I want to get rid of google finance disclaimer

I want to get rid of Google finance disclaimer. I used the =GOOGLEFINANCE formula in a sheet. It triggered the display of a disclaimer at the bottom of the sheet that says: Quotes are not sourced ...
0
votes
0answers
6 views

Is there any way to add sanskrit99 font to googledocs [duplicate]

I would like to copy the contents of pdf which is using Sanskrit99 font to google docs. Any idea please on how to achieve that, thanks for your help.
4
votes
3answers
2k views

Is there a way to control the number of seconds by which to forward/rewind a YouTube video?

By pressing j or l on your keyboard, you can forward/rewind a YouTube video by 10 sec. But sometimes I need the ability to forward or rewind it by 3 sec, 5 sec, etc. Is there a way to control this? ...
17
votes
3answers
15k views

Why does Slack limit the number of contacts in my sidebar's direct messages section?

Slack seems to limit the number of contacts shown in my sidebar's direct messages section to 10 or 11 contacts. If I start a direct message with somebody new, another conversation is removed from the ...
0
votes
1answer
17 views

Google Sheets Cell Reference +1

I am wanting to enter a bunch of cell references that are affected by a change in only one of them. On one sheet tab, I have a list of dates in column C, and dollar figures in both D and E. In another ...
0
votes
0answers
34 views

Can my employer access my device's hardware info or control it in any manner even after I unregister? (On the Google apps/ business platform)

I added a new Google account on my device and signed in with my work account. It said that my device info like IMEI number, Mac address etc will be shared and the admins will also be able to control ...
0
votes
0answers
24 views

Facebook Leads to Salesforce through Zapier. Is it possible to specify a lead queue as the owner ID?

Zapier doesn't show lead queues in the dropdown box. I have tried using a custom value for the owner ID... which I got from the url address in salesforce when I click a lead queue e.g. 00B1400....., ...
0
votes
0answers
18 views

How to find all my Twitter accounts linked to an email address?

You can make multiple Twitter accounts with an email address by simply adding +word on your email address. So like, I have a few accounts, one is myname+business@gmail.com, myname+personal@gmail.com ...
0
votes
0answers
6 views

Why are there reviews for different types of products on Amazon than the product page they are displayed on?

Why are there reviews for a 'tumbler' on a kitchen thermometer item page? https://smile.amazon.com/FoodOMeter-Cook-Thermometer-Backlight-Calibration-Thermometer/dp/B07NV7FXY4/#customerReviews This ...
0
votes
1answer
16 views

Getting a direct image link with file extension to a published Google Sheets chart

I have a Google Sheet with a chart built from data in the sheet. I've published the chart, but the URL isn't an image link. I need it to be a direct link to a valid image format (either .jpg or .png). ...
2
votes
2answers
1k views

Does Yandex eventually start asking for phone numbers for verification?

I have multiple Yandex email accounts and haven't experienced any issues like asking phone numbers for verification. But I read somewhere on the web that some people are being asked for phone number ...
0
votes
0answers
866 views

Which of the functions INDIRECT or IMPORTRANGE slows down my Google sheet the most?

I have a master Google sheet that: Uses the importrange function to fetch data from eight different columns in 8,191 separate Google Sheets (files, not only sheets/tabs). To be extra clear: in this ...
0
votes
1answer
126 views

Google Sheets not processing very large numbers

I have a Google Sheet I setup for my clan, and we need to put in very large numbers. We are already using the Scientific Notation for the numbers, but one very large number is not getting treated the ...
2
votes
5answers
5k views

Is there a way to set a default font in Google Sheets?

I know that there is a way to set a default font on Google Docs, but I was wondering if there's a way to set a default font in Google Sheets?
2
votes
3answers
3k views

How to track LinkedIn ads in Google Analytics?

If my site gets clicks from LinkedIn both from ads on LinkedIn and from posts or things other than ads (on LinkedIn), how can I track clicks from the LinkedIn ads in Google Analytics?
0
votes
1answer
24 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 ...
-1
votes
0answers
6 views

Node Package Manager (NPM) website how do I favorite a package

Is there a way to favorite a package on npm.js either through the web or command line interface? I want to save a list of packages that I really like, so that they are easy to remember.
1
vote
1answer
17 views

IMPORTRANGE from a separate sheet based on closest date to today's date

Sheet1 will have data with different past dates Sheet2 - I want to import data from the 1st sheet and find the closest date to today's date. https://docs.google.com/spreadsheets/d/...
10
votes
1answer
93k views

Find the most liked tweet from an account

Is it possible to find the most liked tweet from a public Twitter account? For example, what is the most liked @StackOverflow tweet?
-1
votes
0answers
7 views

Nexus Oss 3 HSTS [closed]

First time posting to this site - I'm trying to get HSTS enabled on Nexus OSS 3.16.1-02 From what I've read, this is enabled by default as shown in the example above. I've created an edited jetty-...
0
votes
1answer
9 views

Having a formula output to a different cell

I have a Google Sheet in the following format: ID | VAL ------------- 1 | dataH 2 | dataW 3 | dataX 4 | dataC 5 | dataG 6 | dataL ... | ... ID and VAL are on cells A1 and B1, ...
0
votes
0answers
41 views

Is there a way to select a 'From:' alias based on intended recipient?

There is an old related (but not duplicate) question about automatically replying from an alias email address when an email is received to that alias. I have a catch-all address, me@example.com, set ...
2
votes
1answer
7k views

How can I recover a deleted comment on Facebook?

I accidentally deleted someone's comment. Is there a way to restore it?
0
votes
1answer
49 views

See Google Image search results with better resolution

When I do a Google Images search, the results are fuzzy, even if I enlarge with ctrl++. How can I get a higher resolution preview? Perhaps a browser extension or a search parameter?
1
vote
1answer
36 views

How to make Gmail's “reply to all” default?

I don't want to constantly remember to press reply to all, how to make that the default action even if I press "reply" instead. We're using G Suite Gmail at the company.
1
vote
1answer
17 views

Sum using two filter variables

So I have a ledger sheet that was set up to record costs for a single project. We've added a project column so we can track more than one project so every entry (row) now is identified per project. I'...
0
votes
0answers
7 views

Google Sheet - auto copy once a day a value from a row to another row in another sheet

I have a Google spreadsheet that is being modified during the day, and need to copy and paste the final information of a row in a different row in a different tab, each day, pasting the new ...
0
votes
1answer
52 views

Does adding another Google account to your Android phone also sync phone setting? [on hold]

So today I am adding my dad Google account to my phone to check his email regularly because he is not very good with the phone. When I am done adding my dad account my phone automatically sync ...
1
vote
1answer
21 views

Copy Contents of Cell When Checkbox is Checked - Google Scripts

Preamble: never used javascript before, but trying to learn through google sheets since I work with tons of data. Hello, I'm attempting to write a google script that will take the contents of a cell ...
2
votes
0answers
362 views

Google Scholar user profile has disappeared from search results

I have a public user profile on Google Scholar, and my user profile used to show up when I searched my name on Google Scholar. However, as of about two weeks ago, it no longer appears in the search ...
0
votes
2answers
2k views

How to calculate with cells that contain two values separated by linebreak?

I've got a Google spreadsheet that looks like this: Start time | End Time | Time difference -------------+---------------+----------------- 11:30:00 | 12:45:00 | 1,25 -------...
0
votes
1answer
10 views

How can I copy a row of data automatically to another spreadsheet when a condition is met in a drop-down menu?

Our small business uses a spreadsheet to track data from inquiries. Once booked, I need the data to automatically copy in the "Current Bookings" tab in the same sheet when "booked" is selected from a ...
0
votes
1answer
48 views

Gmail shortcut keys overridden by DevTools shortcut keys

I can't get Gmail shortcut keys to perform the Gmail actions because (I think) the DevTools actions for that shortcut are performed instead. For instance, to mark an email as read is Ctrl+Shift+I, but ...
2
votes
7answers
17k views

Can Gmail be configured to display ALL labels on the right pane?

By default, I get about 12 labels displayed. If I hover the mouse over the lower part of the pane, the labels unfold and all additional labels are revealed. I'd like to know if it's possible to have ...
0
votes
1answer
10 views

How can I have a 2nd function start in the cell after the output of the 1st function?

So the problem I am trying to solve is where I have Google finance fetching the price of a stock and outputting it, but the length of cells of its price history is increased by 1 each day. In the ...
3
votes
2answers
66 views

Filter out notifications from github except those from specific users

I belong to a Github organization and am being overwhelmed by notifications sent to the various repos in that org. I have a team of people whose notifications I do need to see; I'd like to filter out ...
0
votes
2answers
6 views

Look for a value that might be in many columns

Say I have a value in $A, to match to another sheet of the same file. That value (in this case, a student id) might appear in many columns of the other sheet. In the following example, I am looking ...
1
vote
1answer
15 views

Is there a way to convert DOCX to Google Docs directly in Google Drive?

Before, Google Docs would automatically convert Word files when you open it using the "Open with > Google Docs" command on Google Drive. But recently, it updated to allow native editing of Office ...
1
vote
3answers
287 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 ...
7
votes
1answer
575 views

How can I use both Disqus and Google+ comments on Blogger?

I have a blog with Blogger. I used Disqus before and there are a lot of comments on that. However now I want to use Google+ comments on Blogger because I use Google+ a lot. But I cannot find a ...
0
votes
1answer
110 views

Why does google forms ask me to sign in even though I am signed in?

I have gmail account signed in and when I open google forms that I received in my inbox, it asks me to sign in to continue. When I click sign in, it again reloads the same page and again asks me sign ...
2
votes
3answers
239 views

How do I title/label lists?

I am new to Trello and not too technology-savvy. How can I change the label or title of my lists? The three default lists are To Do/Doing/Done, but I would prefer to use the board in a different way,...

15 30 50 per page