All Questions

Filter by
Sorted by
Tagged with
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 / ...
user avatar
  • 109
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?
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
  • 2,779
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 ...
user avatar
  • 1
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 ...
user avatar
  • 101
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. ...
user avatar
  • 23
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 ...
user avatar
  • 123
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 121
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 ...
user avatar
  • 11
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 = ...
user avatar
  • 1
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?
user avatar
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 ...
user avatar
-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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 101
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 ...
user avatar
  • 3
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 ...
user avatar
  • 1
-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 ...
user avatar
  • 1
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 ...
user avatar
  • 1
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 ...
user avatar
  • 999
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 ...
user avatar
  • 101
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 ...
user avatar
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 ...
user avatar
  • 97
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 3
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 &...
user avatar
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 ...
user avatar
  • 345
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/...
user avatar
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 ...
user avatar
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. ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
  • 407
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@...
user avatar
  • 101
-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.
user avatar
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 ...
user avatar
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" ...
user avatar
  • 11
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 250
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 ...
user avatar

15 30 50 per page