All Questions

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

How to dynamically return values horizontally in Google Sheets

Say I have a column like this: user item User1 Item1 User1 Item2 User1 Item3 User1 Item4 User1 Item5 User2 Item1 User3 Item1 How can I return them like this in a filter/lookup formula: user ...
yesnomaybe's user avatar
0 votes
1 answer
22 views

Problem creating Gmail filter combining FROM and To fields with OR

I'd like to create a filter that moves any messages based on the From field or the To field. In the search dialog when I populate 'From' with x OR y and 'To' with z the search created in the filter ...
user327593's user avatar
-1 votes
0 answers
41 views

Is Google Maps timeline now less detailed? [closed]

Since a few days ago (coinciding roughly with the migration of Maps Timeline to be "on device") the tracks recorded by timeline are no longer accurate or useful. Where before tracks used to ...
orome's user avatar
  • 626
0 votes
0 answers
43 views

Block unknown users from adding me to Messenger group chats

My Facebook account has been deactivated, but I am still on Messenger. It is referred to as a Deactivated Except Messenger Account (DEMA) I recently received a notification that I had been added to a ...
seagull's user avatar
  • 101
0 votes
1 answer
37 views

Sum multiple currencies by looking up conversion rates based on multiple cell values

I'm trying to sum values that are in different currencies. The currency for each value is specified in the previous column and the final result should be in Australian dollars AUD. I use a fixed ...
Phil's user avatar
  • 3
0 votes
1 answer
20 views

Delete non-Yahoo mail accounts from Yahoo mail

I have some external (not Yahoo) mail accounts being checked via POP in Yahoo Mail. I no longer have these external accounts and would like to delete them from my Yahoo account. Under 'manage ...
Rachel's user avatar
  • 1
0 votes
1 answer
47 views

Join results of a BYROW function that expands into multiple rows

I have two sheets, one containing user-entered data, and a second containing a bunch of data. I have included example sheets at the bottom of this question. I'm trying to build a formula that for each ...
Spedwards's user avatar
  • 215
0 votes
1 answer
23 views

How to force English number format for all number values in a column?

This is what I see by default in my table:  Pasted  Value    DisplayedValue                                                                                                                             ...
Tomáš Zato's user avatar
-1 votes
1 answer
25 views

Are there any downsides in converting a Slack direct message into a private Slack channel?

I'm considering converting a Slack message into a private Slack Channel. Are there any downsides in converting a Slack direct message into a private Slack channel? (E.g., missing features)
Franck Dernoncourt's user avatar
3 votes
1 answer
143 views

How can I jump to the message(s) where an image was shared in Slack?

I sometimes find it convenient to look at all the images I exchanged in a DM: How can I jump to the message(s) where one of these images was shared in Slack?
Franck Dernoncourt's user avatar
0 votes
0 answers
13 views

My repeating event with "no end date" ends after 11 occurances

My Google calendar weekly repeating task with "no end date" ends after 11 occurrences. The first task is May 31, 2024, and the last is August 23, 2024. I have tried deleting all occurrences ...
Chip Buchholtz's user avatar
0 votes
1 answer
27 views

How can I send and receive from Gmail account in Outlook.com?

In Yahoo Mail, I can add my Gmail account using Settings -> Manage Accounts, so that I can send and receive Gmail messages from within Yahoo Mail. How can I configure Outlook.com with my Gmail ...
Tim's user avatar
  • 3,369
0 votes
1 answer
22 views

Sorting by date on a master spreadsheet with data imported from other spreadsheets

I have 4 spreadsheets importing data from cells A2:V, each spreadsheet auto sorts on edit by date (column 17), but when I ask the master sheet to auto sort by column 17, it sorts them by date but also ...
Psych-out's user avatar
0 votes
0 answers
16 views

How do I email all members in a Workspace group as a combined group and not just the group's email address?

I have just started using Google Workspace for non-profits as admin and am writing up introductory notes for the charity's trustees partly to persuade them that it's a good idea to use this system, ...
Gillian's user avatar
  • 101
0 votes
0 answers
16 views

How can I end all my active contracts at once on Upwork?

I hire freelancers on Upwork. I finished a large project, and now I'd like to end all my active contracts at once on Upwork. How can I end all my active contracts at once on Upwork? I don't want to ...
Franck Dernoncourt's user avatar
0 votes
1 answer
41 views

How can I search for a text present in a code snippet in a DM or channel in Slack?

How can I search for a text present in a code snippet in a DM or channel in Slack? I want to only run the search across code snippets, and not other texts.
Franck Dernoncourt's user avatar
0 votes
0 answers
15 views

YouTube Video Description Not Updating in Google Search Results After Editing: How to Resolve?

I've noticed a recurring issue with YouTube videos where, after initially posting a video and having it appear in Google search results, subsequent edits to the video description do not seem to be ...
Davoud's user avatar
  • 101
0 votes
0 answers
10 views

Are the user playlists on spotify auto updated?

We all know there are playlists curated by the spotify team. And in the app, we can create our own playlist. In this "self created" playlist (meaning a user creates an empty playlist for ...
deostroll's user avatar
  • 671
-1 votes
1 answer
20 views

How to get a cell to autodelete contents after subtracting from another cell

I have a spreadsheet to keep track of payments on group trips and would like to be able to keep everything within that spreadsheet. I would like the ability to be able to delete from the sum that ...
Yager's user avatar
  • 1
0 votes
1 answer
24 views

Getting error thrown when trying to retrieve a png in my own google drive using UrlFetchApp.fetch()

I have a script running that creates a qr code for a google form and saves it to my google drive and collects its url. I'm trying to then put that qr code in a google doc. I could have sworn my code ...
AnonymousTurtle's user avatar
0 votes
2 answers
36 views

How for each cell in a row return and concatenate multiple matches without dragging down formulas?

I have a list of items and in another place I have list that covers some of these items each time with a different key. How to fill in column B all matching results next to the original item (column A)...
LWC's user avatar
  • 1,240
1 vote
0 answers
30 views

How can I see how many downloads a model or dataset received on Huggingface in total?

Example: https://huggingface.co/datasets/uonlp/CulturaX/: The number of downloads only shows the last month. How can I see how many downloads a model or dataset received on Huggingface in ...
Franck Dernoncourt's user avatar
0 votes
0 answers
31 views

Where can one see the history of huddles in a Slack channel via the Slack web UI?

Where can one see the history of huddles in a Slack channel via the Slack web UI? I see on https://forums.slackcommunity.com/s/question/0D5Hq00009NAldDKAT/is-there-any-way-to-find-out-when-a-huddle-...
Franck Dernoncourt's user avatar
0 votes
0 answers
77 views

How to save the end-to-end encrypted Facebook messages? And search in old messages (after the encryption update)?

There was a Facebook update, i believe March 27, 2024, which made all messages end-to-end encrypted. Facebook offers to save the messages via Messenger.com on desktop - Privacy & safety - End-to-...
FBghostInDistress's user avatar
0 votes
2 answers
22 views

Two Phone numbers for Whatsapp

I am moving from New Zealand to Australia. So for the next year, I have a mobile number in each country. **Whatsapp is linked to my NZ number. Will it keep working for my new contacts on the new ...
Rohit Gupta's user avatar
0 votes
0 answers
23 views

Back my old facebook [duplicate]

I forgot my password to my account and I changed my phone number when I left USA how can contact with Facebook to give them approved it’s my account DeemahArab
Deemah Arab's user avatar
0 votes
0 answers
19 views

How can one see who started a huddle on Slack?

Example: How can one see who started a huddle on Slack?
Franck Dernoncourt's user avatar
-3 votes
1 answer
32 views

More computational capabilities per spreadsheet

I am a pro user of Google Sheets and Google Apps Script. Is there any possibility to get more computing capability per spreadsheet? Some of my spreadsheets become unusable due to a large amount of ...
Piotr Magdziak's user avatar
-1 votes
1 answer
30 views

How can one stop a huddle on Slack?

Example: How can one stop a huddle on Slack? I don't see any option:
Franck Dernoncourt's user avatar
2 votes
1 answer
141 views

Google Sheets: how to format currency with numbers right-aligned but +/- and $ left aligned and padded with spaces?

I've already looked at: How to left align currency symbol but right align number? How to left align dollar symbol but right align number? The best number format I have so far is: [$$]* #,##0 which ...
Ryan's user avatar
  • 774
-1 votes
1 answer
27 views

Growth between 3 cells in Google Sheets

I am creating a data wall to compare student achievement across 3 time periods Beginning of the Year(H2), Middle of the Year (I2) and End of the Year(J2) and having the difference recorded in K2. I ...
Justin Barry's user avatar
0 votes
0 answers
23 views

End of Free Trial Period on Meet Up group

I set up a free trial period of 30 days on my Meet Up that ended yesterday to pay dues by May 23 to stay in the group. Why haven't unpaid members been removed from future events they were signed up ...
user327072's user avatar
1 vote
2 answers
94 views

I'm looking for a way to return multiple values in an array formula on Google Sheets - haven't been able to find a solution

Scenario: I have a roster of dog owners who have had dogs involved in various training classes. I have a list of the dogs and their respective classes, and I have a list of the owners. I want to ...
Alison's user avatar
  • 11
1 vote
0 answers
16 views

Custom sharing on Facebook - will the targets be able to see each other?

There are many similar questions, such as this "recent" one: People can see with whom I shared a post, when I post it with custom sharing I'd just like a straight answer. "Suppose" ...
byteflush's user avatar
  • 111
0 votes
1 answer
18 views

Conditional formatting formula to highlight duplicates but only if the date equals today

I'm trying to write a conditional formatting rule to highlight cells in B3:B that are duplicates, but only if today's date is in column A. I started with =COUNTIF(B3:B,B3)>1 which returned the ...
Jeremy Urekew's user avatar
0 votes
1 answer
15 views

Wrong Hebrew text direction in SodaPDF

I have a problem in SodaPDF free version when I try to type in Hebrew (written from right to left) - the text it is written in the opposite direction. I tried adding text both in edit mode and not in ...
Gilad Nachman's user avatar
0 votes
0 answers
20 views

How to remove multiple section breaks in google docs

My document is filled with "section break (next page)", how do i remove all of them at once?
Vlad's user avatar
  • 11
1 vote
1 answer
36 views

Is it possible to modify a search URL so that the results are interpreted as English?

I am using the web app webtopdf.com which converts web pages, based on URLs you supply, to PDFs. The URL I'm providing is a Google Search which I see in English https://www.google.com/search?q=Bible ...
Tim's user avatar
  • 3,369
0 votes
2 answers
35 views

How to use the value of a cell to find another cell?

I’m trying to create my own data sheets for reading at school but when I put the reading ages in, I need it to select the zpd level and the reading targets automatically base on what I input. Eg if I ...
Kevin Wilson's user avatar
1 vote
0 answers
28 views

zoom fit all visible markers in google my maps [closed]

Let's say you are planning a cross-country trip. There may be many place markers in your Google My Maps file. Is there a way to zoom fit all the (visible) place markers so that we can see them all at ...
deostroll's user avatar
  • 671
0 votes
1 answer
23 views

Show zero value if result is NA in query google sheet

It showed #N/A if "Cash" is not in list. How can I show result "Cash is: 0" instead of #NA?
Sok Dara's user avatar
0 votes
2 answers
27 views

What's the fastest way I can open the Google folder in which the spreadsheet is located?

I have opened a Google spreadsheet. What's the fastest way I can open the Google folder in which the spreadsheet is located? Fastest way means with the fewest clicks.
Franck Dernoncourt's user avatar
-1 votes
1 answer
44 views

Whatsapp Web on Chrome/Windows: Shift+Delete not cutting to clipboard

When I press Shift + Delete I'm expecting the selected text to be cut into the clipboard. That is not happening on any text field of Whatsapp Web running on Windows/Chrome. Ctrl + X works fine though. ...
ariel's user avatar
  • 324
1 vote
0 answers
15 views

How can I cancel a Slack message that I've sent but contains an image that is still uploading?

How can I cancel a Slack message that I've sent but contains an image that is still uploading? Example: Ctrl+Z and Escape don't do anything.
Franck Dernoncourt's user avatar
0 votes
2 answers
17 views

Sort data by number in cell containing number sometimes followed by text

I'm working on a shopping list with aisle numbers in Google Sheets and the aisle numbers can be digits alone or digits followed by a letter. For example 1, 2, 3, 3, 4, 6A, 8, 19B, etc I want to sort ...
JeffK627's user avatar
-1 votes
1 answer
29 views

Breaking up long column array into different columns

I want to be able to copy and paste an order of draw (starts with the draw number and school name, then each proceeding row is the athletes names) which is just a long array in a single column and ...
AnonymousTurtle's user avatar
0 votes
0 answers
19 views

Can I share access to the Azure OpenAI playground to another member of my organization?

I have an Azure account via my organization. Can I share access to the Azure OpenAI playground to another member of my organization? I know I can give other members of my organization access to Azure ...
Franck Dernoncourt's user avatar
0 votes
1 answer
669 views

I can not verify with LinkedIn using CLEAR: We weren't able to verify your identity. Your personal information could not be confirmed

Whenever I try to verify with LinkedIn on clear, I eventually get this, We weren't able to verify your identity Your personal information could not be confirmed What's wrong here? I've tried with ...
Evan Carroll's user avatar
  • 1,480
0 votes
1 answer
41 views

How to use Array with Sumproduct or other formula

I am trying to use an array formula like SUMPRODUCT to perform a lookup with 2 criteria. I have a sheet named data that stores customer-specific pricing for products. A B C             D 1 ...
Anakin Teow's user avatar
0 votes
0 answers
12 views

MORE DETAILED explanation of ERROR: Array result was not expanded because it would overwrite data in B6 [duplicate]

Here are screenshots from my spreadsheet that has the issues I discussed in the previous question: IMPORTRANGE(,) works in a single cell, however, when adding the same formula to the next cell in the ...
Newton's cat's user avatar

15 30 50 per page