All Questions
33,748
questions
-1
votes
1
answer
7
views
Highlight cells between two numbers using conditional formatting
How can I apply conditional formatting in Google Sheets that will highlight cells with values between 50 and 100? The built-in options aren't quite cutting it.
Is there a custom formula that I can use?...
Darrell Campbell
0
votes
0
answers
5
views
can we set specific branch to clone when someone form our repo?
I want to give acess to my collegue and ask to fork my repo but it fork the complete repo ( which is what fork is) and it clone the default branch, main ( assuming I havnt changed default branch)
So ...
- 351
2
votes
0
answers
6
views
How can I undo Gmail's "always display images" setting for multiple senders at once?
I have the Images option in Gmail Settings > General set to "Ask before displaying external images".
Over many years I have enabled the option to "Always display images from <...
- 21
0
votes
0
answers
5
views
Bandcamp looper in Firefox? [closed]
It seems in browser Bandcamp removed the looping ability. Is there a Firefox extension to get it back?
- 401
0
votes
0
answers
8
views
Partial YouTube looper in Firefox? [migrated]
Is there a Firefox extension which does what this Chrome extension does (official looper can only loop full video):
- 401
0
votes
0
answers
32
views
Is there a cell formula or macro that I can use to reorganize data on subsequent rows and transpose it to subsequent columns?
I have a large spreadsheet (~1500 rows) that I am trying to manipulate the format of. I have created an example of what my data looks like and shown it here in the first image. I would like it to be ...
- 9
0
votes
0
answers
12
views
How to recover deleted Imgur images? [closed]
I uploaded some art (which included some nudity) to an Imgur album without actually posting it publicly, and Imgur deleted the entire album. I went to images to see if I could recover the photos at ...
- 121
0
votes
1
answer
13
views
Determine if onEdit() was triggered by inserting or removing a row
I have two spreadsheets, SS1 and SS2.
I need to update SS2 when a row is inserted into or removed from SS1, or when a certain range of cells is changed in SS1.
I use an installed onChange() trigger to ...
- 123
-1
votes
1
answer
28
views
I need to equalize a text phrase with a numeric value
So what I need is to make a neat-looking salary-counting spreadsheet, which doesn't show the numeric value in its cells but instead text values. To be specific, my case is I'm a teacher and I have ...
0
votes
0
answers
10
views
Is there a way to bring back the Reels tab?
A few days ago, next to my Videos tab I had the reels tab, there, I could find any reel I uploaded to my Facebook page. Now the Reels tab is gone,
is it possible somehow to bring it back by changing ...
- 474
1
vote
1
answer
15
views
The site groups.google.com does not list any groups I am a member of, on Google Workspace
Issue
While I'm logged in to google.com with my Workspace account, where my account belongs to multiple groups (verified as an admin on admin.google.com/u/3/ac/groups), I do not see any of those ...
- 131
0
votes
1
answer
11
views
How can one find all the contracts invoiced against a given purchase order in Upwork Enterprise?
I'm using several purchase orders with Upwork Enterprise. I have invoiced several contracts against each of these purchase orders. How can I find all the contracts invoiced against a given purchase ...
- 17.3k
0
votes
0
answers
21
views
1
vote
0
answers
2
views
See who looks at my group posts [closed]
I could see who looked at my fb group posts yesterday, but cannot today. My group has less than 250 members. Help!
- 11
0
votes
0
answers
10
views
How does privacy / permissions work on a family tree site like FamilySearch.com? [closed]
I saw this privacy doc, which suggests that as a user when I create links in the family tree, they are private to only to that user, and others can't see them. But the lines get blurry when a person ...
- 257
-1
votes
0
answers
13
views
How to avoide switch as the street name and house number have switched places in Gmail account?
As this might be a localization issue as In EU it is usually to put the house number after the street name. But where is a setting to modify SWITCH?
user447320
0
votes
0
answers
10
views
How to embed a Github repo/README/Project into a Confluence Page?
We currently have a Github Project where we're maintaining a list of work in a backlog that we'd like to be able to embed and share through a Confluence page (Atlassian). I tried embedding the page as ...
- 109
2
votes
1
answer
16
views
Is there a way to restrict access to paid subscriptions shared to my Family Group for specific members using Family Link?
I am the manager of a Google Family Group of 4 members.
I have separate paid subscriptions to Google One and YouTube Premium.
I want to share both subscriptions with my Family Group but control which ...
- 23
1
vote
1
answer
25
views
Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col1
I have a Google Sheet, that I am using as a tracker for a game. This was not written by me, just passed down, and I am having a hard time trying to decipher the issue here. As per the title of the ...
- 11
0
votes
1
answer
23
views
How do i utilize IF functions (or others) in order to create a simple username/password in google sheets?
On cell A3, there is a username input (i.e max or dave), on cell B3, there is a pin input (i.e 1234 if its max, or 8640 if its dave), how would you go about creating a formula in order to satisfy ...
1
vote
0
answers
7
views
I am making a magento web extension for cache warming of site urls [closed]
Here is my PageTypes class in which I want to get all the full action names of the magento routes just like hard coded array below in getAllOptions() function.
<?php
namespace FME\CacheWarmer\...
- 11
0
votes
0
answers
32
views
Why am I being blocked from using the Google Analytics Add-on In Google Sheets?
I'm trying to add the Google Analytics Add-on from within a Google Sheet. However, I'm being blocked. Here are the steps I'm taking:
Click "Extensions",
Hover over "Add-Ons",
...
liv.marx
2
votes
1
answer
18
views
Is it possible to have a pivot table automatically incorporate newly added 'Filter by' values or show the current values?
I've made a test sheet here (https://docs.google.com/spreadsheets/d/17l49Rn3ZbNx-upzBtmRtsJBHQiCKXuYPs8SMTyrcw9k/edit#gid=0)
You'll notice that the pivot table IS correctly pulling in ALL the data in ...
- 123
0
votes
0
answers
10
views
How to set default to track edits
In Google Docs: "Suggest" mode is the same as MS-Word's tracked changes.
When submitting a document for edits: How to set the edit mode to "Suggest", so as to ensure that the ...
- 403
0
votes
0
answers
6
views
Gmail app won't scroll beyond a few days of emails on Chromebook [migrated]
I'm trying to scroll back to an email from last week in the gmail app on my Chromebook and it just stops at a certain point and won't scroll back any farther. Has there been a new feature introduced ...
- 137
1
vote
1
answer
19
views
Script Failing to Finish - Protected Sheet
I've been using a timed trigger with this script to add new columns daily to a school-wide tracking sheet. Recently, I've been getting notifications that the script is failing on only one of the ...
1
vote
0
answers
18
views
Reenable to add me to a private Facebook group
I left a private Facebook group years ago with the option to prevent me from adding again to it. Now I would like to reenter that group but I can't and they can't add me again.
How can I lift this ...
- 111
-1
votes
0
answers
12
views
How can I set a Gmail filter that finds email sent "only to me"? Except Some Individual Email [closed]
I aim to set up an email filter wherein any incoming emails directed to me will be categorized under the label "personal_mail," with the exception of the two specified email addresses (no-...
1
vote
1
answer
10
views
Google sheets slider for a multi-valued cell
I have cells in Google sheets that have multiple values, such as:
Continent
Law
North America
Sarbanes Oxley, Freedom of Information Act
Europe
Digital Markets Act, Digital Services Act
By default,...
- 11
0
votes
0
answers
46
views
LinkedIn user (not me) with my updated email address: security risk? how to fix? [closed]
I do have access to my single, free, 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 ...
0
votes
0
answers
3
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 ...
0
votes
2
answers
28
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
-1
votes
0
answers
14
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 ...
0
votes
0
answers
24
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
0
votes
1
answer
27
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 ...
- 113
0
votes
0
answers
28
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 ...
- 101
0
votes
0
answers
25
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,...
- 101
0
votes
2
answers
29
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 | ? ...
- 123
1
vote
1
answer
17
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 ...
- 13
0
votes
0
answers
23
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
1
answer
59
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
...
- 21
0
votes
0
answers
8
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
0
answers
7
views
Gmail will not send my text [closed]
"To" field was not recognized. Please make sure that all addresses are properly formed. because I am emailing a phone number but I need to
- 1
0
votes
0
answers
28
views
Combine Google & Facebook Login on External Site [closed]
On a website hosting a community forum that offered Google and Facebook account logins, I logged in many years ago through Facebook to post a thread.
Sometime after, having forgotten the creation of ...
- 141
-1
votes
0
answers
17
views
Travel information: global website with time, prices, and availability, to be used by apps [closed]
There are several apps out there that deal with transportation.
My understanding is that currently each transportation provider must log into the web interface of any app and upload their information ...
1
vote
0
answers
25
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
2
votes
0
answers
10
views
Email provider that doesn't enforce SPF or DKIM [closed]
I'm looking for a web mail provider that doesn't enforce SPF or DKIM on incoming messages, or allows disabling that enforcement. Does one exist?
- 1,032
-2
votes
0
answers
26
views
Facebook - how do you link an existing page to a group?
In group settings for Facebook groups, at the end, in the Advanced settings section, there is an option to Link a page, but when I click it, it starts the guide to create a new page. I want to link an ...
- 675
0
votes
0
answers
11
views
Can a Facebook page create an event in a Facebook group the page admins?
Can a Facebook page create an event in a Facebook group the page admins? A regular user, that is also admin, can do it.
The page can also create events and publish it its (the page's) log, but such ...
- 675
-1
votes
2
answers
53
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: ...
- 1