All Questions

Filter by
Sorted by
Tagged with
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
1 vote
0 answers
13 views

Formula to automatically sort range of data into groups in different columns by colour?

I am an educator trying to find a way to automatically group students into broad groups of 'below' 'at' and 'above'. My data is more specific (i.e. numerical value between 0 and 30) and I would like ...
user avatar
0 votes
0 answers
16 views

Carryover without overwriting?

I have the following situation and am not sure how to set up such a structure, maybe someone has an idea on that: A total of 20 different gsheets 1-5: Tables in which information is entered 6-20: ...
user avatar
0 votes
0 answers
42 views

Sheets: Collaborators inserting their names as values into selected cells

Previous post marked closed due to being unfocused, so I pared it down. Not sure if this is now good enough, if not please can someone comment to explain so I can correct it? I'm trying to find a way ...
user avatar
  • 1
0 votes
0 answers
14 views

Two emails received from the same sender and only one considered as suspicious by Gmail

Within 2 minutes difference, I have received in my Gmail two emails sent from exactly the same sender. First message was marked as suspicious: While second one was not: Is this some kind of a bug (...
user avatar
  • 2,536
0 votes
1 answer
9 views

How to forward/integrate Discourse posts to/with Slack?

I would like to submit Discourse posts to a Slack channel. When I googled the topic some old blog posts came up from 2016/17 for an integration that seems deprecated. What's the recommended way to set ...
user avatar
0 votes
1 answer
35 views

Splitting hierarchical codes into parent items (Google Sheets)

source cell: CCA, BF result cell: C, CC, CCA, B, BF CCA is a complex code relating to a hierarchy. It means, CCA is child of CC, which is child of C. So, the formula should split into all parents (C ...
user avatar
  • 1
2 votes
1 answer
54 views

Google Sheets Query - Drop down text match

I would like a query on the 'query' tab that searches sheet 'sales' and returns all values if it matches the dropdown selection on the 'query' tab https://docs.google.com/spreadsheets/d/...
user avatar
0 votes
1 answer
18 views

Video uploaded as YouTube shorts

The video has uploaded itself as a "shorts". There seem to be no explanation why, no setting to turn it off and all the research from google focuses around the mobile YouTube app. I uploaded ...
user avatar
  • 111
1 vote
1 answer
25 views

How do I "=SUMIF" or "=COUNTIF" functions with multiple conditions from different column's?

Afternoon everyone! Strap in as this might get a bit hectic! I'm working on organizing sheets that are sent to me, and I don't want to change anything about the original sheets (A23:O). The sheet ...
user avatar
  • 13
0 votes
2 answers
42 views

How to return header value if in the column it contains typed value

I am attempting to make a spreadsheet in Google Sheets that will protect the "database" from those able to access it, so I've got the first sheet as the "front end." On the second ...
user avatar
0 votes
1 answer
23 views

Problem carrying data validation down through column

I am utilizing dependent drop down lists with an indirect function. The first drop down list is Column I, the second drop down list is Column J, and the indirect formula is running in Column N through ...
user avatar
0 votes
0 answers
9 views

Is there a way to get all-day events to vertically cover the whole day in Google Calendar?

Sometimes I need to schedule a meeting slightly outside everyone's normal working hours, since we have zero timezone overlap. In these cases, it would be helpful to be reminded of entire days I am (...
user avatar
  • 236
0 votes
1 answer
91 views

Present a Google document and an audio file at the same time in Google Meet

I'm a teacher. How can I present a Google document and an audio file at the same time in Google Meet so my students can listen to the audio file and answer the questions presented on the Google ...
user avatar
  • 20
0 votes
1 answer
22 views

Delete second line of text in every cell in Google Spreadsheet

I have an issue with Google Spreadsheets. I export bulk address lists from my eBay orders into Google Spreadsheet to be able to export as a CSV file to my label printer software for printing. The ...
user avatar
0 votes
0 answers
12 views

Can I make text break and clear an image?

I have an embedded image with text wrapping to the left of it. I want the next paragraph to begin after the image. In raw html, I would do something like <br clear=all>. Is there an equivalent ...
user avatar
0 votes
0 answers
16 views

How to lock/link data across a row when using array formula?

I have a sheet with multiple tabs where one tab serves as a master, containing a list of music tracks. This master tab contains information about each track, like duration and BPM (tempo). In another ...
user avatar
0 votes
0 answers
7 views

Google Earth: Keep placemark images displayed during tour recording? [migrated]

I'm recording/generating an .mp4 from Google Earth by having a tour follow a path. Is there a way to attach images to locations that remain open during the tour? If I try using a placemark with an ...
user avatar
0 votes
0 answers
24 views

Google sheets -How to modify a number in a formula based on user input

I was trying to automate a project where I would need to modify a number in one of the formula every time as per the user input. For example: in the above formula, the highlighted number (9) should ...
user avatar
0 votes
0 answers
17 views

Google Search doesn't show "More results from <domain>"

It used to be that if a search results in many results from a website then a link would be displayed to show More results from <domain> For instance when you search for "ukraine conflict&...
user avatar
1 vote
0 answers
13 views

Create multiple views in Gmail based on label criteria [duplicate]

Is there a way to create a readily accessible view in Gmail based on labels you specify? Based on link and link, I am aware that I can do label:Business1 OR Invoice AND NOT label:MyBadLabel1 However, ...
user avatar
0 votes
0 answers
31 views

Is it possible for spreadsheets to fix a value after calculation even if references change afterwards?

What I want to do is that a cell gets calculated and it never gets calculated again, or a workaround. My use case is this. I have a Google Spreadsheet where I have two percentages, those percentages ...
user avatar
  • 101
0 votes
0 answers
28 views

Google Sheets - Calculating Difference To The Next Grade Boundary With Multiple Criteria

I need help calculating the difference to the next grade boundary. On sheet 'Year Group', I have a formula that will tell me this difference (col F) but as you can see Apple (row 20) has enough total ...
user avatar
  • 1
0 votes
3 answers
53 views

Weeks since larger drop

Data Each value in B is the amount that the Federal Reserve balance sheet changed for a given week. Largest drop since... This past week, the balance sheet decreased by $31,617. This is the largest ...
user avatar
0 votes
0 answers
22 views

Condensing Data

I have roughly 1000 rows of data, and each day has about 50-60 rows for it. Is there a way I can condense it to where it will just say "May 20" and if you click it, you can get all of the ...
user avatar
  • 1
0 votes
1 answer
21 views

add timestamp to this code

How do I add a timestamp in the format hh:mm:ss in column B (instead of "null") const values = [[new Date(), null, text]]; const firstBlankCell = sheet.getRange(sheet.getLastRow() + 1, 1)...
user avatar
0 votes
0 answers
10 views

Dynamically add answers [duplicate]

I want to ask questions as the following with Google Forms: What lessons have you already completed? (here I give a list of lesson options. Only one option can be selected) Lesson A Lesson B Lesson C ...
user avatar
-1 votes
2 answers
46 views

Google Sheets – Is there a Full Screen Function or Script?

I was wondering if there is a function that makes google sheets go full screen? For example a script that can be added to picture, that when clicked makes google sheets go full screen? Or upon opening ...
user avatar
0 votes
1 answer
27 views

How to us Conditional Formatting with color scale based on data in another cell

need some help with conditional formatting. Take a look at the sheet below. I would like to apply conditional formatting to D20 based on the vales of C20. For example, I want it to be on a color scale ...
user avatar
0 votes
0 answers
9 views

Why can't I see the names of people who liked a post

Why can't I see who liked a Facebook post? I get the number of likes, but no names.
user avatar
2 votes
1 answer
77 views

Google Sheets - Group/Aggregate data

I would like a formula that groups/aggregates the data of Column A, B, C and D if column A is the same string The issue is the end of the string in column A with different sizes at the end of the ...
user avatar
0 votes
0 answers
9 views

Facebook temporarily blocked me from commenting on husband post

I was commenting on my husbands post and at the same time typing fast misspelling many words hoping auto correct would pick it up so I could continue to keep up with my thoughts before I lost them. So ...
user avatar
0 votes
2 answers
24 views

Can I use a drop down list to color-code a cell with Conditional Formatting, without displaying the text of the dropdown list option?

I know how to create a drop down list of options, and how to use conditional formatting to change the color of a cell based on the selection from the list. However, I do not want the list item ...
user avatar
  • 3
1 vote
1 answer
21 views

How to filter mail and send to labeled category in Gmail?

I created a GitHub label in Gmail in order to collect Emails from github. Then created a filter to catch mails from github.com domain In the operation step, I selected Apply the label: GitHub to ...
user avatar
0 votes
0 answers
4 views

Filter by specific no color label name not working

I have applied a no color label to a card. I would like to filter by that label, but I can't seem to do it. I can filter by the color labels applied, but it won't let me filter by the no color labels. ...
user avatar
0 votes
0 answers
10 views

Disable typing notification in slack

In Slack setting there is status looks like John Doe is typing ... I found in the preferences a way to hide it with: Additional options ☑️ Display information about who is currently typing a message ...
user avatar
  • 101
1 vote
1 answer
7 views

digitalocean droplet not showing after creating it

If I got to digitalocean and create a droplet so, as you see I have two projects, Mi and Ne, In the project called Mi, I currently have no droplets Now I try to create a droplet So I click create at ...
user avatar
  • 2,643
0 votes
0 answers
7 views

Block LinkedIn connection without removing as a connection

I need to make a series of posts on LinkedIn, but would prefer it so that a specific few people don't see the posts. Seeing as I can't set 'custom' post visibility like on Facebook, is it possible to ...
user avatar
1 vote
0 answers
17 views

Google Sheet - Sum Column until value is met if another column matches

Column A is trx date Column B is a stock ticker Column C is qty of shares purchased column D is qty of shares sold Column E is transaction price Column F is trx total I would like to have a formula I ...
user avatar
0 votes
0 answers
5 views

OSM - UMap how to select/delet multiple items

I edit a map in OSM - umap. Imported multiple geojson files, but now I would like to remove some of them. Is there a way to remove multiple items at once? I would like to remove all but one here, by ...
user avatar
  • 211
0 votes
1 answer
17 views

Correct Google Sheets Autofill - Skipping Cells

I'm trying to have a spreadsheet with a second standings chart that references a lot of different information on the sheet; I'm trying to average a range of a row of cells, but the rows that have the ...
user avatar

15 30 50 per page