All Questions
33,000
questions
0
votes
0
answers
16
views
How to enable "LinkedIn ID" property on Hubspot CRM?
Note: This question is about the Hubspot web app. The API information is only used to show that the property in question exists in the app. It is not a question about the API.
How can one access / ...
0
votes
1
answer
10
views
How are channels sorted in a section in Slack?
It says alphabetically:
However, it's not 100% alphabetically:
How are channels sorted in a section in Slack?
0
votes
0
answers
13
views
Is it possible to delete a file from GitHub and also erase all evidence of its existence
Is it possible to delete a file from github.com and also erase all evidence that it ever existed?
When I click on history, I can see all modifications of the GitHub project, including deletion of ...
0
votes
0
answers
3
views
blog page only shows the url site.com/blog Help me pls [migrated]
I have a website and the blog page only shows the url site.com/blog and not site.com/how-make-a-content-to-mobile.
How do I make the full link appear in google searches? and not just /blog... it's a ...
0
votes
1
answer
25
views
Google Sheets I need the column sums() of a table produced by a query()
I have a query() that outputs a table with two columns (A and B) of numbers. Pictured in IMAGE #1.
=QUERY(myData!A:G, "Select E,F WHERE D ='Books'")
IMAGE #1
But I need a function that ...
0
votes
0
answers
17
views
How to recolor all cells based on the original color of the cell in Google Sheets?
I'm looking to recolor cells in a Sheets document I have, simply based on the original color that the cell already has. This is regardless of the contents of the cell and doesn't follow a traditional ...
0
votes
0
answers
3
views
Google Meets events added in Google Calendar and not via e-mail
My Google account is me@mydomain.com, but my e-mail service for mydomain.com domain is based on Microsoft 365 and not Google Apps.
This is causing that every Google Meet events created by anyone are ...
2
votes
1
answer
21
views
Show sorted elements based on priority
can you please help?
I would like to autopopulate column C with values in column B sorted by the priority in column A.
Column A: Project names manually ordered by priority. Most important in top.
...
2
votes
1
answer
65
views
Google Sheets | get capacity from title and move to next column
in Google Sheet I have title example:
Babaria Exotic Bronze Tanning Jelly Spf0 Coconut 300ml
From this I need get 300ml and move to the next column
result: column1: Babaria Exotic Bronze Tanning ...
1
vote
1
answer
27
views
Googlefinance function - What ticker symbol to use for the crude oil price?
Which ticker symbol can I use for the crude oil price for the GOOGLEFINANCE function?
Nasdaq Brent oil is "BZ:NMX"
https://www.nasdaq.com/market-activity/commodities/bz:nmx
Nasdaq Crude oil ...
0
votes
0
answers
12
views
Any way to order Google search results by recency with descending date order?
As an example, I'll use "laughing cats" as the search term for "site:youtube.com". I'd like to sort or "order" the results by descending date (oldest to newest).
Here's ...
0
votes
1
answer
7
views
How to specify a price range for movies on Amazon Prime Video?
Amazon Prime Video has some categories you can browse by price (e.g. "$4.99 or less", "$9.99 or less"). Sometimes when searching Amazon at large, you can specify both a minimum and ...
1
vote
1
answer
25
views
Google Sheets Filter function w/ other function
I have two columns of data, one with names (A7:A), and one with percentages (B7:B).
I am trying to use the filter function to show me the names of results with non-zero percentages. I also want to ...
0
votes
1
answer
24
views
I need to perform the same function for each row in my spreadsheet. I have 30 rows in total
I am attempting to calculate and store the number of days absent for my employees - I can do it for one row (employee) but I have thirty employees:
function updateDaysAbsent() {
var ss = ...
0
votes
1
answer
26
views
Can you recover deleted posts in Facebook Meta Business Page
I have just deleted a post accidently. How can I recover it or is it gone?
0
votes
0
answers
4
views
GA csv report and interface contain different users count data
We've implemented Google Analytics in app and I'm using csv reports to process events data.
I've noticed strange thing: users count in GA interface event report differs from users count in events ...
-1
votes
0
answers
9
views
Coursera certificates for students?
I heard that we can get one free certificate with university email. Is it still right? If so how can we get i t? I really confused about their website. some of the courses are prescription based. Some ...
1
vote
1
answer
32
views
Organizing hierarchies in Google Sheets
I am currently using Google Sheets to organize and update the keywords I use in Adobe Lightroom (Photo organizing software) I'm trying to organize my keywords into hierarchies to make it easier to ...
0
votes
1
answer
13
views
How to get a notification when a column in google spreedsheets changes
I need help with a code.
I need to get a notification on my email or Slack when for example, column D changes. But I would love to received what column changed.
Here is what I got right now.
function ...
0
votes
1
answer
39
views
Google sheets - search a cell for multiple partial words and return different value for each partial word
I am trying to put a formula together that will look at a cell and return a value based on a partial word, but to do it with multiple criteria. For example:
If A1 has the following in it:
Type of ...
0
votes
0
answers
11
views
Twitter desktop vs Twitter mobile app
I was looking at my twitter feed, i.e., the home icon, and noticed many missing tweets on the desktop version compared to the mobile app version. Is that normal? Is there a setting to align the ...
0
votes
0
answers
7
views
twitter card validator - there is no error message but the image is missing [closed]
below is the image I'm getting when trying to validate my card on https://cards-dev.twitter.com/validator
so there is no error message, but my og:img is missing
the same I'm getting on twitter ...
0
votes
0
answers
19
views
SUMIFS with multiple criteria in multiple columns
I'm trying to take attendance using a SUMIFs formula, but based on data in two columns. For example, I want to total the occurrence of initials "MD" in a range of columns, but only if the ...
0
votes
0
answers
22
views
IMPORT RANGE PARSE ERROR
I have this arrayformula where I need to match cells in a column from one worksheet to another and I used Importrange to link these two but it's giving me errors and I'm not sure what i'm missing
here ...
-2
votes
1
answer
17
views
Google Sheets Import XML
I'm trying to import the price from this products website: https://www.mobilesentrix.com/lcd-assembly-with-steel-plate-pre-installed-replacement-for-iphone-xr-aftermarket-aq7
But struggling to use the ...
0
votes
0
answers
24
views
Google Sheets - Autosort Script issues
I am trying to sort data descending based upon column B (2) which has different numbers in each cell. EG: B8 = 99, B14 = 70, etc. I'm intending for it to autosort and do it onEdit. I'm not good at ...
0
votes
1
answer
14
views
Make ARRAYFORMULA cover the entire column?
This causes he headaches every time I use ArrayFormulas in Sheets. It seems that you have to specify the exact length of the range, and can't just use for example X2:X like you can in any other range ...
0
votes
0
answers
3
views
Chrome passwords for equivalent domains [migrated]
Is there a way to tell the Chrome password manager that websites https://a.b.c and https://d.e.f are in fact equivalent and use the same login credentials, so that when I change my password in website ...
0
votes
0
answers
4
views
Is it possible to change Google Chrome's previous/next tabs shortcut (⌘+Option+← and ⌘+Option+→) to ⌘+Shift+← and ⌘+Shift+→ instead? [migrated]
I use both Safari and Chrome (for different purposes) and bounce between them quite often.
In Safari, the shortcut to go to the previous/next tab is ⌘+Shift+← and ⌘+Shift+→. I'm quite used to this to ...
0
votes
0
answers
12
views
Does switching to a non-company Gmail account in the same browser mean you won't be tracked?
Let's say you're on your own personal computer that has been scanned by a third party security professional and doesn't have any kind of spyware. If you log in to Google Chrome with your personal ...
0
votes
0
answers
5
views
Why is YouTube so incredibly bad at deciding where to insert ads?
I don't watch very much on YouTube, but I do watch late-night shows now and then (mainly Stephen Colbert).
YouTube does an incredibly bad job of deciding where to insert mid-show ads. It appears that ...
0
votes
1
answer
32
views
Is there a way to create a list of values from a certain column based on referenced criteria in two rows?
I'm trying to find a formula that will fill in two columns with data from another sheet based on values from a dropdown that correspond to header rows from the original dataset.
I have Sheet1 that ...
0
votes
1
answer
35
views
Hiding columns based on date
Pretty new to scripts.
I have a sheet with name information in columns A-C and dates from column D on.
I found a script that will hide all columns to the left of the column with the current date.
I ...
0
votes
1
answer
21
views
Custom phone number format with accepting 8 or 9 digits Google Sheets
I want to format a cell to properly display phone numbers, but the number of accepted digits are 8 or 9. It is ok displaying 8 digits with this number format "387" ## ### ### and looks like &...
1
vote
0
answers
21
views
Google Sheets: how to bring drawing to top / bottom
I found workarounds for images by cutting an image and paste it again (so that would be the same to set on top).
And playing with right click, image options, image wrapping may help as well
But with ...
0
votes
0
answers
3
views
Material icons not rendering properly in Chrome when local font is installed [migrated]
I'm using latest stable version of Google Chrome on ubuntu 16:04. I needed to use some of the local sites which use Kannada fonts. Installed the required fonts from here https://chrome.google.com/...
0
votes
0
answers
8
views
Sum by Date but Ignore Timestamp
I am trying to auto sum day by day as data is automatically added to the sheets doc via Google Forms but keep getting errors and I think the time stamps are throwing the calculation off, so I'm trying ...
0
votes
0
answers
11
views
YouTube looks different after login to youtube account [closed]
In Windows 10 & Firefox 101.0 youtube is like below before login to youtube account :
After login to my account in youtube it looks like this :
I checked it with another account - same problem.
...
0
votes
0
answers
4
views
How to organize orders in table [migrated]
I am new in the world of Excel so please advise.
I have a table like this, the vertical axis is a date, and the horizontal axis is the order numbers and the number of items in each. Orders have ...
0
votes
0
answers
14
views
How to get the RSS feed for a given Twitter user's posts without paying money?
First of all, Twitter has engineered their website to make it impossible (for me, and most) to extract any data from it. It fetches everything with JavaScript as massive JSON blobs and using all kinds ...
0
votes
0
answers
26
views
Create a pop up window script for Google Sheets as a password
I have created a sign in/out sheet for students within my building. Students will type their name in column A, click a checkbox as a timestamp when leaving and entering and a dropdown for where they ...
0
votes
1
answer
25
views
Prevent people from modifying other people's rows with Google Sheets
I want to share a public URL to a Google Sheet with many people (potentially 1000 people or more), with edition permission.
I would like that anyone with the share link can add their own rows and ...
0
votes
0
answers
12
views
Footer is showing up multiple times on Google Group emails
We are using a free Google Group and for some reason, the footer is showing up three times on messages. We're just using the generic pre-created footer (To unsubscribe from this group, send email to X@...
-1
votes
1
answer
12
views
How can I see which Slack channel(s) myself and another Slack user are both a member of?
I wonder how I can see which Slack channel(s) myself and another Slack user in my workspace are both a member of.
0
votes
0
answers
30
views
How to get a column value repeated to all related rows of a data table?
The table has EXPIRY date column, and it does not repeat on all rows:
This is a Option price table for MSFT(Microsoft), the data table is sorted by Expiry date on sheet 'BACKEND'.So, when I fetch via ...
1
vote
1
answer
24
views
I CTRL-clicked an email yesterday from my Gmail, today it would NOT load
I have a rather frustrating situation with my Gmail and maybe I'm just too dumb to figure out what to do. So while checking my emails one by one, there were emails that I "control-clicked" ...
0
votes
0
answers
14
views
VLookup multiple items into one cell
In Google Sheets, I have a Vlookup working for a column with the thing I'm looking for, then two columns in a different sheet with sheetname! where it looks for the thing I'm looking for and gives me ...
0
votes
1
answer
14
views
Can anybody please help me create a Query function to extract data from rows to columns (ignoring zero data) and using a drop-down box
I have only started to learn Google Sheets instead of Excel. I find it easier to understand if I have a problem to solve but the Query function quite difficult to understand.
I have table of fruit ...
0
votes
0
answers
8
views
Download single file from publicly shared Google Drive folder without zipping
I'm looking at PDF files in a publicly shared Google Drive folder and I want to download one of the files. I want to download the PDF file only. I do not want to download a .zip file containing the ...
0
votes
1
answer
36
views
Need a Unique ID to be populated in Google sheets on Google Form submission
Looking for a dynamic unique ID for Google Forms, to populate into Google Sheets Response form. I don't want to use external addons.
Below is a code I found online but can't get it to work - I'm a ...