All Questions
33,700
questions
1
vote
3
answers
51
views
Only have formula logic in the header column while counting unique days
I have a sheet with a Date and a Days heading and other non-relevant columns with more information.
Each Date only specifies the day and does not go into further precision like hours, minutes, or ...
- 13
0
votes
0
answers
16
views
My wife's FB page is hijacked (hacked). How to get it back? [duplicate]
My wife's FB page is hacked and hijacked. I can see the page on my friends list (her profile picture is gone) but all of her pics and threads are there.
But when she tried to log in, she got into a ...
2
votes
1
answer
23
views
Filtering incoming messages based on a domain while excluding an address from that same domain
In Gmail, if there are multiple accounts from the same domain name (e.g. [email protected], [email protected], etc.), you can create a filter that includes all of them using
from:(school.edu)
I am ...
1
vote
0
answers
55
views
Is there a URL query parameter for Google Messages for Web to specify a number to call?
My phone is on Google Fi, and I use Messages for Web on the desktop to send and receive calls and texts. It generally works great.
I'm trying to get it to work with the tel: protocol, however, and ...
- 43
0
votes
0
answers
24
views
Google Storage Limits not applying to users, groups or OUs
I'm trying to manage a user's storage. Their limit is somehow set to 130GB.
The limit says it is inherited from their OU, but when I check the OU settings, it's not there. This user is the only user ...
- 133
1
vote
1
answer
19
views
A link in a space task only works on the first click
When viewing tasks in the Tasks tab of a Google Chat Space, if a task contains a hyperlink, the hyperlink only opens on the first click. If you click again, nothing happens.
Viewing another channel ...
- 291
1
vote
0
answers
63
views
Gmail sign in problem [closed]
When my father attempts to sign in to his Gmail, the 1st time he types his password it says it's incorrect when it's not (he has the 'Show password' box checked to make sure). The 2nd time he enters ...
- 111
1
vote
1
answer
25
views
Need help creating a points-based attendance google sheet [closed]
I'm new to using Google sheet formulas, so I would really appreciate help/advice. I'm trying to set up a sheet that uses a points-based system to track attendance - basically subtracting a point for ...
- 11
1
vote
1
answer
13
views
How do I change the color of one cell (N5) based on the two other cells "is not empty" (C5&D5) [closed]
What formula would I use in Google Sheets if I want a cell(total dose, N5) to turn red if Cell C5 and Cell D5 are no longer blank? or "is not empty"
For example, I want N5 to turn red when ...
- 11
2
votes
0
answers
63
views
Can I setup automatic alerts for new YouTube videos that match keywords? [closed]
I wonder if I can set up a notification for YouTube if there is a new video that contains a specific keyword in the title or hashtags.
- 559
0
votes
0
answers
18
views
Limit form submission to 20
I have 2 event options A & B that can be selected.
Dates for A & B are the same (date field w range/ 9/11/2023 & 9/12/2023)
Times for A are 9:00pm & 9:30pm (choice field - House Tour ...
- 1
0
votes
1
answer
40
views
How can I plot my daily cost on Azure OpenAI for a given OpenAI model (and not the sum for all OpenAI models)?
I created several Azure OpenAI resources in my Azure account. I deployed GPT models in each of the Azure OpenAI resources. I access them via the Azure OpenAI Playground.
I can view the cost per day of ...
- 16.8k
2
votes
1
answer
63
views
How do I modify my script to unhide all sheets subject to multiple exceptions? [closed]
How would I modify this script to make multiple exceptions not just for one sheet? I am trying to unhide all sheets except for a few not just for one sheet.
function main(){
activateAllSheetsExcept(...
0
votes
1
answer
38
views
Which timezone is used to determine what falls within a given day in Azure?
I created several Azure OpenAI resources in my Azure account. I deployed GPT models in each of the Azure OpenAI resources. I access them via the Azure OpenAI Playground.
I want to look at the cost ...
- 16.8k
1
vote
1
answer
30
views
Place an "X" beside every value that also appears in another column
I am trying to create a Google sheet to consolidate information from different departments.
I have a list of product numbers in column A. I want to compare those values with another column of values ...
9
votes
0
answers
646
views
What do the red dashed lines mean in Google Maps? [closed]
What are the red/white "dotted" lines signifying in Google Maps? See image:
See also Aneityum on Google Maps.
- 91
2
votes
1
answer
45
views
Find the minimum number of values in a range whose sum is >= 75% of the sum of all values
I have a Google Sheet with two columns. Column A contains a list of names and column B a list of numerical values associated with those names.
I need to find the minimum number of cells in column B ...
- 629
1
vote
2
answers
31
views
Archive a message in Gmail without displaying the next/previous email message?
In the Gmail web-app, is there a way to use a keyboard shortcut to archive a message but not display the next/previous email message?
0
votes
1
answer
55
views
Split Column by comma and then adding it back onto the original column associated with the email
Dataset:
Each customer has an email account with us. Each email account can have multiple in-app accounts associated to the email.
Sample Dataset:
account_id
customer_email
[1,2]
junglehouse1@yahoo....
- 103
0
votes
1
answer
7
views
switching over cell image to in cell image in Google Spreadhseet
I have images in a spreadsheet that are placed above the cells. I try to put them into the cells. The help page reads
To move an image from over the cells to inside a cell:
Click the cell you want ...
- 105
1
vote
0
answers
18
views
Kindle Cloud Reader app search feature wacky behavior [closed]
I search a Kindle e-book using the Kindle Cloud Reader app, for example I type imper and it finds a number of entries containing the word imperative where that word is bolded and underlined. But if I ...
- 111
1
vote
0
answers
13
views
Does Brilliant keep the courses done after Premium? [closed]
I have purchased Brilliant app, and I've been wondering if anyone could answer me if after the month that I've paid for Premium, if I cancel my subscription for the next month, does the progress I've ...
- 21
0
votes
1
answer
23
views
Is it possible to convert all straight quotes to curly quotes in Google Spreadsheet?
I want to turn:
Col1
Col2
It's time to go home
What's your name
He said "nothing"
"I got you"
into:
Col1
Col2
It’s time to go home
What’s your name
He said “nothing”
“I got ...
- 487
-1
votes
1
answer
49
views
How can I configure an Azure OpenAI resource so that one cannot spend more than some given amount of money on it?
I created several Azure OpenAI resources in my Azure account. I deployed GPT models in each of the Azure OpenAI resources. I access them via the Azure OpenAI Playground. How can I configure each Azure ...
- 16.8k
0
votes
1
answer
34
views
How do I combine variables of a row and column?
I have dates set up in column A in yearmonthday format (ex. 20210101), types of product in column B (there are 8 that repeat throughout, so the same date is repeated in column A for 8 rows), and hours ...
- 9
0
votes
1
answer
53
views
How to check if a Google Sheets cell contains any of the values of a multi-dimensional array? [closed]
I have an multi-dimensional array in the following form:
var name = [
["John", "1"],
["Jane", "2"],
["Mork", "3"],
["Mindy&...
- 133
1
vote
1
answer
23
views
Workplace scheduling spreadsheet help, find (partial) duplicate in range
I work at the front desk of a tutoring and test prep center whose master schedule is a simple Google Sheets file with the schedule for each of our M-Th and Sat. sessions sharing the same spreadsheet. ...
- 13
0
votes
1
answer
17
views
In Sheets how do I have a cell confirm a specific user has completed a specific activity as populated on a sheet from google forms?
I have a google form that populates a row with answers including User and Activity. I have 75 users and 63 activities to check. On a second tab I have a column of users and a header row of ...
- 11
1
vote
0
answers
10
views
What is the deal with the select all button flaking out on me? [duplicate]
I need to clean up my gmail messages but I can't find out how to select all emails from search criteria to delete- I can only select all from the first page.
I clicked on one of my labels and there ...
- 111
1
vote
1
answer
46
views
Locate a text string and return the width of the range containing it based on whether it's in a single or merged cell
I have calendar data in my spreadsheet. Each row is a day, and each column is a half-hour increment of time from that day.
When I add events to the calendar I block off the time by merging the ...
- 11
1
vote
1
answer
13
views
Check whether a value appears in one of five columns in another sheet and return a specified value depending on which one it's in
I'm really tired and can't remember how to make this work so would appreciate any pointers on where I'm going wrong.
I'm trying to do the following:
Get cell K2 to provide a specified text value ...
- 21
1
vote
2
answers
44
views
How can I group/count occurences of a column
I have a Google sheet with 2 columns.
| Jim | Foo |
| John | Bar |
| Jane | X |
| Jim | YZ |
What I usually do is:
download the values as a CSV
write/run a script that processes the CSV
the ...
- 119
1
vote
2
answers
45
views
How do I paste formulas from a plain text file into a Google Sheet?
When I copy a formula from a text file into a Google Sheet, it shows up as plain text in the sheet rather than being used as a formula.
For example if I copy "=2+3" (not including the quotes)...
- 21
1
vote
0
answers
29
views
Replace old Authenticator option in my Google account [duplicate]
This question is different from the suggested duplicate, How do I recover my Google (or Gmail) account, password, or username? That question was about recovering a Google account. My question is ...
- 119
1
vote
0
answers
26
views
How can I get past Gmail's "Printing not yet available" short of waiting indefinitely? [closed]
I sometimes receive an PDF attachment where Print is blocked by:
If I wait an indefinite period of time, this resolves, in that Print becomes available.
When I can't afford to wait, how can get past ...
- 421
-1
votes
1
answer
22
views
Google Spreadsheets - COUNTIFS formula for the last 20 cells of an expanding column [closed]
I have a column of data which keeps expanding over time, I want a formule that states how many times a certain word appears within the last 20 cells of that column. Is that possible?
1
vote
1
answer
36
views
Adding Data to a Calendar created in Google Sheets
have created the pictured calendar on new tab within the same spreadsheet on Google Sheets. However, I am having a very hard time successfully transferring the data onto the actual calendar.
I am ...
- 13
0
votes
0
answers
7
views
Can't log in to my LinkedIn account [duplicate]
I've attempted to login to my LinkedIn account but I was told I will get a verification code to log in. However, the code wasn't sent to me. My email address is old and not in use. How can I get ...
- 1
1
vote
0
answers
11
views
Why Doesn't LinkedIn Give Me the Option to Publish a Post for Job Seeking? [closed]
I've updated my status to 'Open to Work', but LinkedIn isn't providing me with the box that's typically used to notify my network that I'm looking for a job. What steps can I take to rectify this? I ...
0
votes
0
answers
119
views
How to center image in Instagram Reel clips
Is it possible to change the position of a clip in an Instagram Reel? When I select a Live Photo it aligns the photos to the left side. I want the Live Photos to be centered in the clips for a Reel.
- 153
2
votes
1
answer
34
views
Google sheet: How can i create a drop-down data validation in a column whose list changes depending on the value selected in the previous column? [duplicate]
I have a data sheet containing two columns (Core Indicators and Activities) with core indicators and their corresponding activities. Each Core indicator has about 4 or 5 unique activities. On a ...
- 21
-1
votes
1
answer
296
views
How I can get the transcript of a YouTube Short?
How can I get the transcript of a YouTube Short? I don't see any option to download it:
- 16.8k
1
vote
1
answer
72
views
Is there a way to set a semi-transparent background on Google Slides when using a picture as the background image? (not opaque or transparent) [closed]
Without being able to select a translucency level the words get lost on the Google Slide presentation. Is there a way to use pictures that shoe the theme of the slide without this happening? There was ...
0
votes
0
answers
12
views
How to mirror all Facebook posts to Instagram Instagram? [duplicate]
How to auto post to Instagram every post from a Facebook page? Not the other way around. Also, from a Facebook page, not directly from my Facebook account.
So every time I post on a Facebook page, the ...
- 150
0
votes
1
answer
86
views
Apps Script that automates cell background coloring from HEX/RGB Codes
I'm creating color palettes with Google Sheets as a basis for a color reference book: You can see a sheetproof here. I wanted to batch fill the cells' background in Column C according to the HEX/RGB ...
- 11
2
votes
0
answers
117
views
Get Transcript of YouTube Short [closed]
Last week I was able to open one of my shorts as a full video to get the transcript by right clicking and copying the URL, then visiting the URL in a new tab. Now that doesn't seem to work - it just ...
- 121
1
vote
1
answer
28
views
Xlookup of value based in text and in-between dates, searching 1 (true) from condition range
Please help me to come up with the ARRAYFORMULA equivalent of the following formula that works perfectly when copied to every row:
=IF(ISBLANK(B2), "", ARRAYFORMULA(
XLOOKUP(1,(B2=G:G)*(...
- 13
2
votes
1
answer
56
views
In Gmail, how does one disable emails from automatically filtering into the 'Updates', 'Promotions', etc. Categories? [duplicate]
I saw this answer years back, and to be honest, I already had them (ie. all Promotions, Social, Updates, & Forums) unchecked so that only 'Primary' is checked (located via the Gear icon->See ...
- 21
-1
votes
1
answer
26
views
Sum of values with references on different rows
I want to sum specific values in column F, provided that the respective values in columns C and E have a unique match in columns O and Q. To make the logic easier, I would like to include a condition ...
- 101
1
vote
0
answers
27
views
Help needed in getting started with Codepen [closed]
I just signed up in Codepen, but can't however get anything to work. I have tried Googling the errors but couldn't find any remedy.
The problem: I am getting a persistent The connection was reset. ...
- 111