All Questions
33,742
questions
0
votes
1
answer
2k
views
Pasting timestamp for edits by multiple users in Google Sheets
I got a good Google Sheet script for pasting a time stamp at the designated column of the same row on editing any cells of another particular column. Here it is On Edit of column 11: timestamp is to ...
CommunityBot
- 1
0
votes
1
answer
26
views
Scrape blockchain data into Google Sheets
I’m trying to scrape some data in Google Sheets for the following page: https://mtvscout.com/token/0xa4b775e2563fa3a7f4d82ada9595383edc4bcb68/instance/20/token-transfers
The bit of information I need ...
CommunityBot
- 1
0
votes
0
answers
7
views
LinkedIn user (not me) with my updated email address: security risk? how to fix?
I do have access to my single, personal, LinkedIn account using two unrelated email addresses. And I can receive email from LinkedIn at both of them. But one of them (which I recently made secondary), ...
-1
votes
0
answers
9
views
Once I had an option, on Google Search Result page, to translate the result to my laguage (Hebrew). it is gone. can I resturn it? it was helpfull
In the search result, for almost every result, there was a small link which opened a new tab with the result already translated to Hebrew. It helped me a lot. I would like very much to return this ...
- 44.6k
0
votes
1
answer
1k
views
Keeping the totals row always visible in Google Sheets
I have data in rows 1:69 and created a totals row 70 that summarizes the above rows. How do I keep row 70 always visible? In the Sheets iOS app, I can freeze rows 1:69 and always see row 70, but in a ...
- 13.2k
1
vote
1
answer
42
views
Gmail Forward email to group, with recipients replying to specific person
I forward a LOT of emails every day. Most of the time, people reply to who they need to.
Example. "Do you need money?" Email. Forward to people who need money. But I don't need them to reply to me, I ...
CommunityBot
- 1
0
votes
0
answers
2
views
reducing the font size after it has been increased [closed]
My font is enlarged - now I want to reduce it. when I hover over the gear the information is on the far right of the screen. when I slide the bar over - it loses the information box. help - how ...
1
vote
1
answer
30
views
Use of Countifs to check values from two different columns to match a criteria
I have a data with 3 tabs. Tab 1 has information to be analyzed in tab 3. So in tab 1 I have column J and K which have responses of either "yes" or "No" in one row. So if for ...
CommunityBot
- 1
14
votes
3
answers
48k
views
Is it possible to freeze multiple separate rows in Google Sheets?
Currently, Google Sheets can be used to "freeze" sections of a document so that those sections always persist when scrolling, as demonstrated in this video. However, a limitation of this is that only ...
- 1
0
votes
0
answers
9
views
Google Sheets QUERY to return if contains multiple selection and all other values
I have a data set similar to the image in cells A5:D31. I am trying to write a QUERY function that will return the records that match the "filters" in range A2:D3.
In this example, the query ...
- 19
0
votes
1
answer
65
views
MediaWiki - sort simple list
I have a basic MediaWiki installation with several categories (which is sorted automatically). In each category I have several links to articles. These links are listed in a simple star (*) list, ...
CommunityBot
- 1
1
vote
1
answer
20
views
dropdown menu with multiple cells
I'm figuring out how I can use a dropdown menu that will auto fill other cells with the right information. For example i made a nutrition calculator but I'm tired of filling in by hand every time. ...
CommunityBot
- 1
1
vote
1
answer
71
views
Managing OUs and features in the Google world
I work at a fairly large company (65k+ users) which has massively adopted Google G Suite and I work with the G Suite admin team to architect our environment. One of the things I'm struggling with is ...
CommunityBot
- 1
0
votes
1
answer
40
views
Help adding checkbox to google sheets
I am a novice to google app scripts. However I need to copy selected rows (with a checkbox) to a second sheet. I am using this code below. However it copies the entire source sheet. I only need rows ...
CommunityBot
- 1
1
vote
1
answer
78
views
AND / OR Conditional Formatting for Google Sheets with multiple criteria
I am trying to write a custom formula to conditional format column E by referring to the different tenure level targets in column D to indicate if they are hitting their targets base off of their ...
CommunityBot
- 1
0
votes
2
answers
37
views
Making two OnEdit triggers work simultaneously
I'll admit I'm not amazing at code but I can generally survive the basic stuff. At the moment I'm trying to get two onEdit triggers to work at the same time, but I'm struggling (generally only one ...
- 13.2k
2
votes
1
answer
70
views
Calculate Discount Based on Total
I’m new to Cognito Forms and am trying to give a discount once a Total is met. I have a FormTotal calculation field but it doesn’t seem to be calculating all the fields. I would like to Total the ...
CommunityBot
- 1
3
votes
1
answer
2k
views
Simultaneously sort multiple ranges on a single sheet in varying orders
I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
CommunityBot
- 1
0
votes
1
answer
16
views
How to make arrayformula automatically applied to newly inserted rows?
The following arrayformula needs to be applied to the entire column B, so that it populates Twitter account IDs in the cells of Column B according to hyperlinks in Column A. It firstly checks whether ...
- 13.2k
1
vote
1
answer
668
views
outlook web: how to mark search results as read
I just came back from vacation, and I have a few thousand messages to go through. Is there a way for me to run a search in Outlook Web, and then say "mark all these results as read"?
If I click on ...
CommunityBot
- 1
0
votes
0
answers
17
views
GDrive files deleted with previous owner [closed]
In our Google workspace for education, an account was deleted. Previously, Google drive files' ownership were transferred to another account. The deletion of the account implied the deletion of the ...
- 101
13
votes
5
answers
37k
views
How do I download all Google Docs in a folder as PDF?
I have a Google Drive filled with Docs, Slides, and Sheets. The new Google Drive interface no longer supports choosing the file format for bulk downloads, and just gives me a bunch of useless ...
2
votes
1
answer
1k
views
YouTube higher quality = no buffering
While watching videos (no video in particular) if the video starts buffering at 360p, I switch to 240p and it still buffers but if I switch to 480p it doesn't. I'm connected directly to a router so ...
CommunityBot
- 1
0
votes
1
answer
983
views
How to get email address of CC
I recently received a mail which contained a CC. I want to reply to the person who wrote to me however I want to CC the person he had already CC'd but I don't know his mail. Can I somehow get the CC'd ...
0
votes
1
answer
233
views
Google sheets -How to modify a number in a formula based on user input
I was trying to automate a project where I would need to modify a number in one of the formula every time as per the user input.
For example: in the above formula, the highlighted number (9) should ...
CommunityBot
- 1
1
vote
1
answer
27
views
How I can I configure the Google Chat web app so that I continue to recieve notifications on my phone?
How can I configure the Google Chat web app so that notifications continue to show up on my phone whilst I also have the web app open in a browser window, which also (optionally if configured to) ...
- 11
0
votes
0
answers
19
views
Google is asking for a cell phone number [closed]
My father tried to sign in to his Google account today. After entering the verification code he received from an email sent by Google, he was "asked" to add a cell phone number in order to ...
- 44.6k
0
votes
0
answers
17
views
Secondary channels url
In the YouTube app, a channel's page has a number of tabs
Home Videos Live Playlists Community
There seems to be a regression and the Channels tab has disappeared.
Can someone give me the url to this,...
- 44.6k
0
votes
2
answers
26
views
I need to extract strings from a cell in google sheets.. I'm trying to use the rexectextrac function, but strings are separated with ""
This is an example of the information i get when reading a QR
{"ver":1,"date":"2021-07-07","name":123456,"line":12)}
What I need to extract is
2021-...
CommunityBot
- 1
-1
votes
1
answer
56
views
Choose an employee and show the days where he has a specific shift code , along with the employees with the same shift
For convenience,
Let's assume we have a shift schedule of a week.
Header has the days from Monday to Sunday, and the 1st column contains the names of the employees.
Names
Monday
Tuesday
Wednesday
...
0
votes
2
answers
26
views
Identify first appearance of data in an unsorted list in Google Sheets
I have a funky lookup situation, consider this example data
Kris | Apr-2022 | ? |
Kris | May-2023 | ? |
Kris | Jun-2023 | ? |
Pat | May-2023 | ? |
Pat | Jun-2022 | ? ...
- 3,306
2
votes
1
answer
84
views
View a tweet in the context of a user's feed
Recently I came across a tweet from around a year ago and wanted to know what that user was tweeting before and after that particular tweet. I was surprised to find that there doesn't seem to be any ...
CommunityBot
- 1
1
vote
2
answers
1k
views
How to get past Discord's "This is an unclaimed account"?
There are so many times I have use a Discord channel, but next time I went to some website and click on that same Discord icon again, it says
This is an unclaimed account. Claim it before it's lost [...
- 99
0
votes
2
answers
738
views
How to export CSV without commas in unpopulated cells?
I have a form converter which simply rearranges columns. I use a script to paste Values only into another sheet for export and uploading onto another website.
However, when I go to export, it seems ...
CommunityBot
- 1
1
vote
1
answer
14
views
Trigger script to share calender with new user whenever form updates sheet with a new email address
I have a Google form that allows people to submit their name and email address in order to sign up for a private shared calendar.
The form populates a Google sheet.
I want to automatically add new ...
- 3,306
0
votes
1
answer
127
views
Sorting multiple columns using formula
Give a sequence of columns, I want to sort each column individually using formula because of some reason.
Eg.
A
B
C
D
4
7
2
5
1
8
1
3
9
3
4
7
4
Expected output
A
B
C
D
1
7
1
3
4
7
2
4
8
...
CommunityBot
- 1
0
votes
2
answers
67
views
Looking for a simple way to announce attendance
My ask:
Is there any existing solution, or maybe a clever way of using Microsoft Office 365 to announce your intention to attend at a certain date?
Components / requirements:
Calendar, covering ...
- 201
3
votes
1
answer
2k
views
Is the Craigslist e-mail relay service anonymous?
I posted a gig on Craigslist and want to ensure my anonymity during an e-mail exchange.
When replying to [email protected], where foo is a fairly long alphanumeric string, are both e-mail ...
- 569
0
votes
0
answers
9
views
Turn off "purple star" moments notifications on Twitter / X
On Twitter / X in 2023 I've started getting "purple star" notifications. I believe this is a notification for the "Moments" feature. They are basically algorithmic pushing of ...
- 569
-1
votes
2
answers
49
views
Formula that calculates the difference between numbers
I'm trying to create a formula that would be able to calculate the difference between the numbers and writes it exactly as shown in this image: https://i.postimg.cc/W4cZDgD2/image.png
Full Example: ...
- 3,306
0
votes
1
answer
406
views
How to insert a note in a cell that has a comment in Google Sheets?
When I go to "Insert note" into a cell that has a comment, the popup for the note either isn't shown, or it's shown briefly and disappears. The comment seems to be blocking it.
I tried both:...
CommunityBot
- 1
-2
votes
1
answer
110
views
Create a dropdown list that only shows items marked as unused! [closed]
I created a table with the list of clients and the licenses they use in different apps, themes, scripts. And these registered licenses appear in a dropdown list so that I can select, but I would like ...
- 44.6k
-1
votes
0
answers
25
views
Comprehensive list of upstream text-to-speech cloud providers [closed]
I am looking for a comprehensive list of text-to-speech cloud providers, for example:
Google text-to-speech
Amazon Polly
Microsoft Cognitive Services
IBM Watson
murf.ai (maybe)
These are "...
- 151
1
vote
1
answer
2k
views
How do you interpolate data in a horizontal range that's non-linear?
I've been told what I'm hoping to do is called 'spline interpolation'.
I've imported monthly youtube channel viewership figures from google API. And I've layed out the dates and views in a horizontal ...
CommunityBot
- 1
1
vote
0
answers
24
views
Print out a governmental form that spans over few webforms [closed]
I would like to print an online filled forms such as form 5669 (and few other, smaller forms) at Immigration Canada permanent resident portal . It can help validate them, form 5669, for instance ...
- 117
1
vote
2
answers
192
views
Query formula to add a column in Month/Year format from existing date values
I have a data set where 1 of the columns contains dates in "YYYY-MM-DD" format. I'd like to use a single query formula to select some columns from that data set, including the date column. ...
CommunityBot
- 1
0
votes
0
answers
6
views
Facebook sent my link to get back on Facebook in Chinese [closed]
Facebook blocked me out of my account. Sent all needed identification for resetting my account, but, the email they sent to log back in is in Chinese, or a language I can’t read.
- 1
0
votes
1
answer
34
views
Pulling all data from a column
tl:dr - I have a code that can work but want to make it better by pulling everything from column E into 1 message (including header)
I am trying to get the output of a singular column to post to ...
CommunityBot
- 1
0
votes
0
answers
11
views
Unable to minify CSS [closed]
I'm currently encountering a challenging issue with my WordPress website that I'm hoping to get some assistance with. The core of the problem lies in my inability to successfully minify the CSS files, ...
1
vote
1
answer
23
views
Countifs in between ranges
I'm struggling to pull below conditions together. I'd like to have a formula that will count values between 1 and 5 only when cell U13 contains the text 1-5.
=COUNTIFS(U13,"1-5")
=COUNTIFS(K2:K22,"&...
CommunityBot
- 1