r/googlesheets

I am an intern at a small company (10-15 people) who has been tasked with researching a free way to submit and track projects and project requests for myself (media intern), and possibly other interns in the future. The goal is that everyone doesn't have to go through the person managing me to ask for my help with something, and that there's a document that anyone working over me can check to see what I'm working on, how much I'm working on, and if I have more stuff laid ahead to keep working on. I'm thinking of doing it with a Google form and Google sheet because I'm relatively familiar in those areas.

My main question is: is there a way to sort the project information onto different parts of a sheet? Like a tote sensitive section and a not time sensitive section? Or to sort responses in decending order of due date?

Also is there a way you would recommend differentiating between projects that have been submitted and projects that we've accepted or projects that I'm working on?

(I know this is not the perfect project management option, I am already looking at alternatives also, please no comments about using other services instead)

Bonjour,

Je bloque sur un problème de mise en forme conditionnelle dans Google Sheets.

J’ai un tableau où une cellule “ACWR” revient toutes les 4 lignes (exemple : M7, M11, M15, M19…).

Je souhaite que chaque cellule soit comparée à la cellule située 4 lignes au-dessus :

• M7 comparée à M3
• M11 comparée à M7
• M15 comparée à M11
• M19 comparée à M15
• etc.

Je voudrais appliquer une mise en forme conditionnelle sur toute la colonne avec les règles suivantes :

• 🔴 Rouge : valeur < 0,7 × la valeur 4 lignes au-dessus
• 🟠 Orange : entre 0,7 et 0,8 x la valeur 4 lignes au-dessus
• 🟢 Vert : entre 0,8 et 1,2 x la valeur 4 lignes au-dessus
• 🟠 Orange : entre 1,2 et 1,3 x la valeur 4 lignes au-dessus
• 🔴 Rouge : > 1,3 x la valeur 4 lignes au-dessus

J’ai essayé plusieurs approches avec INDEX, DECALER et INDIRECT, mais je n’arrive pas à faire fonctionner la formule en mise en forme conditionnelle sur Google Sheets.

Ma question est donc :

Quelle formule personnalisée faut-il utiliser dans Google Sheets pour comparer automatiquement chaque cellule à celle située 4 lignes au-dessus dans la même colonne ?

Merci d’avance pour votre aide !

I'm on macOS Sonoma 14 with Chrome 150 (Apple Silicon).

I noticed a weird issue in Google Sheets.

If I copy a single cell, select multiple cells (like A2), and press Cmd+V, only the first cell gets pasted. The rest stay blank.

The exact same Google account and Sheet work fine in Brave.

I've already tried:

• Incognito
• New Chrome profile
• Reinstalling Chrome
• New Google Sheet
• Different Google accounts

Nothing changed.

Can anyone on Chrome 150 check if this happens to you too?

https://reddit.com/link/1unshju/video/1tesm3087cbh1/player

https://preview.redd.it/f8r8mvo2qabh1.png?width=1165&format=png&auto=webp&s=55f4af18811e019fd3b9f9e14494cc0d5725573c

https://docs.google.com/spreadsheets/d/1Kkz8rpI_4ZpxUmKxXoMZkR4w6OSLe9PAg_k402It85A/edit?usp=sharing

i want the selected cell, B9 (and the other cells below it but if i figure out the formula for one its easy enough to apply) to display the total of a series of operations. Each operation is taking a value in the row and multiplying it by the cell that's in the same column in row 7. I've typed out the long way to do it, "=(C9*$C7)+(D9*$D$7)+(E9*$E$7)+(F9*$F$7)+(G9*$G$7)+(H9*$H$7)" in this case, but i need a solution that i can type out once and will automatically update as more columns are added to the right. The full version of this spreadsheet has hundreds of rows and dozens of columns with more to be added with time, which in terms of the effort I'm expending rules out both doing it manually as more columns are added and creating a secondary cell for each of the cells to store the result of each operation to be summed.

Thanks for the help!

I own both files, but get a message I do not have permission when I try to link, and nothing pops up to allow me to give myself permission. I must be missing something. Both files are set to allow anyone with link to view, but not edit.

Hello, (Disclaimer the sheet posted in the link has no revealing information and the email is a burner account)

I'm trying to create a Google Sheets workbook where Sheet 1 contains all of my class information, such as the class names, days, times, and other details.

I added a checkbox on Sheet 1, and my goal is that when I tick it, the corresponding class automatically appears in a timetable on Sheet 2.

I was also wondering if it's possible to have a single timetable sheet that updates for each week, since my class schedule can change from week to week.

I hope that makes sense. I managed to get the checkbox to transfer the information from Sheet 1 to Sheet 2, but the problem is that it doesn't place the class in the correct time slot. I'm not sure how to make it appear in the right place based on its scheduled time.

Hi !

I am making a sheet where I need to retrieve informations depending on whether a checkbox is checked.

Column A has the checkboxes, C and D the information I want to display in a cell. (B is not important and I need the info from BOTH C & D in the same cell)

Now the thing is, I have multiple cells that need information based on these checkboxes, but when I use a simple VLOOKUP of course all of my cells display the same information : the one associated with the FIRST checkbox checked.

Is there a way for me to search for the next checkbox ? (and the next, and the next, etc.)

I've seen QUERY do something similar but only with cells that are directly next to each other, but i have merged cells (that I can't unmerge for layout reasons) AND my cells are not next to each other (they're separated by an empty line), so it didn't work.

I roughly recreated my situation here (with different columns from what I mentioned above, to make things clearer I put everything on the same sheet) :
https://docs.google.com/spreadsheets/d/1_w4xMRvw6SN-Ewl3ZP7iKuAQ8v0VFZHpxkJQELtnbEo/edit?usp=sharing

And here is a visual of my example here as well as the formula I'm currently using for this example (written in the grey boxes) :

=VLOOKUP(TRUE;$H$1:$J$14;2;) & VLOOKUP(TRUE;$H$1:$J$14;3;)

https://preview.redd.it/ud35vkt2kuah1.png?width=1267&format=png&auto=webp&s=430f63096530f7ba37afab68075150389278a4ca

Thank you for your help !

Hi there, does anyone have advice on how I can remove this addition to the bottom left corner of any cell I click on? It's taking up real estate and I don't need it.

I've already tried:

• In Sheets: Tools, Suggest Controls, unchecked everything
• In Gmail: All Settings, Turn off Smart Features

Any other tips for disabling Gemini in Sheets? It's a nuisance, and doesn't help, but hinders my work flow.

Thanks!

Is anyone else having issues duplicating sheets for the last day or so? When I duplicate a sheet the duplicate cant connect to the network so it is no longer useful.

Any help is appreciated.

Hello, I am a baker and my customers order baked goods off a form and it populates to a google sheet that ends up looking like this (https://docs.google.com/spreadsheets/d/14HeZaIRTjIPuqTzsRIinp4coHiew2o4LAIuzRX\_8Luk/edit?usp=sharing). Ive deleted the email addresses and £££ amounts for privacy. What Id like is a formula on a fresh sheet that will take orders from this sheet of data and turn them into individual entries, one line for each bag, then have them all ordered according to certain rules. So i can have a sticker printer print each line out as a sticker and put each sticker on a bag, and then put into the bag whatevers written on the sticker.

The rules are, in order of priority

1. alphabetical order in the location column, so that each delivery locations bags are grouped together

2. loaves of bread always need a line to themselves because each bag can only fit one loaf (thats the columns named seeded, white, and brown)

3. dough balls always grouped together and max 2 balls per bag (thats the column called dough)

4. pastries (croissant, choc, swirl, raisin) maximum 3 per bag

5. all the whites grouped together, then all the seeded grouped together, and then all the browns grouped together. Then the dough balls ordered together. Then pastries orders at the end of each delivery location

Does that make sense?

Hi all,

I am working on a sheet where one sheet will pull data from a number of different tabs using VLOOKUP. By using IFERROR, I also have it display nothing instead of #N/A when there's nothing to pull.

Where I run into issue is with counting.

Essentially the main sheet is a big grid with people's names in one column, and each following column pulling data next to their name from different tabs. But not every name is on every sheet. So I want to be able to count how many items are filled in for each row, but any counting formula counts all cells as it reads the blank cells as containing data (since it has a formula in it)

So the problem is that it shows everyone as being on 17 tabs when in reality it should vary between 0 and 17 depending on the person and number of times they actually display. The values it pulls from each tab are all different words (team names) so I can't simply use 'COUNTIF' to count a specific word either.

Any ideas?

EDIT: This has been solved. Thanks to everyone who posted things to try below!

I have multiple sets of data that I need to chart. The stroke is always the x-axis, but I have multiple sets. How can I have them all be in one single chart?

https://preview.redd.it/1jloonmqswah1.png?width=2442&format=png&auto=webp&s=86d4dfdada77b8f54a04cb1977acfc85c39d25bb

Recipe name spits out all the components. And then if I want to make 3 of that recipe for an occasion it scales. I've been searching on Google, reddit, and YouTube and I can't find a solution. I could be searching the wrong terms but I'm at a loss.

For example, I have a recipe for pbj. I'd like to be able to have a drop down for pbj and if each one needs 0.5oz of peanut butter and 0.5oz of grape jelly then if I want to make 10 of them it tells me how much of each I need.

I remember while learning coding way back when and learning about objects and them being able to have multiple fields attributed to them. But from what I've dug up I can't seem to to do that with sheets.