All Questions

Filter by
Sorted by
Tagged with
0 votes
0 answers
2 views

Where has the Gmail Compose/Reply window pop-out command gone?

Until today, on latest Chrome brawser, Gmail Compose/Reply window offered a button at top right to pop-out to a separate tab. Now, it is not there. Where is it now? If anywhere....
  • 281
0 votes
1 answer
8 views

Google sheets array search. Any help Much appreciated :)

Hello I am trying to write a formula where Cells A2:A16 are searched for numerical values and the results are output in cells C2:F2. Within the data that will populate in A2:A16, there will only be 0-...
0 votes
0 answers
3 views

Google maps save public transit layer

On google maps app for android or website you can enable layer called transit (example) it will show all subways and trains in the city. How can I export train lines and stops as KMZ so I can import ...
user avatar
3 votes
2 answers
77 views

Convolve two arrays on Google Sheets?

How can I take the convolution of two distributions on a spreadsheet such as Google Sheets? Example 1: You want to multiply two arbitrary polynomials together on a spreadsheet symbolically (e.g. 2*x^4 ...
1 vote
1 answer
18 views

Google Sheets, apply conditional formatting based on parts of a cell

What I'm trying to achieve is this - In Google Sheets, I have a cell that contains numbers with a comma delimiter, for example: 0.5,2,50,200,0,4 I want to have 6 conditional formatting rules, working ...
1 vote
1 answer
9 views

Google Sheets Select Row that contains text and transpose it in a single step

I'm trying to select a row of data from my table based on text in columns A and B and then transpose it into a column. In my example, I would like to just have Minnie Mouse's information in a single ...
0 votes
1 answer
19 views

TRANSFORM ROW WISE DATA INTO ONE COLUMN CONSECUTIVELY based on the number of values in each row

I've learned how to use filters to organize row-wise data into columns and am taking that to heart in this spreadsheet! But I've hit a major snag. If you look at the example I've attached here, you'...
  • 3
0 votes
2 answers
9 views

How do I conditionally format a cell in a row based on a match with the value in a specific column?

How do I use conditional formatting highlight cells in a range where the value in the cell matches the value in a specific column in the same row in Google Sheets. For example:
  • 610
0 votes
1 answer
4 views

How to make Zoom speakers display at top of screen?

I don't normally do Zoom meetings where anyone uses video, but today I am. In preparation for this I'm testing a meeting where I am connected 3 times from different machines to check how it all looks. ...
  • 1,103
0 votes
0 answers
5 views

Varying Number of Wayback Machine Captures Found

When querying the wayback machine, I've noticed that the number of captures of pages varies based upon the precision of the url for the search. For example, the search URL of https://web.archive.org/...
-1 votes
0 answers
4 views

How to know the individual cost for each of the instances in aws?

I need to know what the individual cost for each is of my 4 EC2 instances this month. But in the billing, I can only see the combined cost for all the instances in a region. Is there a way to know ...
0 votes
0 answers
7 views

How to remove predefined facebook-messenger questions in the new environment please?

how I can remove predefined facebook-messenger questions in the new environment please? I checked Automatic Responses in the Meta Business suite but there isn't anything related to predefined ...
0 votes
0 answers
4 views

Mutual friend partially visible on same facebook profile

To keep it simple, let's say I have 2 friends on facebook. Friend "Jan" and friend "Patricia". Jan's friendlist is fully visible, Patricia's friendlist is set to mutual only. Now, ...
0 votes
0 answers
16 views

Stock Spreadsheet - How to add new stock without using a cumulative total

I have a small restaurant and have two Google spreadsheets, Monthly Orders and Total Stock. "Monthly Orders" keeps a cumulative total of all dishes sold during a month. "Total Stock&...
1 vote
1 answer
11 views

How to use AND condition is gmail filter

I'm sending a lot of email and would like to filter out bounced emails from my inbox. I'm trying to create a Gmail filter that filters out all messages with a subject that contains certain text AND ...
  • 111
1 vote
1 answer
15 views

Family tree in Google Sheets

I'm working on a family tree using the Organization chart method, but I can't find a way to connect 2 parents. I can only start with one box then spread to more from there. My goal is to start with 2 ...
0 votes
1 answer
9 views

Google Sheets Query with multiple and or statements

I'm trying to write a query for a spreadsheet that tracks inventory usage. The goal is to have the query find all instances of an ingredient being used between a given date range. However because of ...
  • 1
-1 votes
1 answer
33 views

Unable to parse query string for Function QUERY parameter 2: ADD_COL_TO_GROUP_BY_OR_AGG: Col2

I have two query formulas, with one inside the other (This is the way my manager figured it out and wants to proceed using this methodology for some reason). What's happening in the initial query ...
0 votes
0 answers
16 views

IP of the devices that logged into a Google account

My Google account is not signed up with gmail. I know that gmail lists the last IP's. If your account is something other than gmail, is there a way to see the last IP's of the devices that logged into ...
  • 101
0 votes
0 answers
7 views

Instagram - blocked account due to community guidelines (hacked) - with Facebook login - how to recover account?

This sounds like a mouthful but let me explain. The Instagram account was used with Facebook login. Someone logged into the account (Instagram) and posted something that was against the guidelines. ...
  • 171
0 votes
0 answers
25 views

Multi row dependant drop downs

I know this has been covered in a few other posts but i can't find any solutions that won't involve a lot of fiddly future work. I'm trying to create a Bill of Materials for a product in a spreadsheet....
  • 1
0 votes
1 answer
10 views

Managing poll answer in a spreadsheet: grouping same questions

I have a spreadsheet created from a poll with 3 columns: unique id, question, answer (a numeric value) Data repeats several times for each user like this: User ID Questions text Answers ID1 question ...
0 votes
0 answers
5 views

Scripting to make Microsoft online apps talk to eachother

I plan to set up a data collection and visualisation system for data from a number of entities. For licensing reasons this should ideally be in the Microsoft cloud apps (MS Forms, Excel, PowerBI - not ...
0 votes
0 answers
7 views

Google Photos sometimes not allowing to copy text from picture

most of the times if there is a photo (correctly uploaded of course) on Google Photo which contains some text the following command appears and you can copy text. Copia testo da immagine means Copy ...
  • 1
0 votes
0 answers
8 views

Microsoft Account

I left my parttime job and have a tablet purchased by the organization. My Microsoft account was with the organization's system. They have purchased a new system and I am getting notification from ...
0 votes
0 answers
5 views

Create shared Google calendar, sharing everyone's events without showing details

I want to create a shared calendar with a group of friends, showing everyone's availability, without everyone having to go out of their way to create a detail-less copy of all their personal events to ...
1 vote
1 answer
31 views

sheets query requires splitting last returned column by comma

Table with data in columns A-N. Data in column 'M' contains CSV data. Using this query can return data, need what's in 5th returned column (E) to be split into additional columns through one command. ...
0 votes
1 answer
15 views

How to transfer the ownership of a Google Sheets document to another account outside of the Google Workspace organization without losing cell history?

I have a Google Workspace domain that I want to close in order to move completely to my a Google Workspace domain. Under the old account there is an important Google Sheets document, a list of client ...
  • 101
-1 votes
0 answers
3 views

Why is my image button not active on reddit?

As seen in the picture, my image button is not active on some pages. what could be the reason for this?
0 votes
1 answer
12 views

Creating a formula to add data together

I have to create a table to calculate sales data from 2 different sources on a weekly basis. The sales team can sell via in store or online and this varies each week whether they sell through both or ...
  • 1
0 votes
2 answers
15 views

Google sheet Conditional formatting if text is in a list of words

How do I format a sheet so that the cells change according to the value inside a cell of a specific column that matches certain words? For example: Apply to range: A:F Custom formula is: =F:F=("...
  • 103
0 votes
1 answer
15 views

Is there a more sophisticated place to enter a formula to make it easier to work?

In Google Sheets there is one line at the top of the screen where you can type in a formula. As a programmer, after running into a few issues, the question comes to mind, is there an expanded view ...
0 votes
1 answer
6 views

Get share link of multiple folders in Google Drive to put in spreadsheet

I've got 200+ folders in a folder and need shareable links for each folder in a spreadsheet. Is there a way to do this without doing the right clicking thing for each folder individually?
0 votes
0 answers
11 views

Facebook is down for required maintenance right now when logging in

For the past 24 hours I have been getting the following: Facebook Will Be Back Soon Facebook is down for required maintenance right now, but you should be able to get back on within a few minutes. ...
  • 99
1 vote
0 answers
14 views

How to add all emails from a domain to a label in Gmail?

Hope I am not duplicating a thread, I searched but did not find this particular question. In Gmail, I know how to have labels added to all emails from a specific sender, but how do I set it up such ...
  • 11
1 vote
2 answers
30 views

How to use a specific formula in every row in a specific column now and in the future in google sheets?

In Google Sheets I have a very simple formula to subtract the value in column A from the value in column B and show the total in column C. Column C formula: =(B:B-A:A)*24 I've selected column C by ...
0 votes
1 answer
13 views

Fix Errors using Custom Formula in google Sheet with Script (getRange)

I have a google Sheet where i want to get the background colors of the specify range (Cells) using custom formula with script. within the Cell A1, i put the custom function: =gh(B1:D1) In script: ...
0 votes
1 answer
16 views

Can I link from a Google Sheet to a Google Doc heading?

Can I link from a Google Sheet, to a specific heading in Google Docs? I can link to a Google Docs, so it opens it and shows the beginning, but I would like to jump immediately to a specific heading ...
0 votes
0 answers
6 views

How to process client-side commands in NextCloud Collabora? [closed]

I like to create a table-based web application with server backend processing using the Collabora Calc app, hosted inside a NextCloud instance. Therefore the user can fill a predefined table template ...
0 votes
2 answers
15 views

Formula that combines name and true/false into a third column

I need help to make a Formula that combines name and true/false into a third column. See image for more information. I want the employees who are "Leader of the day", to have their names ...
  • 1
0 votes
0 answers
8 views

Does Google AdSense Reveal Your Info

I am considering multiple ad providers for a new site, and obviously, Google AdSense is one of my most prominent choices. I tried to sign up but it appeared to require a mailing address, which I don't ...
2 votes
1 answer
21 views

Google Sheets Query function sort breaks when using drop-down filters

I have a query in my Google Sheet to pull student testing data from a master list based on drop-down menu options. My goal is to sort the filtered data by Column L (Completion Date) so that I can ...
  • 23
0 votes
1 answer
15 views

Google Sheets: how to multiply two lists if condition applies in each row

I have a list of colors in column A (it could be A2:A) A1 Colors Multiply A2 Red 0 A3 Blue 1 A4 Orange 0 And I have types in column B (it could be as long as B2:B) B1 Types B2 Apple B3 Banana ...
  • 105
0 votes
0 answers
25 views

Gmail catch-all suddenly not working

3 weeks ago, without any changes from my part, my catch-all rule seems to change the reply-to header and hide the original sender. If the sender has a Gmail account, I will see his address email, but ...
  • 1
0 votes
1 answer
21 views

Need help with formula. Do I use XLOOKUP? VLOOKUP? Something else?

I need help with this Google Sheet: https://docs.google.com/spreadsheets/d/1tL3rJlx-SupBoX3AtOTzpePQigA-EB_E_hv7i5kAd7U/edit?usp=sharing The Master Report sheet is pulling data from the other ...
0 votes
0 answers
11 views

How do you clear Gmail search history?

How does one clear all of the Gmail search history at once, from the desktop web site (gmail.com)? I poked around in the Gmail settings but found nothing. I know you can clear items individually from ...
  • 297
1 vote
2 answers
46 views

How can I effectively parse a Google Spreadsheet with data not aligned well within Columns and Rows?

I have a data export in a very inconvenient format. In sheet1, I have student grade data that I cannot figure out how to extract into sheet2, where I am attempting to separate and SUM grades in one ...
-1 votes
0 answers
18 views

Pull a number from a website into a cell

I would like to get the value from the Sell price of the Core Strategy to appear in a cell from this website ( https://rest.com.au/member/investments/unitprices ). I tried using ImportXml to no avail. ...
  • 1
0 votes
0 answers
13 views

Google Drive stuck in boot

My Google Drive desktop on MacOS is stuck in boot. When booting the Mac, Google Drive loads the loading spinner and remains unresponsive. I've tried all the obvious stuff. Deleting cache files, ...
  • 1
-1 votes
0 answers
9 views

Help neeed regarding MERN Stack Auction Application Architectural Approach [closed]

I am building a system on the MERN stack (auction site). I am working on an auction site where the admin is able to add scheduled products on a site that gets scheduled and every user can view their ...

15 30 50 per page
1
2 3 4 5
675