All Questions

Filter by
Sorted by
Tagged with
5
votes
3answers
10k views

Is there a way to lock or protect conditional formatting in Google Sheets?

I have several columns that indicate the current state of a project task. When I complete some task (for example), I copy the "complete" text from some other cell and paste it in the new cell to avoid ...
0
votes
1answer
82 views

create a Telegram group through code

Is it possible to create, programmatically, a Telegram group (using my user Id)? I have a scenario where we want to deploy tool instances, per customer, and have the tool automatically create the ...
0
votes
1answer
84 views

How to send myself information from work without revealing my personal account

At work we heavily use Gmail and Drive, and there are some emails and files I would like to somehow store or send myself to store and remember at my personal account. However, I fear simply sending ...
0
votes
0answers
5 views

Google SpreadSheets query: how to join “grouped by” cells in a list?

Suppose I have this table: | Name | Amount | Category | | name_1 | 10 | A | | name_2 | 2 | B | | name_3 | 3 | B | | name_4 | 6 | C | Thanks to this ...
0
votes
0answers
2 views

How can i synchronize each audio file with each picture when clicking a picture

Hello everyone i want to make a type of memories quiz that you click it then the picture show up and you have to click the other picture that has the same image as well, below here is the how can i ...
0
votes
0answers
3 views

Where do you get templates for creating a unique project

I often need templates for my project. I do not like ready-made so I like to create them myself. To do this, I use one excellent site, where I can easily create the type of templates that I need, but ...
0
votes
2answers
328 views

How to calculate the average of values in Col. B, if Col. A contains a unique timevalue of Col. C?

This is how my table looks: (in column A) (in Column B) (in Column C should be) (in Column D should be) 2016-01-01 08:00:00 80 08:00:00 240 2016-01-...
0
votes
0answers
8 views

How add your logo on Twitter and Facebook cards in Blogger

good morning How I can add a logo on the image of a social card (Twitter, Facebook) in blogger?. I can't find clear information about it. Thank you in advance
12
votes
4answers
18k views

How can I set a label on all cards in a particular list at once in Trello?

I have a board with several lists. Three of the lists are "big tasks", "medium tasks", and "small tasks". I want to make all of the cards on each of these lists a particular color. That way, when I ...
0
votes
1answer
126 views

Several KML's in one layer

I have 10 KML simple tracking route files. I have created a map with 10 layers and placed them all in a separate layer. Then I moved to Google Maps (not Google My Maps) I was expecting to open current ...
0
votes
0answers
2 views

Help in Creating a dashboard(Like the video below) using React js that contains a sidebar that includes items that the user can order to fill

link to see how it work on youtube: https://www.youtube.com/watch?v=ItnM8JzP_I8&ab_channel=eliiehachem I want to create a dashboard like this (Using React) contains a box(this sidebar looks like ...
0
votes
0answers
5 views

Apply custom formula across all columns using Array Formula

I have trouble applying my custom formula across all columns using Array Formula. My custom formula is named getCountry where it could get the country based on an address. The address components e.g. ...
1
vote
1answer
12 views

Make a copy of a column of images omitting blank cells in Google Sheets

I need to convert column A to column B (without blank cells between the flag images) using a formula.
0
votes
1answer
43 views

Function to copy fields from one sheet to another based on IF statements

I'm trying to figure out a way to copy specific fields to other sheets based on IF statements. I have 4 sheets, the Customer Subscription Sheet (Sheet 1), Month 1 (Sheet 2), Month 2 (Sheet 3) and ...
0
votes
0answers
8 views

Gmail tagging / labeling / priority inbox

Is it possible to create Gmail priority inbox rule based on Label/Tag (someone tagged you in an email)? My specific problem is this: I want to prioritize my e-mails - if someone has tagged me in the ...
0
votes
0answers
6 views

How do I unlink a business page to my other business page

Ok soooo I run two businesses, I have accidentally linked my new one to the other business page, problem being on my new business page it won't allow me to have the 'send message' button for messenger....
0
votes
0answers
4 views

Google Forms multiple choice quiz ( mathematical equation in feedback section)

Is there a way for me to put mathematical equation in the feedback(Answer key) of a multiple choice Google Form. Side not, can I change the score from appearing on the top left corner.
0
votes
0answers
2 views

Google Shopping Insights

I used to receive a report every so often from Google called the Google shopping insights where I would input a search term/category and the report would periodically tell me which brands within that ...
0
votes
1answer
7 views

Stepped prices in Google sheets

I looking for a formula to create stepped prices based on the buying value. Like this: 0.10 until 0.20 = $0.50<br> 0.20 until 0.30 = $0.75 <br> ... with $0.25 steps<br> 1.00 and up, $...
0
votes
0answers
5 views

How to return column B data when writing column A word?

I'm trying to create a program using Google Sheets in which, when I write any word of the column A, the program would return the word written next to the previous word (same row, different column). In ...
0
votes
2answers
2k views

Renaming images in Google Photos

How can I rename an image in Google Photos? From the web browser, I can add a description, but when I download the image, it uses the original file name. I need a real rename which changes the name ...
28
votes
17answers
98k views

How to copy a shared folder into my own Google Drive?

It seems like the Make a Copy option only works for individual files (not for folders). When somebody shares a folder with me on Google Drive, how can I make a copy of that folder in my own Google ...
0
votes
1answer
13 views

several gmail mails - not seen all addresses

Is there any solution for this problem - in sent messages, which contain correspondence of several mails, often there is no list of all addresses to whom these mails below were sent?
1
vote
2answers
701 views

Force embedded YouTube videos to play at specific quality resolution

Is there a way to force embedded YouTube videos on any site I visit to play at a specific quality? Specifically I'm trying to have a Weebl and Bob marathon, making sure I see every episode by ...
0
votes
0answers
25 views
+100

This account is not eligible for Developer Profiles

When I go to https://developers.google.com/profile/u/me, I'm prompted to make a profile: Then when I click the "Create a profile" button, I'm greeted with the message: This account is not ...
0
votes
1answer
214 views

How do I link to a specific gmail search, google document etc on the correct google apps domain?

I want to provide links to specific GMail folders, GMail messages, Google Drive items etc on a company webpage. Users may have multiple Google accounts and it is not guaranteed that their primary / ...
6
votes
1answer
7k views

Hide player controls while fullscreen in YouTube

Is it possible to prevent YouTube's (HTML5) fullscreen player controls from showing whenever it first goes into fullscreen mode? Like, don't show this automatically (at all): I want it to still show ...
1
vote
3answers
57 views

Limiting Google Drive database edits to data, not structure

If I share access to a database I made in Google Drive, is there a way to allow others to input data but not change or alter my database format?
0
votes
1answer
3k views

Countif based on multiple criteria

For reference here's the sheet: https://docs.google.com/spreadsheets/d/1CS-fYhqeKRmEiJC5XA6kRIwIjyBDlBcXj-K9FHjCZjA/edit?usp=sharing I am trying to create a filter that shows me all the data for May ...
0
votes
1answer
24 views
+100

How to add a UNC URL to a MediaWiki page

In a MediaWiki page, I'd like to add an URL to a file on a file server. The path is an UNC one(\\fileserver\project\...\SPECIAL.ext), and I already have tried following "path link": file:////...
0
votes
0answers
21 views

Return every column header that contains a value

I'm trying to return the header of every column in which a value appears, and put these headers in one cell separated by commas e.g. if "xyz" is contained within columns titled Column1 and ...
1
vote
1answer
519 views

How to get unblocked Facebook page which has been blocked by Facebook for 30 days?

My friend have his own Facebook Page, he mistakenly post something which go against of community standers, now he got a block for 30 days. How to unblock him?
0
votes
0answers
8 views

What do the two diagonal red marks mean in the YouTube app? [closed]

! What do these two diagonal red marks mean in the YouTube app? They are only seen on the videos that I have uploaded page.]1 Please see the image. You will notice this on the on the videos you have ...
0
votes
1answer
21 views

Can I turn/disguise links as texts in Facebook posts?

I oftentimes post links in comment sections and Facebook Groups, to direct a person to a post, a group or a website. But sometimes links take too much space and they're kind of a bit too messy to look ...
0
votes
1answer
22 views

How do I display data from cells, but skip over the blank cells?

I have a list of scores, and I need to display them concisely. How do I read a long row of cells only some of which have scores in them, and print those scores out? Example: https://docs.google.com/...
0
votes
0answers
3 views

Access connected Android phone camera from Chrome browser on my Macbook [migrated]

I know there are programmatic ways to request media from another device's camera, but is there any simple way I can access my phone camera from my (localhost) web app? I connected my phone to my ...
1
vote
1answer
75 views

How can I pull a value from one column based on the values of another column?

When the value in the "Amount Owed" column becomes less than 0, I want the value in the "Year" column to appear under "Year Paid Off." For example, if the "Amount Owed" dropped below zero at "Year" 1,...
1
vote
1answer
767 views

Google Sheets - Arrayformula with textjoin

I'm trying to figure out how to make my arrayformula with textjoin to work, but I'm kind of lost. What should be done is that F3 to F5 should have a formula attached, so it displays as showed. The ...
0
votes
0answers
5 views

google meet/calendar automated dial in?

automated meeting dial in: instead of going to calendar (phone/laptop) and clicking join a meeting is there an option to enable a notification that appears on the screen of your device at the start of ...
0
votes
0answers
2 views

Disable spaces watched by default for new users

For some reason when I create new users in Confluence they are automatically set to watch two of our spaces. This results in a LOT of notifications. Where can I change this?
0
votes
1answer
74 views

Chrome extension reply to review, name, publisher name and nickname

There are 3 names associated with my extension my publisher name P my real name N from the Google account a nickname K (currently blank) from the Google account I would like to post a reply to a ...
0
votes
0answers
4 views

http://104.225.171.33/ [migrated]

Why did all my tabs suddenly reload and go to a new website with the URL http://104.225.171.33/, which does not load? I'm on Google Chrome. After I go type in the URL on those pages, though, it works ...
0
votes
1answer
10 views

How to publish to the web a Google spreadsheet without gridlines?

I want to publish my sheet to web but i don't want to see the gridlines. I have tried to hide gridlines in my sheet. But the gridlines is still visible when i publish to web. Can anyone help ?
3
votes
1answer
385 views

On Google Books, how do I get to the main page of a book without modifying the URL manually?

Say I search for a book on Google Books and then click through to it. If I copy that URL and send it to someone, they will be taken to the same page for the book, but the URL also contains a bunch of ...
0
votes
0answers
5 views

Getting Google Spreadsheet default locale to work correctly

Here is my issue : We work in English We are a French company : we want Euro as default currency... ... and the "French formatting" for dates (dd/mm/yyyy) and numbers (1 thousand = 1 000,00 ...
0
votes
1answer
135 views

How to make Facebook automatically redirect from a page to another?

If you access www.facebook.com/dell you'll be redirected to the Dell page of your country. Can I make the same thing with my page? Like, when you access www.facebook.com/RedPurpleSecondPage to be ...
0
votes
0answers
4 views

Download Google Drive folder with documents in ODT format

I've been using Google Drive for a while, however today when I downloaded all my documents created in Google Drive I just noticed that all of them are saved as docx. I've been looking for a way to ...
0
votes
1answer
29 views

Google Sheets data validation using hidden lookup value?

Let's say we have a Google Sheet used as a data validation "table" ******************************** ID | Name ******************************** 1 | Mike 2 | Sue 3 | Bob 4 ...
1
vote
1answer
19 views

I have two businesses. separating out the two gmail accounts

I am a real estate agent with Weichert Realtors. I also operate a financial services company from a different location. When I type in my Financial services company , my Weichert gmail account comes ...
1
vote
2answers
2k views

How the other person's messages disappeared and it's showing as Facebook user?

How the other person's messages disappeared and it's showing as Facebook user?

15 30 50 per page
1
2 3 4 5
633