All Questions
33,000
questions
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:
...
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 ...
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&...
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.
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 ...
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 ...
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 ...
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 ...
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 ...
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'...
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 ...
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?
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
...
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 ...
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 ...
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 ...
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 ...
-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!
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 ...
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 ...
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 ...
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 ...
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, ...
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,...
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 ...
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 ...
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?
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 ...
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. ...
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 ...
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 ...
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 ...
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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=&...
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 ='"&...
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 (...
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 ...
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 ...
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 "...
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 ...
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 ...
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 ...
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. ...
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 ...