All Questions

Filter by
Sorted by
Tagged with
0 votes
1 answer
25 views

Return value by lookup from multiple value

We constantly receive offers from suppliers and requests from customers. The problem is that customers and suppliers usually have several different identifiers for the same product. Like this: ...
user avatar
0 votes
1 answer
16 views

Google Sheets / Adding sum based on checkbox

I'm not sure if this is even possible but I'll try to explain. I have a custom shoe business and trying to get organized with money. Column 1 is just check boxes if a shoe was provided to me instead ...
user avatar
  • 1
0 votes
1 answer
26 views

Check if any cells in one column fall between cells in different columns in Google Sheets

So I'm trying to figure out if any call for service happens during the time frame of another call. The information is set up below like this: | |[A]|[B]|[C]| |:---|:---|:---|:---| |1|"Call Time&...
user avatar
0 votes
0 answers
6 views

How to create a course that is publicly visible without the need to login on Khan Academy?

It is possible? When I tried to create a test class, and e.g. the share course code for the course: https://www.khanacademy.org/join/MJZ6NSV7 requires logging in. I want this for SEO and privacy.
0 votes
0 answers
6 views

Why does the command `next start` start the server on port 3000 and not 8080?

I am trying to deploy my Nextjs app but it feels like next start starts the development server ;(. I did run next build.
user avatar
2 votes
1 answer
251 views

Text result of JOIN is longer than the limit of 50000 characters

Sample Sheet I want to split a column of data, where there are multiple lines in a single cell. I want these split into rows with a formula. I've got the JOIN formula set up for that and it works ...
user avatar
  • 189
0 votes
1 answer
24 views

How to make formula based off a withholding table?

I have been attempting to make a formula to easily calculate federal income tax rates. The picture attached is the withholding table that I've transferred onto a sheet. These are the thresholds I am ...
user avatar
  • 1
0 votes
1 answer
22 views

Is there a way to return more than one row from multiple matches in Google Sheets?

I'm trying to find a way to fill two columns in one table with two rows of data from another table based on matched criteria. To be more specific, A3:D contains the data I'd like to pull from. I'm ...
user avatar
0 votes
0 answers
2 views

Is there a way to delete a group chat created by a now banned account on Instagram?

I was added to an inappropriate group chat on Instagram and the creator of the group chat and many of the messages have been removed. There is another account that was added to the group that may try ...
user avatar
1 vote
1 answer
38 views

I can see my YouTube comment's history, but no replies to other comments. Why is that?

In the comment history of YouTube I can see my comments. However, I do not see my replies to other comments in that very list. Why is that? Furthermore I do not see my replies to other comments in ...
user avatar
0 votes
1 answer
11 views

Is there a way to search through comments on issues on GitHub?

Last night at like 3 AM I made a comment on an issue that was pertinent to the problem I'm facing. Now I can't find what GitHub issue I made the comment on. Is there a way to see all the comments I'...
user avatar
  • 1,302
0 votes
0 answers
10 views

Why does maps suggest this 5 times longer route as default?

When planning this route, googles first suggestion is this big detour. I have noticed that sometimes google chooses a longer route because its easier (less turns), or because its less kilometers or ...
user avatar
0 votes
1 answer
14 views

Convert PDF to a Google Sheet

How to convert a PDF to a Google Sheet which I deleted and is in my MacBook Air trash to a functional Sheet & save into Google Drive where I can continue to use it as a fully functional Sheet?
user avatar
0 votes
1 answer
10 views

Why is Gmail not asking for IMAP info when importing mail as I am not receiving emails?

It feels like Gmail (mail.google.com) only cares about smtp and email sending but it is not actually fetching new emails. In the configuration popup, it just asks for: name smtp server username ...
user avatar
0 votes
0 answers
4 views

Stop Chrome from going to a website when the connection is "not private" after using Advanced to circumvent that [migrated]

I'm creating a secure website that uses HTTPS. When Chrome accessed it, Chrome reported a "Your connection is not private" error. I then used the "Advanced" button to go to the ...
user avatar
0 votes
0 answers
9 views

Prevent Gmail from marking Google Maps' emails as SPAM

After about 3-5 years of uninterrupted usage, suddenly starting yesterday Gmail started to mark Google Maps' emails (about route sharing) as a SPAM. Is there anything I can do about this? I know that ...
user avatar
  • 2,536
0 votes
1 answer
51 views

(Google Sheets) Matching cell values with a partial search AND returning first non-zero value?

Having issues trying to set up the right formula to find the first instance of a partial match that has an associated non-zero value. Basically, I have a project that logs estimated and actual hours ...
user avatar
  • 11
0 votes
1 answer
13 views

Can recurring events be displayed distinctively in Google Calendar?

When I schedule a frequently recurring event, it overwhelms the real events in the calendar. That is, I quickly learn to ignore it, and so often fail to see the other events that are the same colour ...
user avatar
-1 votes
0 answers
9 views

Is it possible and easy to build a Hedera dapp with Flutter? [closed]

I am a junior software engineer so I am scared of hard to debug hacks and unpopular libraries but open to ideas!
user avatar
0 votes
1 answer
32 views

How to have Google Sheets auto sort by colour?

I have been tasked with creating a spreadsheet for my workplace that has multiple information on it, regarding cars, MOT date etc., IMO I have a decent spreadsheet working that will auto change colour ...
user avatar
0 votes
0 answers
8 views

Google Docs removed the comments from the sidebar. How do I get them back?

This has never happened before, but it started a few weeks ago. Friends have commented on typos in my story via comments. Now the comments won't show up where they need to be so now I can't tell ...
user avatar
0 votes
1 answer
15 views

ArrayFormula won't fill down column Google Sheets

I've got a sheet with account numbers in column Q. If the account number is 9 I want it to say "Yay", if not 9, "Boo". =ARRAYFORMULA(If(Q3=9,"Yay","Boo") This ...
user avatar
0 votes
0 answers
6 views

Finding the email of a YouTube account

I have the name and the ID of a YouTube account that I want to contact, but they have nothing in their about section except a brief description, no channel banner, and no videos or posts. I found this ...
user avatar
  • 1
0 votes
1 answer
15 views

Chrome Web Store displays old visuals

I'm working on a Chrome Extension. Over the past months I have updated the extension's visuals (screenshots) but the Chrome Web Store still displays the older ones in addition to the new ones (and, ...
user avatar
  • 101
0 votes
0 answers
7 views

Do I see new photos of blocked Telegram contacts

I blocked a person on Telegram. If this person changes his contact photo, do I see that? If yes, Is there a way to prevent it? I found out, that the blocked person can't see my profile picture anymore,...
user avatar
0 votes
0 answers
7 views

LinkedIn - How do I view a new Job Update from 2 years ago?

Is it possible on LinkedIn to see a new job update I had updated on my LinkedIn from 2 years ago? I had a look at notifications they only go back 30 days and then there is nothing on activity either ...
user avatar
0 votes
1 answer
42 views

Google Sheets: Making a function to find a number and impute it once

I am trying to make it possible to find the highest number under 30, and than place it in another cell. Then that cell will not change when another number becomes higher. For example if the highest ...
user avatar
  • 1
0 votes
1 answer
4 views

Force Shared Google Map To Use Terrain

I am using a shared map with bus stops and it is set to be in Satellite view. This makes it very difficult to read. Is there a way for me to change a shared map to use Terrain mode?
user avatar
0 votes
0 answers
23 views

Can I use an SMTP server behind a firewall when using Gmail?

I use a certain email address with Gmail, and I would like to use for it a different SMTP server than the normal one (it is an alias). The SMTP server is behind a firewall, is it still possible to use ...
user avatar
  • 167
0 votes
1 answer
26 views

Remove all Array_Constrain(ArrayForumla(*),1,1) formulas when importing from Excel to Google Sheets using RegEx

My first question here. I have an Excel Spreadsheet, where I have not used CSE, which I import into Google Sheets. Upon importing, some 40k+ cells have =Array_Constrain(ArrayFormula(*),1,1) in them. ...
user avatar
0 votes
0 answers
20 views

How do you create name badges in Google Docs with a background, preferably using Avery?

I am trying to use Google Docs to create name badges that have a background image behind the text. Our company used to have Microsoft Suite and historically, we used the Mail Merge option within the ...
user avatar
1 vote
1 answer
29 views

How to assign cell values based on options from another list

I am sure there is a simple formula for this but I have not been able to find a solution anywhere. I am trying to fill a cell based on a list in a different tab. In my main sheet, each row has a ...
user avatar
  • 11
1 vote
0 answers
10 views

Amazon family / household - how to sign child in?

I feel like I must be missing something obvious, but how do I sign a child in to their account under Amazon family? I added them under my account and shared Audible content with them but I don't see ...
user avatar
  • 273
0 votes
0 answers
14 views

How can I retrieve information about a inserted image in Google Sheet?

I want the user to insert a imagem in a cell, and based on that image I can resize the cell, but I see no way to retrieve that data using the classes CellImage and CellImageBuilder, any Idea?
user avatar
  • 103
0 votes
0 answers
25 views

YouTube keeps lowering the automatic quality even with very good internet speed

If I leave the quality of a video on "automatic", on a long video it will start at the highest, and every few minutes it will knock it down one step, until I'm seeing the video in in the ...
user avatar
1 vote
1 answer
23 views

How to transpose (rotate) entire Google Sheets sheet?

My sheet is 123 rows and 93 columns and is very complicated: there are lots of grouped/hidden rows, grouped/hidden columns, notes in cells, comments in cells, complex formulas (including ones that are ...
user avatar
  • 602
0 votes
0 answers
8 views

Devices not recognising my main Twitter account

I have three Twitter accounts but today I can only use two. The main account, that I use daily, now does not seem to be linked to the other two. When I go on to the Twitter app that account doesn’t ...
user avatar
1 vote
1 answer
18 views

Send message delay in Gmail

I want all the emails I send to be scheduled to be sent 5 minutes later, to safe guard from blunders (I know I can undo sending for 30 seconds, I want more time). In Outlook I did it using rules that ...
user avatar
  • 241
0 votes
1 answer
16 views

How can I make a data validation list with easy edition in Google Sheets?

I would like to make a structure similar with a data validation list in Google Sheet so the others users could contribute to it easily. For example, when I use the sheet I select one data validation ...
user avatar
  • 103
0 votes
1 answer
19 views

How to use ARRAYFORMULA in an IFS statement

Using IFS with ARRAYFORMULA creates an error saying that the: "IFS has mismatched range sizes. Expected row count 1. column count 1......" =IFS(A2="A",ARRAYFORMULA(B3:B10),A2=&...
user avatar
  • 3
1 vote
2 answers
32 views

Google Sheets: Remove column headers from a QUERY()

I'm trying to eliminate (not hide) the column headings from the following QUERY(). The output from the =QUERY() must be in a single row. =QUERY(myData!A:G, "Select SUM(E), SUM(F) WHERE D ='"&...
user avatar
  • 2,779
0 votes
1 answer
23 views

if and for statements on Google Sheets with multiple tabs

I am trying to figure out how to send an email to a bunch of people on my mailing list, but with it being individualized for each person. I have their names and email addresses on one Google Sheet (...
user avatar
0 votes
0 answers
13 views

Is there a way to redirect google drive links to a totally new website?

I made business cards with a QR code that linked to a google drive folder in which I hosted my portfolio. That was years ago and I still have some cards left. Now I have my own website but was ...
user avatar
0 votes
0 answers
8 views

How to align objects in Draw IO to a single object rather than an average

Draw IO's align and distribution tools work well except that ALL the objects move to a common location. I would like to be able to align other objects to match the horizontal/vertical location of one ...
user avatar
  • 101
0 votes
0 answers
9 views

Facebook: How to discover events in an arbitrary date range?

I'm using Facebook through a Desktop Browser. On https://www.facebook.com/events, it is possible to discover events using a narrow set of filters including "Top", "Local" and "...
user avatar
  • 101
0 votes
0 answers
4 views

Google Maps Lists only visible in Web Version not in Mobile App (Mac/Apple) [migrated]

after switching to a new iPhone (11 max pro), all my lists with saved places are gone on my phone but they are still there in my Google account when I access maps via Web. On top of that, the minute I ...
user avatar
0 votes
1 answer
8 views

Gmail automatically marks emails as read

In the past few days Gmail has started automatically marking any new message as read. I deleted all filters, confirmed that no other device (including my phone) are logged in to Gmail. However when a ...
user avatar
  • 1
1 vote
2 answers
41 views

How to search values within a cell?

I'm working with a large amount of data and am trying to enter standardized formulas to repeatedly convert to a more comprehensive version. What I'm having trouble with now is identifying each of ...
user avatar
  • 11
0 votes
0 answers
23 views

Keep data from Query

I am trying to import data from Sheet 1 to Sheet 2 using Query, but I have a problem. I need somehow to automatically keep the data that I've imported on sheets 2, after it get deleted from Sheet 1. ...
user avatar
  • 1
0 votes
0 answers
8 views

Permission to move/delete files/folders not created by me on Google Drive

We came into a situation, when we cannot move/remove files created by a user, who is no longer an active member of our organisation. I am aware, of possibility of transferring the ownership. But is ...
user avatar
  • 1

15 30 50 per page