All Questions

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

Notification when a Google Sheet is not being updated [closed]

I have an integration process running from another tool that is populating a Google Sheet every 15 minutes (00, 15, 30, 45). Every night when the job runs at midnight, it will create a new tab with ...
4
votes
4answers
6k views

How to delete user accounts from Google

I have four Google accounts but I only use two of them. I'd like to delete the other two but all four show when I click the blue sign in from google.com. How can I delete the two I don't use and make ...
0
votes
1answer
25 views

Pandora's Next-Song Selection: When, Where, and How?

I surprisingly cannot find any information about this online: I have some questions on the Selection of the Next Song in Pandora (Premium) App: Does the selection of the next song occur in the App ...
0
votes
0answers
6 views

Can I invite someone to Slack channel without their seeing all other channels in my workspace?

I have a Slack workspace for my office, and want to create a channel for a particular project, and add the client to that channel. But I don't want to client to see our 'General' channel etc. Is there ...
0
votes
2answers
32 views

Defining Value to Numbers and Text and then Adding them

I am comparing apartments and I have columns for features like bedroom, full bath, half bath, rent, pet friendly, balcony, laundry, utilities, parking, and bus access. Some of these have numbers like ...
0
votes
1answer
12 views

Google Sheets: How to have conditional formatting based on each individual cell?

I have a Google Sheet where it's a table full of people's Euro Cup soccer picks. I want to have a column at the end where I type the winning team into a cell. If that value matches then I want the ...
29
votes
4answers
92k views

How can I copy cell values rather than references from one sheet to another in Google Sheets

How can I copy cell values rather than references from one sheet to another? Right now using Filter, Query and ArrayFormula creates references which create empty cells and disallow sorting of the ...
0
votes
0answers
3 views

How can I determine which channels in Slack were active recently?

Sometimes when joining a long-running Slack there are many channels, a lot of them stale and quiet. Is there a way in the UI to figure out which channels have had activity in the past few months or ...
0
votes
1answer
12 views

Google Forms: Disable the “back” option on a multi-section quiz?

I would like to create a quiz whereby respondents watch video and answer questions about it. It is important that the respondents only watch the video once. In order to do this, I have split the form ...
0
votes
0answers
11 views

Can't add child's account to YouTube channel

I have a YouTube channel under my (adult) account where my kid posts videos. I'd like to add him as a member of the channel, officially but when I try to add him, I get this message: I tried setting ...
14
votes
5answers
18k views

How can one link directly to a specific page of a PDF in Google Drive?

I'd like to provide a link to a PDF document in Google Drive like [documenturl]?page=4 and have that link jump to the specified page. With a quick search, I was only able to find this unresolved ...
33
votes
8answers
114k views

How to insert the current date into a Google Spreadsheet?

I've got a spreadsheet in Google Drive and one column is meant for the date the entry is made. Is there a button to do this? I'm aware of the functions =NOW() and =TODAY() but their description says "...
0
votes
0answers
17 views

GitLab self-hosted instances data sharing [migrated]

I'm working on a personal project with some friends and it is becoming quite large, so I'm considering to self-host a GitLab instance to help preventing the development to go to complete chaos. ...
0
votes
2answers
2k views

Need to get a list of Drive files several subfolders deep

I need to get a list of all the files in my Drive with all of the nested folder names where the files reside. I found this very helpful answer which is almost exactly what I need: Get a list of ...
0
votes
0answers
5 views

How to equalize participants volume on Google Meet?

When attending calls on Google Meet, I often meet the issue where participants have very different mic volumes. This is annoying as it's hard to hear the persons with lower audio volume without ...
0
votes
0answers
10 views

Goto specific page in embeded google drive document? [duplicate]

Hi amazing HeroStacks So as title suggest, I have an embedded google drive document (.pdf), where my webpage loads a window with a 36 page interactive brochure. My goal is to be able to link to a ...
0
votes
1answer
138 views

Change picture of Google account

I tried to change the picture of my Google account. I did this through Gmail. However, the picture has not yet changed. I tried the things I have read in other related questions; remove/change my own ...
0
votes
0answers
2 views

Make Tweets public but block followers

I would like my tweets to be public but I only want people I know and approve to be able to follow me, without making my account private/protected. Is this possible?
0
votes
1answer
20 views

Copy data from one sheet to another at the end of every month [closed]

I have a Google Sheet where I track the performance of multiple campaigns. I want to copy the completion value to another sheet at the end of every month. Each month should have it's own column. This ...
1
vote
1answer
20 views

Synchronize time among several concurrent users

I'm using Google Sheets to come up with a quick Jeopardy-style game with an improvised buzzer. All players type in the timestamp shortcut (Ctrl+Shift+0) into a cell and the lowest value is presumed to ...
0
votes
1answer
14 views

System of equations in draw.io

I'm looking for a way to write a system of equations in draw.io. I know how to do it in latex, but it seems that the syntax is different in draw.io. Could you tell me how to do it please? In latex I ...
0
votes
1answer
22 views

How can I use the importhmtl function in combination with today ()-2 function

I am importing data from a website: https://www.chancesgames.com/WinningNumbers/WinningList It provides up to 30 days of data. I want only two days of data, that are specifically in columns a b e and ...
0
votes
0answers
5 views

how to know where my data is saved in google collab

Somebody shares a folder with me on Google Drive and I am trying to make a copy of that folder in my own Google Drive account with google colab but after copying some files the disk space of google ...
1
vote
0answers
41 views

What exactly determines whether Google Maps shows a “3D mode” button or not?

Lately, I have been loading Google Maps with links from my own map system, always in the same way, always in the same browser, with the same computer, same configuration, same everything. Randomly, it ...
1
vote
0answers
4 views

Cognito Forms Notifications

I have made a rather complex form using Cognito forms. Basically, I want to setup a notification to send when a field is updated after submission using the edit shared entry link. For example, say I ...
0
votes
1answer
33 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 ...
7
votes
6answers
24k views

Google Analytics: Best way to separate stats for subdirectories?

I have a number of sub-sites operating under the same domain. I would like to track the stats and analytics with Google Analytics, but have each sub-site appear on its own. My site structure looks ...
0
votes
1answer
227 views

Migrate Google Chats from One Google Account to Another

I have two Google accounts - an old one that I used for a while as a kid, and a new one I opened when I became a working professional and needed a professional-looking personal email address. It's ...
0
votes
1answer
37 views

How to clear cells-A:2 is on a sheet(Incdt) that is linked to A:2(Resident) on another sheet. Want to clear B2:F2 on (Incdt) when Resident is modified

//This code works if I edit the sheet but does not work if the link sheet is modified.I think it is because the cell that is being modified is the cell from another sheet that is linked to the sheet ...
2
votes
1answer
88 views

How to find my tweets where a specific user retweeted it?

I want to know if a specific user ever retweeted any of my tweets. For example: from:@username includes:nativeretweets filter:nativeretweets The above command gets part of what I want, but I need the ...
0
votes
2answers
72 views

Cell reference for contains value in Google Sheet

Looking for help referencing another spreadsheet, where I want to lookup several values in cell A2, to see if the value is contained in the cell (as there are variations), then setup an else clause at ...
1
vote
1answer
736 views

Scitpt to duplicate template sheet into new workbook, then rename

I am looking for a script that will create a menu item that will allow me to copy a template sheet that I have created (multiple times) into a new workbook, and rename the copies at the same time. ...
5
votes
1answer
2k views

Prevent Gmail from applying multiple labels

I have recently imported all my mail from Outlook.com and my work email into the gmail accout and I have started to organize the messages using labels. The filters work great and I have managed to ...
2
votes
1answer
765 views

How to send Google Form results to a particular sheet (“tab”) of a Spreadsheet

Is there a way to create a Form that submits to a particular TAB of a Google Sheet? Use Case: We are using this for meeting pre-check-in. There's standard form. I'd like the results for each ...
0
votes
1answer
266 views

How to archive comments from a YouTube video page for myself?

Looking for a faster way to save comments under a YouTube video rather than manually expanding the page, collapsing the sub-comments and copy paste in some text file.
3
votes
3answers
238 views

Conditional formatting for columns, date & time specific?

I have uploaded 4.000+ Venmo donation data sets into Google Sheets for sorting, but the date and time is preset and looks like this: 2018-11-01T20:16:52 I have tried multiple approaches to sorting ...
0
votes
1answer
165 views

Comments and Threads in Trello

I am pretty new to Trello and am wondering whether it is possible to improve the looks of the comments under a card. Out of the box, they all run in one thread, which makes it difficult to read, ...
1
vote
1answer
6k views

Pass cell value into Google script

I'm facing a problem, hope anyone can help me. I have 3 sheets with different functions, data_sheet contains a thousand data with date in descending order in Col A, input_sheet is only for input data ...
0
votes
1answer
10 views

Google Sheets conditional formatting multiple columns with ignoring blank cells

I want to highlight the cells in E/F/G columns when they exactly match the score in column D, but I want formatting to ignore blank D cells. Can I do this somehow?
0
votes
2answers
177 views

Check button in Google Spreadsheets specific for each user

I have a Google Spreadsheet with different tasks. I want to implement a check button in the following way: My intention is that the users can't edit the spreadsheet but they have to be able to use ...
2
votes
2answers
62 views

How do I increase google sheets cell number by adding 20 in a formular

I would like to use "+" or "- " in referencing a cell eg =i(10+23) = i33 . So that I don't have to increment the cell reference manually . Any help would be great ?
1
vote
2answers
57 views

How can I add a check box in Google Sheets based on the content of another cell?

I have a list of four options in a cell. Three of them require "approval" so I need a checkbox in the cell beside it. For one option, I do not want the checkbox to appear. Is this possible?
0
votes
1answer
19 views

Google Sheets - fill a cell with a hyperlink based on dropdown menu selection

so I have a spreadsheet i'm using to track clients workouts. To make life easier and faster when creating the workouts i created a series of dropdowns with exercises, body parts associated with that ...
0
votes
1answer
16 views

What are these three circles on Google Flights website?

What are these three circles on Google Flights website? seen when trying to use the Google Flights website from my phone.
0
votes
3answers
98 views

Average formula for Google Sheets with substitution over some figures

I have a row of figures from 0 to 2, some cells are empty. I need to count an average for them, but with the rule that would count 2 as 1. Thanks
0
votes
1answer
45 views

Copy Rows from Master Sheet to other sheets based on user input

I am trying to set up an assignment sheet for my work team. I have a script to move a selected range from one sheet to another, but is there a way to modify it to have the person doing the assigning ...
1
vote
2answers
2k views

Emails to Google Groups email address aren't working

When I send an email to the an email address in Google Groups, I get the following error from Mail Delivery Subsystem mailer-daemon@googlemail.com We're writing to let you know that the group you ...
0
votes
1answer
2k views

How do I import data from one Google spreadsheet to another

I need to import a range of data from one Google spreadsheet to another but I keep getting the error: "Cannot find range or sheet for imported range using this formula" =IMPORTRANGE("https://docs....
1
vote
2answers
104 views

Pasting from Google Docs into WordPress adding unnecessary formatting

Simply copying and pasting from google docs into wordpress adds tons of this: <span style="font-weight: 400px"> throughout the wordpress post/page.
1
vote
1answer
75 views

Google Form response is modifying a cell on another row of linked sheet

I have a sheet that is recording form responses on a linked Google sheet. The issue is that sometimes the form will modify a cell on the row above in addition to the row that is being inserted (see ...

15 30 50 per page