All Questions

0
votes
0answers
18 views

One script for multiple tabs in one Google sheet

Can you please help me with this script? I've tried to edit it to apply to multiple tabs the same as the original question. But I think something's amiss. :( Here's the original code and I want this ...
0
votes
1answer
19 views

Google Docs Prevent Download

I using GSuite product for my company, however we are working with outsource team. That guy will working (eg. editing) with several GDocs, GSheet file. I wanted to disable download feature on GDocs ...
0
votes
1answer
27 views

what difference between these video files might make youtube accept one and not the other?

what difference between these files might make youtube accept one and not the other? Each is about 100KB or 150KB. Each of the two are one second long so are small easy to download and quick to test ...
0
votes
1answer
27 views

Reference all tabs with a specific word in COUNTIF statement

Basically, I am trying to make a master tab that adds up all of the data from all the other tabs. These tabs are weekly breakdown numbers for ad statistic numbers, so there is a new tab added every ...
1
vote
1answer
9 views

Finding the number of instructors available on different weekends in Google Sheets

I'd like to find a generic way to see when resources are available, in order to help plan when activities can be run. In this case, the resources are people with certain instructor qualifications (...
0
votes
1answer
18 views

Divide data evenly in row, place in additional rows

I am using Goodle Sheets, and I have a simple problem. I am looking to divide the data by 4 in many rows, and place the results in new separate rows, replacing the original row. The new rows should ...
0
votes
0answers
14 views

Drawing Circles Around Every Listed Item In A Layer

I have this map, it shows schools, daycares, churches, and the like. What I want to have happen is that I want a script to automatically draw 500 feet circles around each of these locations that are ...
0
votes
0answers
7 views

How do I get google or bing maps to give me turn by turn directions on a laptop?

Our company uses rugged laptops for our customer's delivery trucks. I can map the location without an issue and it will give us directions to the location but we cannot get it to do the turn by turn ...
-2
votes
0answers
18 views

Combining multiple facebook feeds into 1 feed using

We previously had multiple Facebook page feeds combining into one feed on our site. With the new updates to the system we will need to do that differently. Could you please let me know how through the ...
1
vote
2answers
19 views

Google Sheets monthly rolling average

I have a table in Google Sheets with data for different people by month. I want to display a monthly average that will be progressive as the year goes by. So they can have an idea of how they are ...
0
votes
0answers
10 views

How to exclude usernames and handles while searching twitter

While searching twitter for rather generic terms, returned search results include bio-names and handles of users. How to filter those fields from search results? For example: Searching latest tweets ...
1
vote
0answers
26 views

How to change the name from “me” to recipient names of the same subject heading?

I'm trying to see how I can find emails with same subject heading sent to different people through the "sent" setting on Gmail? All I can see when I click "sent" with a specific subject heading is "...
0
votes
0answers
20 views

How to restore removed messages from the supergroup?

I've given admin on a Telegram's supergroup for the person, and he removed all the historical messages of another admin. I can see the removed messages in Recent actions. Is there any way of ...
0
votes
1answer
7 views

Odd result in Google Sheets calculation

I am editing an existing spreadsheet in Google Drive and the formula below is giving me an answer I cannot figure out. =if(isBlank({H6}),ifError(1/0),(( ArrayFormula( ROUND((P6*1.2)))-0.05))) where ...
1
vote
0answers
35 views

Google sign in with 2 step verification but no longer have that number [duplicate]

I have a Google account that has over a thousand pictures of my daughter that was killed last year at the age of 23. My back up phone number was that of friend who also passed away around the same ...
-1
votes
0answers
11 views

How can I download videos from Instagram that aren't the first in a set?

I already know how to download a post with one video, or the first video out of many at https://www.vidpaw.com recommended by Reddit . Rather, I'm asking how to download subsequent videos starting ...
-1
votes
0answers
18 views

Page's new post producing 404 on Facebook

On Facebook, I like a few pages, and I subscribe to notifications of new posts from these pages. So, whenever a page produces a new post, I receive a notification. These take me to a URL like https:/...
0
votes
1answer
7 views

How do I copy over a value from another worksheet depending on the adjacent column?

I have two checklists of the same items in a different order in two separate sheets, and I want to only update one. Basically, I have two pages that look like this And I want the? to be automatically ...
1
vote
0answers
26 views

How can I prevent editors from accessing the script editor in Google Sheets?

I have an auto sort script on a Sheets document that I will be giving multiple people editing permission to, to add to the file. I have created a trigger so the script also runs when other users edit ...
0
votes
0answers
22 views

Reducing time it takes for 'new' tag to disappear in Gmail upon viewing a tab

In Gmail, if I get a new email in one of the tabs (e.g. 'Updates'), there will be a small tag that says 'new' next to it. If I click the tab, and then click something else soon after, the 'new' tag ...
-1
votes
0answers
12 views

Notifications without being friends on fb

I received a notification from my ex on Facebook that he was in a relationship and we aren’t friends on Facebook and we don’t follow each other. How is this possible?
0
votes
1answer
11 views

How to TEXTJOIN in Google Sheets

I have ten columns in my rows which contain 5 sets of first name/last name. I want to combine each of these names in a final column using TEXTJOIN (or whatever function is appropriate if I'm missing ...
1
vote
1answer
15 views

How do I get rid of the blank line when I use UNIQUE in Google Sheets?

I used unique... the result is in column B, but I want results to look like column C. So what do I need to do to achieve this?
-1
votes
0answers
9 views

Good book datasets that can sort against year?

I need a dataset with text from books that also includes the year of the publication of the book, for a natural language processing thing. Or, is there some way to preprocess from the project ...
1
vote
3answers
47 views

Filter cell data using Query/Importdata

I am attempting to grab data from a cell, by using additional data in the cell above it to make sure its correct. Here is the data, each line is put into a cell by the formula. <total_count>6&...
0
votes
1answer
13 views

Replace value in field automatically (auto-correct?)

I'd like to replace occurrences found in Column A (cells A2:A200) so that if I enter 2/02/002 or 343 or 98/098 it auto-replaces it with UKD002/UKD343/UKD098. Is this possible?
0
votes
1answer
15 views

Collates the number of depots that don't have manifests and trunk headers

Trying to do a work project that collates the number of depots that don't have manifests and trunk headers. Column A: Depot Numbers Column B: No Manifest record (i.e if Colum B 2 - 200 contains "...
1
vote
1answer
118 views

How to make Google ask for password when switching between accounts

When using Gmail, have the option of switching between accounts by clicking the user icon in the upper right corner of the screen. Currently, can switch between the accounts listed when clicking the ...
1
vote
1answer
60 views

See most visited sites on Google has disappeared?

I know for a fact a couple of years ago, I could go to history.google.com or google.com/history and it would greet me with statistics of my visited sites. It would show stuff like how many times I ...
0
votes
1answer
10 views

Data validation if no then disable cell else drop-down lists

I'm trying to do a drop-down list IF another cell doesn't equal "no" So I have two columns: one with a drop-down list containing "yes" and "no" and in the other column I want to do a drop-down list ...
0
votes
0answers
7 views

Hide unread indicator for pinned Gmail tabs in Firefox [migrated]

There's an annoying indicator on my pinned Gmail tabs in Firefox whenever I receive a new mail. I believe this is default FF behavior for whenever the <title> of a page changes. I hate this ...
0
votes
2answers
9 views

Update each cell in column from upper right adjacent cell

How can I make the start mileage in each cell update from the end mileage in the upper right adjacent cell? Preferably using something like a single array formula that can be updated. I think I'm ...
0
votes
0answers
12 views

GMAIL ADD-ON Error - Invalid developer add-on [closed]

I logged in as an ADMIN in my org and deployed a preconfigured .json file for an app on Gmail using google apps script, I copied the Deployment ID and tested on my Gmail account by enabling developer ...
0
votes
0answers
7 views

PayPal redirect issue on Wix Platform [migrated]

I am creating a website for the charity that I work for (which has a very limited budget, and we therefore are making use of me (a social worker who happens to be okay at some computer stuff) and a ...
0
votes
1answer
19 views

Get excel in sharepoint to google drive

Is there any way to import an excel file located in a sharepoint into a google drive site?
0
votes
0answers
9 views

How do you change the page layout?

I somehow accidentally changed my page layout. Now there is a lot of blank space to the left and everything else is smaller. HOW DO I CHANGE IT BACK? This should be easy to find the answer to but ...
1
vote
1answer
25 views

How to force a straight line in Draw.io?

I am drawing this: And, I simply cannot make the line straight as all lines should be! No matter what I move, the line still has that break. Any suggestions?
0
votes
1answer
24 views

Can't delete an inactive Instagram account

I deleted an old account a couple of years ago, however the account still appears on my iPhone for some reason. I can't remove it, log into it in order to properly log out of it to delete it ...
0
votes
1answer
13 views

INDEX + MATCH to return the greatest of all matching values

I'm looking for the most recent date corresponding to a particular name. Dates are not necessarily ordered. I can't sort the target, I need it to work in any order. Example: When was [Roberto]'s most ...
1
vote
2answers
10 views

How do I automatically enter sequential numbers without using the mouse in Google Sheets?

I would like to create a series of number in Google Sheets, without dragging with the mouse. When using the Shortcut Cmd+R (Fill Right) it just copies the value of the first cell. Initial State: ...
1
vote
1answer
40 views

Goggle Sheets IMPORTXML/REGEXEXTRACT out of date

Alright, so I found my basic answer from these posts, 2-3 years ago. Extract data from Steam Import total hours on Steam Steam has updated its website since then, so I've messed around with it and ...
0
votes
0answers
3 views

Vertical alignment of text within a Gliffy shape

Given a basic container shape on a Gliffy diagram : we can see the Text formatting options only show horizontal alignment options: This is in contradiction to some documentation that I had found: ...
1
vote
1answer
23 views

What happens to a Google Docs history and comments when a user is deleted

If a user is deleted from an organization (no ownership transfer, etc. just deleted), and that user had collaborated on some Google Docs shared with them (not owned by them), what happens to the ...
1
vote
2answers
21 views

How to pull last value in a Google Sheets column and populate it across another worksheet column?

This is my first post here- I hope this is the right place for it, apologies in advance if it isn't. Context: I have a password protected presentation that I need to give users access to, but only ...
0
votes
1answer
23 views

Is a shared Google Photos album publicly searchable?

I'd like to share a Google Photos album only with one person and allow them to view and edit the album, but I do NOT want the album or any photos to come up in search results. I saw that the only way ...
0
votes
1answer
9 views

How to edit my business on Google My Business?

The old business is closed. The address is the same, but the Name and Type of business have changed. How can I edit this in? Jocelyn Ross Officiant on Demand (New Business Name) ...@gmail.com 630.640....
0
votes
1answer
12 views

Google Sheets Conditional Formatting for expiration dates

I need help! I need to create conditional formatting for expiration dates: Cells should stay green Cells should turn yellow when 1 month of exp. date Cells should turn red once expired
0
votes
2answers
10 views

Conditionally format cells that not match with range from Sheet2

I have two sheets in the same file where "sheet1" has cleaned up information and "sheet2" has the dump from my jira. Now I am trying to compare Column F from sheet1 and sheet2 to confirm if they are ...
1
vote
2answers
15 views

Change cell colour based on another cell containing text (day name)

I am new to Google Sheets and trying to create a custom formula in conditional formatting to make the fill colour of a cell change based on another cell containing a specific text. I want to change ...
0
votes
0answers
12 views

can a user see a list of private/locked channels on SLACK?

If there are private channels on slack, can a user without admin rights see the list of those channels?

15 30 50 per page