All Questions
33,743
questions
0
votes
1
answer
42
views
How to shuffle a range but prevent refresh?
I would like to achieve the following:
Extract a specified range based on user input in a cell using the arrayformula
Shuffle/randomise that extracted range
I have tried several approaches such as a ...
- 5,468
0
votes
0
answers
17
views
Transferring emails from an old Gmail account to a new one [duplicate]
I use a domain email address as [email protected] (GMail based).
I have also purchased a new domain and want my new email address to be [email protected] ( also GMail based) without losing any email from the abc....
HusaynAly
1
vote
0
answers
14
views
Zendesk Talk Dashboard for IVR's [closed]
I need some advice and pointers on how to go about creating a dashboard that shows which Zendesk talk lines have IVR's enabled on them to keep better track of active IVR's. Another idea would be to ...
- 11
0
votes
0
answers
13
views
How to use IMPORTRANGE function [duplicate]
I’m just having an issue. I need to IMPORTRANGE two Google sheet tables, but in the main source table is a filter turned on. I need to connect data from column "D" with name RM and ...
- 1
2
votes
0
answers
50
views
Is there a way to search filtered media of both posts and retweets by people I follow?
In Twitter, you can search both filter:media and filter:media filter:nativeretweets separately with people you follow (pf=on) on. It will either give you media posted by people you follow, or it will ...
- 21
0
votes
1
answer
51
views
Google Sheets: Change text color of multiple cells if checkbox is checked?
I have set up my conditional formatting to change text colors of a range of cells if a checkbox in that row has been checked.
However, this only changes text color of one of the cells.
Can anyone tell ...
- 5,468
0
votes
0
answers
11
views
Google Sheets: Change text color of cells in other columns if specific cell is focused?
I have a sheet with four columns.
What I would like to do is the following:
If the cursor is inside a cell in column A (meaning that cell is focused), the cells of that row from the other three ...
- 5,468
1
vote
0
answers
13
views
Autosort google sheet by date [closed]
I have a survey through qualtrics that has a workflow to import to google sheets. However, when it adds a row to my sheet, the row is at the bottom. What script can I use to make all rows in my google ...
- 11
2
votes
0
answers
16
views
Is there a setting in Gmail to keep the "recipient block" when replying to an email?
In the Gmail web app, when I Reply or Reply-All, Gmail removes what I will call the "recipients block" from the quoted text that shows the following information for the email that I am ...
- 21
0
votes
0
answers
15
views
I had an active linkedin account but when I tried to login today, I get the message that ID doesn't exist
I had an active linkedIn account but when I tried to login today, I get the message that ID doesn't exist.Even my previous contacts don't see my LinkedIn profile now. Please suggest how can I get back ...
- 1
1
vote
0
answers
23
views
How to convert a Splitting formula from Excel to Sheets (given that Textsplit is missing)
I'm attempting to copy the function of the following Excel sheet into Google Sheets and running into a snag.
https://1drv.ms/x/s!ApTGA-odt1HWhzGjuVHPn9bJyr5G?e=ZxtUCi
It takes the list from A2 chops ...
- 13
1
vote
0
answers
21
views
Gmail filters don't work if it is set up to both label and then delete incoming mails
I have a bunch of filters that are designed to:
Label the mail into a particular label
Mark the email as read
Delete the email
The reason why I need to label some mails is that while I don't want ...
- 111
0
votes
1
answer
22
views
Failure to autsort Google Sheets
I have a Google sheets that has the responses from a Google Form. I want the responses to be sorted according to contents of three columns (9, 12 and 13) when the sheet is opened. I'm using this ...
- 135
2
votes
0
answers
37
views
How to create a rule where the from email address is empty
I'd like to create a rule in my Outlook for when I receive emails where the from address is empty. Using Outlook to Block such emails doesn't work because you have to actually put an email address in ...
- 121
2
votes
1
answer
67
views
How do I add a google doc to the Docs template gallery?
I have a template document in Google Docs. It was added to the template gallery of my work account a few years back.
When I am logged in to my personal account (not my work account) it shows as added ...
- 468
0
votes
2
answers
35
views
Creating rule for two cells equaling same value
I'm trying to create a rule that will turn cells A through D red if cells C and D equal 0 or less.
I know how to make the rule with just one cell equaling 0, but would like to make it conditional on ...
0
votes
0
answers
63
views
If I save a frequently updated YouTube playlist, are the updated videos automatically saved in your Library?
Let's say today I save a YouTube playlist from another channel with 154 videos, and it has 1 new video updated to it everyday. If I go to my Library and click this playlist tomorrow, does it have 154 ...
- 9
2
votes
0
answers
54
views
How do I Bulk Delete all of my Instagram Comments and Replies?
How do I Bulk Delete all of my Instagram Comments and Replies?
For facebook I found a GitHub open source program that deletes all of my activity sorted (I can filter) wonderfully.
I want a script for ...
- 121
2
votes
1
answer
81
views
How do I change the number format for the horizontal axis labels in a histogram?
I would like to change the number format of the horizontal axis labels of a histogram. Some tutorials mention that this should work, e.g.
New chart text and number formatting options in Sheets
How To☝...
- 121
1
vote
1
answer
70
views
Transferring out of GoDaddy: Is there a method for fast transfer with manual approval?
I have a domain registered at GoDaddy that I want to transfer to another registrar.
I initiated the transfer at the other registrar and then received an email from GoDaddy that says,
We've received ...
- 1,402
0
votes
0
answers
10
views
Received message addressed to a similar email address, which is not mine [duplicate]
I sometimes receive emails that are not sent to my Gmail address but to very similar Gmail address. The only difference is dot between name and surname.
I'm not talking about spam, they are real mails ...
- 1
2
votes
1
answer
194
views
Is there a way to download all posts from a blog on Tumblr (not just images)?
I have Chrome on Windows 11. I've never downloaded blog posts from Tumblr but found a couple of blogs with interesting text posts and wanted to download them for reading when I'm off the internet. Is ...
2
votes
0
answers
73
views
How do I disable reels in my Facebook group?
I have a Facebook group and when I upload a video there, it automatically displays as a reel. Is there any way to disable reels in a Facebook group?
1
vote
0
answers
13
views
Update Google slide training suite using scripts [closed]
I have a series of Google slide decks which form a training pathway and we need to update them asap but don't have a lot of time for donkey work.
Our brand colours have recently updated and I would ...
1
vote
0
answers
13
views
Why search in Google Calendar not finding a reminder?
I have a reminder in September for a Dermatologist appointment. I didn't know what day it is in so I used search and entered Dermatologist and it didn't find it. I had to click on each day until I ...
- 255
1
vote
1
answer
41
views
How do I ignore a few rows below the header (including header) when sorting data in sheets? [closed]
I want to leave the filter buttons at the top, where they are but begin sorting from where the checkboxes are.. Every way I try, the filter buttons move or it sorts the top "notes" area ...
1
vote
0
answers
25
views
How to make an entire google sheet view only for everyone but the owner from 10:30am - 1:00pm Monday through Thursday [closed]
I have a google sign up sheet for lunches that I would like to lock/make view-only during the lunch period (10:30am - 1:00pm) on Monday, Tuesday, Wednesday and Thursday. I would like it to be editable ...
- 11
1
vote
1
answer
61
views
Need to sort/search by language in GMail [closed]
Because someone w/ the same name has used wrong email address, I constantly get spam emails in non-English languages.
If I could sort/search them, I could bulk-delete/bulk-spam them to clear out my ...
1
vote
0
answers
16
views
How do I remove Gmail CATAGORIES and just see all my emails in date order [duplicate]
How do I disable "Catagories" in Gmail and just see all the emails in Inbox and other "boxes" in date order?
0
votes
0
answers
28
views
I could not use a required font in Google Slides [duplicate]
I was working on a project for a valued client. One of his requests was for me to use Myriad Pro font.
I wasn't able to meet that requirement with Google Slides, which was disappointing to the client ...
- 1
1
vote
0
answers
32
views
How do I turn off the default autocomplete feature in Google Sheets? [closed]
I created a data validation rule for a set of cells in my Google Sheet so that I could have a simple drop-down and could select items as I type. However, Google Sheets always displays its own ...
- 111
2
votes
1
answer
37
views
Custom bookmarks that specificy the preferred OWA account
Is there a way to access Outlook on the Web from a bookmark that also specifies the specific account?
For example, I have two businesses that each have a Microsoft 365 account.
For example,
info@...
- 41
2
votes
0
answers
69
views
Facebook data download contains duplicate files [closed]
I requested a copy of all of my Facebook data, in HTML format. It gave me five zip files ranging from 2.8GB to 4.7GB to download, totaling 19GB. Those archives contain sub-folders named messages, ...
- 121
2
votes
0
answers
62
views
Why can't I post on my friend's Facebook Page even though "Who can post on your Page?" is set to "Everyone"? How to make it so followers can post?
My friend set up a Facebook Page and invited me to like it. I've liked it, and I want to post on it, to support her non-profit. But there is option for me to post, no post form or button that says ...
3
votes
1
answer
246
views
How can I undo "Don’t recommend channel" feedback I provided by mistake?
I accidentally provided "Don’t recommend channel" feedback to YouTube for a channel I actually like.
How can I undo this so YouTube recommends this channel?
- 474
2
votes
1
answer
283
views
In a YouTube brand account, what is the Google Account e-mail address used for?
In YouTube, when logged in to a brand account, clicking on the account icon in top-right corner and then going to:
Manage your Google Account > Personal info > Contact info > Email
and then ...
- 131
0
votes
0
answers
12
views
How to create a gmail filter that can filter all emails that reference me [duplicate]
so I have created a filter that captures all emails that are addressed to me.
But lot of people put me in CC whereas it should be actually be addressed to me.
(eg when they are looping me in or FYI me ...
- 1
1
vote
0
answers
20
views
Calculating multiple means and then putting them in a graph but more complicated [closed]
Me and my sister love playing the sims and we want to analyze how much each painting you can make will earn.
We made a spreadsheet containing the type of painting, the cost of the painting, the mood ...
- 11
1
vote
0
answers
22
views
How do I calculate the total amount per category by multiplying amounts with distinct multipliers? [closed]
I know how to program in python/go/bash, but I'm a super noob when it comes to excel or google sheets. Sometimes they are super helpful, but I often find it difficult to figure out what's an easy ...
- 19
1
vote
0
answers
26
views
Dynamic data, COUNTIFS formula value 0 [closed]
I have started creating my first dinamic report, but I bumped into some problems.
I have a source sheet with project group data in Column Z and month-year data in Column AO. My goal is to generate a ...
- 11
2
votes
2
answers
49
views
Query form data by date to return counts by item and category
I'm a teacher and need help with a Google Form that collects the following info:
Timestamp
Name
Class
Lunch option
All of the data comes into a Google sheet. I'm using successfully using the QUERY ...
- 21
1
vote
0
answers
116
views
Data validation range with ROW() in google sheets [closed]
Here is a link to a test spreadsheet:
https://docs.google.com/spreadsheets/d/10pofQ3TJM1FvBEPdvDq73-dm7hafhNwAbqVkfekofS8/edit#gid=0
The dropdown menus in column C are dependent on the selection in ...
- 135
1
vote
0
answers
24
views
How to create a whatsapp group with a single participant? [closed]
How can I create a group chat in the computer software WhatsApp with myself as the only participant?
This is useful because creating a new group is required in order to create an invite link for users ...
1
vote
2
answers
65
views
different results for COUNTIFS on date range when using > vs. >=
I haven't quite been able to wrap my head around this one, but I've got a spreadsheet that is a simple list of dates, formatted thusly:
11/1/2022 0:12:54
11/1/2022 6:45:43
11/1/2022 7:13:15
... and ...
- 11
2
votes
1
answer
25
views
Sum custom time durations
In Google Sheets I have several time fields in the format dd:hh:mm:ss
Sample Data
00:00:00:00
12:09:54:47
00:01:14:23
00:00:00:00
I would like to add all the values to calculate the total.
I've ...
- 21
1
vote
0
answers
68
views
Does Bandcamp support multi-factor authentication? [closed]
I don't see an option in the settings.
I have a fan account, mind you (i.e. a user; with over a dozen purchases).
- 841
1
vote
1
answer
98
views
IF YES then copy another cell [duplicate]
I have been using Google Sheets and getting things done slowly. I am using an extension called Autocrat and have been doing ok with it. (Not sure if there is a better alternative.)
My current problem ...
- 11
0
votes
0
answers
15
views
How to link a dropdown list to specific phrases?
I'm creating a dropdown list of names that are matching to the company. For example, this is the list:
Name
Company
Name
Corresponding
Macfee-John
Macfee
Macfee- Jane
Macfee
Aventis- Doe
Aventis
...
- 1
0
votes
1
answer
37
views
How can I filter based on date range with the dates per column in Google Sheets? [closed]
I am attempting to make some reporting easier for a few teachers. These teachers need to keep track of attendance and the percentage of time that the students are receiving instruction. Unfortunately, ...
- 103
1
vote
1
answer
104
views
How to report incorrect speed limit on Google Maps? [closed]
Google Maps shows the wrong speed limit for a particular road. How can I report this and correct the speed limit?
- 887