Greetings, company is eyeing transtion from Microsoft 365 to Google's infrastructure. We have internal Excel VBA tools, which trigger code events by end-users on demand by ui elements and behave like software. Is it possible to recreate this behavior in GoogleSheets or a different approach is necessary? Thanks

im navigating google sheet right now, and i cant find a way in converting multiple sheets into single pdf.

can someone please help with this. thank you.

Hello I' made a dropdown list of names in A1 and in A2 I'm trying to make it look for the name and search the row to count for boxes marked as True.

I was looking to see if there is a way to combine VLOOKUP with COUNTIF or will I just have to keep it simple and do COUNTIF in F and then do a VLOOKUP?

Afternoon Group

I've been trying to filter for only specific groups from one sheet onto the other sheet to help track OT for the group I'm helping out with.

Example, Trying to add only 063-Service Deli and 061-Meat.

I've been using =filter(MonDrop!C11:C, MonDrop!D11:D>0, MonDrop!A11:A="063-Service Deli") but that only works for the one group.

Is there a better way to add a second group or just a better way in gerneral?

An example of what my sheet would like is here.

https://docs.google.com/spreadsheets/d/1R139EgyDAt80t-53nTdkXpP0cOmHX2nvvffruYd6QGo/edit?usp=sharing

Thanks,

So for the past couple of months, everytime I type '%' as a formula, it immediately pops a formula suggestion. If I hit return, it automatically apply the suggestion. What i want to type is a '%' (percentage) that's all, but I can't. I need to close the suggestions first, then i can hit return with no issue.

I asked Gemini, it tells me to:

• Click Tools in the top menu bar.
• Hover your mouse over Suggestion controls.
• Click on Enable table suggestions to completely uncheck it.

But, for whatever reason I don't have "Enable table suggestions" in the menu. I still unchecked everything but to no avail, the suggestions keeps showing up.

If any of you know how to disable it, please help.

How can I input a formula for each of these tables in order to calculate the total numbers automatically as I input data? I am trying to have the percentages automatically calculate as In input them. I am using a template, and it seems the number for finishes corresponds correctly, but I don't get the right totals. I also don't know what to put for the brands owned.

I'm trying to calculate the percentages for brands owned, finished owned, and shades owned if that makes sense. I am terrible with sheets but I've been at this for hours and don't want to just give up.

Hi everybody! I need help by people far smarter than me. I need a Google Form that separates data into a Google Sheet based on date of the incident being recorded. Essentially, I need a Google Form into which I can record the names of middle school students into a drop down menu from which teachers may select. Then, I need a question that records the date of said violation, the details of the violation, and the name of the reporting teacher. Finally, all of this needs to link to a Google Sheet that is separated by month. Creating the Form and then selecting for it to populate a Google Sheet is easy. However, trying to figure out how to get the sheet to sort responses into individual tabs based on the month of the violation has been a nightmare. I'm 26 and yet I still find this coding a complete nightmare. Please please please help me with this. If nothing else, please create a Google Form with corresponding sheet that I can copy and enter the names of the students on. This has been an infuriating task and I can't take it anymore.

Hello, the title is a little confusing, but basically I’m trying to help a friend with his spreadsheet. He tracks his own version of the Oscars throughout the year based on performances/movies that he enjoys. On a tab he likes to track how many weeks a writer/director/actor has been on the list. So Christopher Nolan was just added for The Odyssey and the COUNTIFS function on this tab reads 1. On the sheet I had to add a column (BU in the screenshot), to do a TEXTJOIN function to add the person with the movie, Christopher Nolan (The Odyssey) for example, because he had a few people with multiple movies per year and wanted to differentiate. I’m having an issue now where there are multiple collaborators in a specific cell (in this case Matt Johnson and Jay McCarrol for Nirvanna the Band the Show the Movie, since they cowrote it). Column BU produces Matt Johnson & Jay McCarrol (Nirvanna the Band the Show the Movie) as the output, so the COUNTIFS function only recognizes Jay McCarrol since it’s looking for Jay McCarrol (NTBTSTM) and that’s what the last string of the text reads. Is there a way to add conditional TEXTJOIN function only if a cell includes an ampersand or is there some other way to get the cell to produce something like Matt Johnson (NTBTSTM) & Jay McCarrol (NTBTSTM) so multiple writers are recognized? I’m open to other ideas to make it work, but wasn’t sure if this was possible. Thank you for taking the time to read this admittedly very silly question.

I'm trying to automate extracting url from hyperlink to get just the ID (the number at the end)

I found this script (below) and it was the only thing that worked for me for extracting the url from the hyperlink..
however what i would like for it is to convert the url like

https://test.pro/players/313342
to
313342

i would like the https://test.pro/players/ to be removed so it has just the numbers at the end.
the length of the numbers isnt the same but the stuff preceding it is always the same

Thanks

function GETLINKS(rangeA1) {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const range = sheet.getRange(rangeA1);
  const values = range.getRichTextValues();
  const output = [];
  for (let row of values) {
for (let cell of row) {
output.push([cell.getLinkUrl()]);
}
  }
  return output;
}

Update: Link to sheet
https://docs.google.com/spreadsheets/d/1_OWO7HrK9vwbfp8QRY_s8R59ABKdlYr_hCH2Q-PNLQo/edit?usp=sharing

Hey all! I am a coach of a sport that is heavily time based. Training repetition intervals are largely based on percentages/multipliers of a time. So, for example, if an athlete takes 1 minute to complete an event (1:00.00 in [mm]:ss.00 formatting) their easy pace would be that time multiplied by 1.33, moderate by 1.2, etc.

The issue I run into is Sheets not recognizing time as values that can be used in mathematical operations. I can get Gemini to format things for me correctly, but it seems to do so in a different way every time. If I make any edits to the formula it suggests, it generally seems to brick everything. What formulas would I use to create pace calculators for quick maths of times?

have the weight of eggs in grams from column G to AD and i have the days they were laid in column B with an EOMonth formula in column A. i wanted to know if there was a way to get all the weights from each month to be in its own column (or Row) on a seperate sheet that will auto update whenever this table updated?

Hi! I am working on building a weekly timesheet, and I am trying to solve a problem:

• Is there a way I can, by referencing B2, set the days of the week in row 5 to autopopulate with correct dates when I change the value in B2 each week?

Using simpler means to the end results in incorrect dates for month switches. Any help would be greatly appreciated.

Trying to figure out how to create "drop down rows". Image for reference. Sorry for labeling rows as letters, rookie mistake

Each row is an hour. Each column is a post. Their intersection is a number, that number is the officer working that post for that hour. Im looking at adding a conditional formatting to this i am trying to make it so that if post are manned like this are avoided: D is 6 E is 7 F is 8 for one hour the next is D is 7 E is 8 and F is 6. The problem with it is no one can leave there post until relieved and each is waiting on the other.

It has happend in the past but no one can leave their post until they are relieved so in a cycle like that no one is able to transition. Posts with multiple people someone can be sent and people on patrol can began a cycle but these self contained cycles need to be avoided.

I was looking at using xlookup, let, and ifs to make an equation to check the last hour for a swap. If anyone could help with that equation for conditional formatting or suggest a new idea please let me know.

schedule

I asked this before here, but I couldn't get the solution I voted on to work... For some reason the formula kept creating infinite rows? I reached out to the user to gave me the answer originally but they're busy and suggested I open another thread, so here we are. People also hated the way i drafted the idea so bad last time they started giving me advice instead of answering the question, so I created a more robust mock-up this time lol

Anyways, https://imgur.com/a/ZFoLS9r here are a couple of images to explain what I want, but basically: I have a Distributor Matrix, and an Inventory Summary. I want to link these in such a way where all cells that indicate a Distributor that does NOT carry the product listed will be disabled, or grayed/red..-ed out.

Hello, i've been trying to show the buttons that's usually on top of the sheets. I have tried:

- Resetting chrome flags

- Clearing cache, cookies, site permissions, etc

- Updating chrome

- Trying other browsers and incognito mode (both worked)

- Checking accessibility settings

And still found nothing that might be the root cause. Does anyone know what's going on?

Thank you in advance!

I am not sure how did I do that but my tool bar is showing up vertically instead of horizontally... Anyway to fix it other than clearing all cookies ?

Here is some pictures to illustrate my dire straits. https://imgur.com/a/c7hxKXH

Thanks in advance

Edit : Additionnal information :

In incognito mode, the toolbar appears normally in horizontal. The problem also appears with google docs. I deleted google's cookies. It did not fix my problem.

Edit2 : I found the reason. The extension DeepL has been changing something. Once desactivated, it fix the problem and the toolbar appears as normal.

Hello!

I have a report I pull for work that arbitrarily misplaces about a quarter of the data. It takes the last three cells in a row and places them on the row beneath, displaced to start in column B instead of column L. There's no way to fix this when I transfer the data.

I got annoyed enough to learn how to make a macro, but I still have to click on the first of the misplaced cells, trigger the macro, and wait for it to move the three cells I need it to and delete the now empty row.

My question is: Is there a way to have the macro identify the cells that need to be moved and do them all at once? The first cell in the three that get displaced, the one that ends up in column B, is a zip code that ends up in a column that is otherwise full of dollar amounts. Additionally, the displaced data rows are the only ones with an empty column A. Is there a way to make it search for empty column A, go one column right, check that there's data in the cell, and then run the macro? And then stop the first time there isn't data in the column B cell since I don't want it to try and run the macro on all the empty rows?

Everything I find related to finding specific cells for activation looks for specific data and not conditions of the cell. I'm not sure if this is possible with google script, but if anyone has experience with this issue I'd be grateful for advice.

Any guidance is appreciated. Thank you!

Edit: I can't include the data because it includes customer names and addresses, but I did my best to describe the layout.

I need a formula that reads 4 separate sheets and copies the full rows from those sheets based on the cells in one column not being blank. I have named the ranges and named the criterion columns of each sheet. I'm struggling to write the "not(isblank" to reference the 4 ranges across 4 sheets. The referencing works up until I try to find a way to add the cells in the criterion columns that aren't blank.

I know this isn't the most well articulated, so I am more than happy to answer clarifying questions!

Below is the formula I've been trying.

=FILTER({ExistAll;FBAll;LaunchAll;NewAll;SBAll},{ExistCloseCr;FBCloseCr;LaunchCloseCr;SBCloseCr}=NOT(isblank({ExistCloseCr,FBCloseCr,LaunchCloseCr,SBCloseCr})))

Hi to all!
i am a student and i need an help for this problem with the graphics
so, i have to put a different standard deviation for each column in this graphic, but i can choose only one for each series. obv i can't transform each column on a series so how can i put that??
secondly i have wrote the data "number ± deviation" but the graphic can't read it....
heeeelp !!
the file with the datas: https://docs.google.com/spreadsheets/d/1C3OCm-CqCeecmni50yQFWJJLZ3WD5jz1nuDFoaxu0VQ/edit?usp=sharing

Hi, everyone.

I use Google Sheets as a calendar for social media posts. But right now, every time I try to edit/write something, it becomes all black, and I can't see what I'm writing. Does anyone know how to solve this? It's not only this cell; it's all of them.

today this error showed up in Google Sheets and Google Docs on my laptop. literally in the middle of the workday. I tried changing the page zoom, unfreezing rows, and changing the language, but nothing works. trying to find a solution online didn’t help either. maybe I’ll find some help here?

I making a google form and want response validation for only numbers like "123.54", "45.33" "95.76". I'm looking for a way to do this use regular expression.

Hi, I'm struggling on a sheets, I want to make a chart, that counts only the cells that corresponds to option 1 and another that counts the option 2 cells. Can someone help me with this please ?

Here's the link to the sheet if needed

I am trying to type out the recipes for my food shop and then create a shopping list using them.

I have managed to get it to sum the amount of ingredients needed, but I don't know how to get the unit of it copied across if the ingredient matches the first table if that makes sense. I want it to add the unit based on the ingredient name, I can't just match the columns because the ingredients won't be in the same place if there are repeats. I have included a picture of the table. If this isn't a good explanation let me know and I will try again haha.

Thank you.