All Questions

Filter by
Sorted by
Tagged with
0 votes
0 answers
3 views

I am tying to build a multi-dynamic GOOGLE sheet query and have included a sample sheet

I have been working on this for HOURS and can't seem to figure out the piece I am missing. Basically I have a sheet that I have built that has 8 tabs of representatives of 8 different companies and, ...
Michael Peterson's user avatar
0 votes
0 answers
5 views

How to prevent ChatGPT web interface from censoring the links?

Sometimes, ChatGPT provides me with links to external sources. I can see the URL briefly when the answer is generated, but then, links in the response are not functional. The URL is stripped and the ...
Fido's user avatar
  • 121
0 votes
1 answer
5 views

How to write a formula returning from specific

Good day to everybody. I am working on a Google Sheet. Here I have a somewhat non standard table. To cut it short, I was able to designate "1" in column A for each row that fulfills my ...
Michael's user avatar
0 votes
1 answer
9 views

Reformat a Google Sheet based on Data in Column A

I'm trying to work out if there's a way to reformat a sheet, so that the name data relating to a specific order number in Column A, is put into a single row (so that I can perform a subsequent data-...
Dan Rye's user avatar
0 votes
0 answers
3 views

Mautic Changes URLs [migrated]

We’ve encountered a significant issue with Mautic: it changes the URLs of our links when sending campaigns. This results in losing backlink traceability and the backlinks themselves, as they are not ...
Clara Bonnet's user avatar
0 votes
1 answer
14 views

Why is gmail showing multiple email aliases to recipients?

I've just set up a new business email through gmail at a custom domain. The primary account name is [email protected]. I added two aliases: [email protected] and [email protected]. ...
temporary_user_name's user avatar
0 votes
0 answers
11 views

Google apps refuse to open as PWAs or windowed shortcuts in chrome [closed]

I'd really like certain google apps (drive, sheets, docs, mail) to open in their own dedicated windows instead of browser tabs. With Chrome PWAs, this should be possible. But when I try to go the ...
Empiromancer's user avatar
0 votes
0 answers
5 views

Can the Lookup_range and result_range of an X-Lookup refer to a column name (column_name) instead of the column range(A:A)? [migrated]

hoping an excel wizard see's this and can help me. I want to do an Xlookup[XLOOKUP(search_key, lookup_range, result_range)] but instead of defining the lookup_range and result_range as 'A:A' for ...
Charlie Collins's user avatar
0 votes
1 answer
4 views

Where can I see if a venue on OpenReview is configured to make paper submissions public during the review process?

Where can I see if a venue on OpenReview is configured to make paper submissions public during the review process? I have access to the Program Chairs Console. I looked at the Full Venue Configuration ...
Franck Dernoncourt's user avatar
-1 votes
0 answers
8 views

How to Customize Google Document Outline

Google document outlines - there are a couple of format customizations I would like to be able to add to the format of the document outline to draw the user's eye to certain things and make it easier ...
Suzanne Vogt's user avatar
0 votes
1 answer
12 views

Apply conditional formatting when the value in a row increases or decreases

I am trying to apply conditional formatting to a range of data, but not able to find a solution for it. I am trying to do two types of formatting. When a value in a row is less than the value in the ...
Ramya's user avatar
  • 5
0 votes
0 answers
8 views

I am trying to access espncricinfo.com and it doesn't appear to load correctly [closed]

I am trying to access espncricinfo.com and it doesn't appear to load correctly on my machine. This happens on Chrome and Edge as well. I tried in Incognito and Inprivate browsers as well, same issue. ...
Mohamed Kaamraan Swati's user avatar
0 votes
1 answer
8 views

Automating conversion to absolute values in Google Sheets [closed]

I'd like to convert a column of cells from relative references to absolute (eg. K2:K8 to $K$2:$K$8) on MacOS using Firefox. fn + F4 does nothing, while fn + 4 replaces the formula with the number 4. ...
WhooNo's user avatar
  • 101
0 votes
1 answer
15 views

How to search Google Tasks

The problem is that there doesn't appear to be a search option for tasks. This was originally asked here - https://support.google.com/calendar/thread/220012593?hl=en - but the question has been closed ...
AndyS's user avatar
  • 101
0 votes
0 answers
5 views

Hide a specific label from appearing on the Blogger homepage

I want to hide specific labels from the homepage, so I replaced this code: <b:include data='post' name='post'/> with this code: <b:loop values='data:posts' var='post'> <b:if cond='...
Amgad Nagy's user avatar
0 votes
0 answers
3 views

How do I stop meetup prompting me for feedback after every event?

After I attend an event on meetup.com, when I next visit the site it will prompt me with a modal that demands I give feedback. It asks 'Have you attended this event?', if you click 'yes' then it ...
thran's user avatar
  • 1
0 votes
1 answer
13 views

How to pull all the data on the "right" of a column with certain value in the header

I am trying to pull out certain columns of information from a autogenerated report for further analysis. I will need to only pull certain columns based on the header values. Here is the link to the ...
Ramya's user avatar
  • 5
0 votes
1 answer
12 views

Checking to see if a number falls within a range

I have a Google sheet that has two tabs and I am trying to build something that takes column B from the Sheet2 tab and cross-references Sheet 1 and highlights or lists on Sheet2 the ones that fall in ...
NateM's user avatar
  • 13
0 votes
0 answers
13 views

Insert clickable link within a line of text from another cell

So... i have a sheet keeping track of details for real estate properties. Of relevance here: Street Address Cross streets City And i have a MAP cell in which i've created a URL that links to a google ...
Robert Etropolsky's user avatar
0 votes
0 answers
6 views

can we have localhost alias in chrome? [migrated]

In Chrome, we can save common address and set keyboard shortcut ( what this thing actually called ?) but when try to set alias of localhost like if we type lh TAB 3000 then it open http://localhost:...
xkeshav's user avatar
  • 351
0 votes
1 answer
25 views

Google Sheets: Return a list of names if a column in the same row is empty

I have the following values in Sheet A: A B 1 Josh Awarded XP 2 Jane (blank) 3 Peter (blank) 4 Mary (blank) 5 Josh (blank) 6 Peter (blank) I want to reflect the above ...
Qiao Hui Quek's user avatar
0 votes
0 answers
9 views

What does the star symbol next to "DMs" mean when searching in Slack?

What does the star symbol next to "DMs" mean when searching in Slack? Example:
Franck Dernoncourt's user avatar
0 votes
0 answers
8 views

Let & Query to combine sorted count of frequency from two columns of data and format correctly before from TEXT JOIN

Data Location: Google Sheets with two columns where date/time in one and dollar values in the 2nd. Goal is to group the entire dataset into specific ranges then identify the number of times of ...
RTG's user avatar
  • 33
0 votes
0 answers
7 views

Remove building name from Google Maps

There is a building name on Google Maps which I need to change. The actual school has moved and the PIN location is also updated but still "Olives School" still appears on Google Maps and ...
M. Ahmad Zafar's user avatar
0 votes
0 answers
14 views

Why is email I send to Gmail is not being received?

When I send an email to a Gmail contact, it does not arrive. I know there are specific domain records for authentication. I've used cPanel to check email deliverability and it reports that the ...
blearyeye's user avatar
  • 421
0 votes
0 answers
11 views

How to add "Subscribe" just underneath and in the description of a video in Youtube?

Youtube offers many ways to give users who watch a video a hint to join the channel. The ones that I know how to set up are: As an icon on an end screen As a link in the video description As an icon ...
ThomasJr's user avatar
0 votes
0 answers
15 views

Google Sheets formula based on cell contents being bold

Is there a way to write a formula to do a lookup in another sheet to see if a cell is bolded? Additional context: I am creating a fantasy football schedule. I'm trying to write either "vs" ...
user avatar
-1 votes
0 answers
10 views

Merge data from two Sheets into one table

How would I merge the data from two tables based on matching the date and country columns? Not all dates/country combinations will exist in both tables. Sheet 1: Revenue A B C 1 Date Country Revenue ...
Antonio Lambiase's user avatar
0 votes
0 answers
9 views

Move subset of videos from one playlist to another

Many videos show how to add all videos in one playlist to another. I want to move a subset of videos from one playlist to another. If try to do this by adding all videos from one playlist to another,...
user2153235's user avatar
0 votes
1 answer
13 views

When does a repo on anonymous.4open.science expire?

I read on https://anonymous.4open.science/faq#data: When a repository is removed or expired only the configuration of the repository is conserved to be able to restore easily the repository and to ...
Franck Dernoncourt's user avatar
0 votes
0 answers
9 views

How can I perform a Google search for an exact match of a line of code containing a question mark?

A comment on an GitHub repository issue has a code block that contains on line 13: get => _items.Value == null ? _items.Value = ImmutableDictionary<string, object>.Empty : _items.Value; When ...
Aka's user avatar
  • 1
-1 votes
0 answers
21 views

Gmail Spam Filter settings

I'm fighting a spam mail sender for more than 3 months. I receive every day the last 3 months nasty sexual messages to my Gmail account. First of all I think it's a huge shame that after 3 month Gmail ...
amadou's user avatar
  • 1
0 votes
0 answers
2 views

Lastpass: binary extension can't be installed [migrated]

I was using Lastpass for years. During past few weeks, I can't get binary extension work on Chrome. Details/facts OS: Windows 11 Chrome: 126.0.6478.127 LastPass extension: 4.131.4 I tried everything:...
Daniel's user avatar
  • 101
-1 votes
0 answers
9 views

Send custom automatic email to Google Form respondents on a specific date [duplicate]

I have a Google Form that collects bookings for a number of events. The responses sheet (Sheet 1) contains, amongst other data: a column with the event being booked for The name of the person Email ...
To Do's user avatar
  • 141
-1 votes
0 answers
12 views

Send partial contents of Google Sheets to email on a specific date

I have a Google Form that collects bookings for a number of events. The responses sheet (Sheet 1) contains, amongst other data, a column with the event being booked for. I have added another sheet (...
To Do's user avatar
  • 141
0 votes
2 answers
10 views

Nested IF formula not working

I am trying to write a nested IF formula in Google Sheets. =IF(F5=1,"10", IF(F5=2, "15", IF(F5=3, "35", IF(F5=4, "60", IF(F5=5, "120", "Missing ...
Mandarc's user avatar
  • 11
-1 votes
0 answers
18 views

How can I add "settings" or custom properties to Google Sheets? [closed]

Is there a way for me to add custom key-value properties to a Google Sheet without resorting to creating a different "settings" sheet? I'm using Apps Script and prefer not creating custom ...
Bharel's user avatar
  • 109
-2 votes
2 answers
46 views

Nested Array and Filter Sorting formula to combine and aggregate into most frequent list

Working on formating a sheet where I need to pull normalized data into an analytics page. The criteria is to pull from one tab to the next. Get data using B & E and then apply the values to preset ...
RTG's user avatar
  • 33
0 votes
1 answer
7 views

Formula to multiply a value by a factor that is based on the word found in another column

I would like a Google Sheets formula in column C that checks what word is in column A and then multiplies the value in column B by a factor selected based on the matched word. For example, if the ...
Carl Coombs's user avatar
0 votes
0 answers
12 views

Chrome takes up unproportioned memory in web app [closed]

I have a web app I am developing using Angular 14, and I've had windows task manager open while I was using it. I've noticed the memory that chrome is using is somewhere around 1.5GB (with only my app'...
Eric Krief's user avatar
0 votes
0 answers
19 views

What are current web application development trends? [closed]

What are the current web application development trends?
Sdreatech's user avatar
0 votes
0 answers
7 views

Outlook web show time also

I can't find setting on Outlook web that allows me to change how to display dates and times in the "received" column. There are only 3 columns: "From", "Subject" and &...
user avatar
1 vote
0 answers
11 views

Is there any way to recover deleted membership requests or a workaround to inform those who applied to reapply?

I'm the admin of a Facebook group, and I've accidentally deleted around 2000 membership requests. Is there any way to recover these requests or a workaround to inform those who applied to reapply?
Daniele Rossi's user avatar
0 votes
0 answers
17 views

Two-way sync? Updates to linked Sheets range update values in linked Docs table, but can changes to Docs table also update Sheets range?

I have a Google Sheets spreadsheet with cells linked to a Google Docs document. If I update the spreadsheet's linked cells, they update in the Google Doc as well. Is there any way to have it work in ...
Sharie Sprague's user avatar
0 votes
0 answers
18 views

Facebook Professional Mode post sharing issue

I’m having trouble with Facebook's Professional Mode. When I create a post with text, a photo, and a video, everything looks fine. But when the post is shared, only the video appears. The text and ...
Thanos's user avatar
  • 1
2 votes
2 answers
20 views

Conditional format rule highlighting the wrong cells

I have a problem with a simple conditional format rule in Google Sheets. I want to color the cells in range M5:M90 whose values are greater than or equal to the value in cell M2. I thought it was ...
hubertwah's user avatar
0 votes
0 answers
11 views

Sync Google Cloud Directory users to AD [migrated]

Is there a way to sync Google Directory users to Active Directory (on-prem or extra ID) so that they can log in to domain-joined PCs? It appears to me that GCDS only synchronizes users from AD to ...
Teemo22's user avatar
0 votes
1 answer
75 views

How Google Sheets' new Conditional Notifications' alerts look like and why are they lost?

I realize it's a new service, but its single purpose in life is to send e-mail messages, so why am I not getting them? While the help center claims "Tip: Email notifications may not be immediate&...
LWC's user avatar
  • 1,240
-1 votes
0 answers
14 views

How connected are Google brand accounts to their original owners?

Let’s say I transfer the ownership of an Google brand account to another person (a YouTube channel). You make them the primary owner and you remove yourself from it, making it look like you never made ...
TimeFlyVy's user avatar
0 votes
1 answer
15 views

Delete duplicates based on date (google sheets)

Essentially, Column G is a object Column V was the date that the object was sold on Sometimes the object was sold numerous times, so lets say object X was sold in 2003, 2010 and 2013. I want to delete ...
user avatar

15 30 50 per page
1
2 3 4 5
686