I'm going to be organizing Americano tournaments. These are tournaments where eight people play and have seven matches. We have to play with each individual other player and against every other player twice. So once with everyone and twice against everyone. And there are apps that do this, but one weird thing that I wanted to do was, as. These tournaments unfolded like once a week. I wanted to capture the score each time. And so capturing the score, actually, I was like, Oh, let's just do it in a Google sheet. And I have all the name and the score I'm going to use unique to grab all the names. And I'm going to sort with the sort formula , automated. Scoring system, keeping track of every name here. And I was like, wait to get the scores though. I have to type the scores here from an app result. So I was like let me just make the tournament itself score. Americano Tournament Template With Four Automations Roasting Google Sheets Americano Tournament Template With Four Automations Americano Tournament Template

So this is for paddle. It's a like a mini. Not a mini tennis. It's a different style of tennis and squash and stuff like always played in doubles. So you see court one here, round one is this player versus this player. Now I have filled this with four different automations. One, which is just formulas to which is a, Custom menu up here. Three, it's a button, an image with a button here. And four, I have on the settings, a checkbox that does the automation as well. And I will explain why I do each and every one of these because they are whole or for different reasons, different people are using this kind of sheet all the time. So one I'm on my laptop or rather a desktop computer, right? A laptop style computer. And I can do all of these. Not every. version of Google Sheets can do all of these automations. I will explain which ones do which. Americano Tournament Template With Four Automations Google Sheets Interface Changes Different Kinds of Automation Button Styles

But first I want to walk you through the sheet. And the formula automations. And this you might not think is automation, but is pretty darn magical in cheat. So I have created a place where we create player names here. And we just add the player. Just say, here's Andrew, here's Betty, here's Carl. And I don't know if you can see over on the right David, Edna, Frank, Gary, and Hector. But here on the right, all of these names are changing. So I do not have to copy paste these names. anywhere. I don't have to create the matchups. The matchups are already created. Here's Andrew and Betty. Here's Andrew and Hector. Here's Betty and David. They're all here. I have quote unquote automated this with these formulas. And this is just formula references to the cells . That is it. I have created each of these rounds. Americano Tournament Template With Four Automations Automate Google Sheets without Apps Script, without Zapier Americano Tournament Template With Four Automations Automation is not Magic

I did actually get a, not a random generator, but I did find an Americana generator. I was working on this for quite a while, trying to generate these matchups myself with some JavaScript, and it just wasn't working. So what I did is I just went onto the app, created one tournament, and then whatever format that was, I hard coded each of these in. And so now we can, but we can randomize this by taking this range here. And go up to data and randomize range and now these cell references are going to stay. But it's this range that is randomizing and you see the matchups are now different. But everybody plays with everybody once and against everybody twice. So you see Edna, David, Hector and you can always double check this. It's always seven rounds if it's eight players. With nine players it is one person is resting or resting. Americano Tournament Template With Four Automations

out each round, but it is still a number of around nine rounds. In fact, this time. But again, everybody plays with everybody once and against everybody twice, but you also rest one of the rounds. We are creating these tournaments once a week or even twice a week, maybe. And I didn't want to create as many tabs as we knew we would have. We would just create them on the fly. And that's where the automation comes in really handily. I added an image where I inserted. image over cells and I just drew this. I actually created this from two shapes, a circle and a plus sign to have this thing. And in my Apps Script , I have already NewTournament8, which takes today's date and it creates a copy of the template 8 and adds new and then the date. So that we always have the date automatically there. Americano Tournament Template With Four Automations Americano Tournament Template With Four Automations How to Create 64 Team Bracket in Google Sheets

That function also is in this menu. Actually, I just added it two more. So let's refresh. And when it opens, it will be new. So first I created this on open menu here, but this on open menu does not show up on mobile. And these images do show up on mobile, but these images do not have the assigned script and you actually can't click an image . But if you say option, actually command and just assign script here, you can actually see it happening. We hit command and then hit assign script. It's new tournament eight. So it's going to run that function anytime it's clicked and it's clicked and it. I did it right here, but this image shows up in mobile, but the button is not clickable. So what is a clickable button to run an automation? So already we've automated the rounds. Americano Tournament Template With Four Automations Go To Random Row Custom Function

We can randomize these rows, but now we create a new tournament on mobile. We may have to duplicate this or do those steps by hand, rename it, put in the date. But we don't really want to, we want to have an automation that just does it for us. So what I did is I created a settings page that has a checkbox , and now a checkbox is checkable on mobile. And so someone who wants to create a temp copy of the template and run this eight player tournament, they can go to this checkbox , it checks, it will duplicate the template , rename it. And it will uncheck the box. So we can look at our app script again and see that. So instead of this function running here, I created an on edit function. And now an on edit function, there can only be one. It's a simple trigger. You literally type on edit, but that can only be one. Americano Tournament Template With Four Automations Run 100 ChatGPTs at One Time Americano Tournament Template With Four Automations Go To Random Row Custom Function

And so I wanted two options here. The nine player will copy the nine player template and rename it. There it is over on the right. Because we have the name already, this new. It will not rename it, but we can also, you can see, let's delete it or rename it. If we rename it, it'll happen. But how this works is we use if statements to gatekeep to say, Hey, if the active range is B two, meaning the checkbox , we're checking if it's B two on the settings page. Making sure the sheet spreadsheet dot app dot get active sheet dot get name is equal to settings. If it is, and B2, then do this, which is going to be copy the template 8 and then also uncheck the value here, active range . If it's B4, we're going to actually create template 9. We're going to duplicate template 9, and then again, set value to false, so we're unchecking it. Americano Tournament Template With Four Automations GPT in SHEETS Richard Asks: Copy Template Tab and Rename to Date Every Week Automate Two Sheets

This also is, you can do uncheck here. I think that'll work as well. Uncheck. So let's double check that the uncheck works. It will create our copy and uncheck it. Yep. And then say this was actually, a week ago or on the 15th. And now we're going to create a 9 1, 9 player 1. Click the button. It will create the copy, rename it, and uncheck it. So we can use uncheck as well or set value to false. Either one works. If you are a better sheets member and watching this on better sheets down below is this exact sheet with all of these functions , all the app script waiting for you, you can use this. It's really cool. I will walk through one of these. Let's say we have scores, just put the scores over here. Maybe you have a scores out of 16. So it's like 12, 12, 4, 4, 12, 12, and 4. Or. 10, 6, sorry, 10. Americano Tournament Template With Four Automations How To Hide Data with Checkboxes in Google Sheets Automatically Uncheck A Daily Checklist Reusable Checklist Google Sheets

You have to put the score for each individual person. It's just the way that I set it up. So it's a bit of doubling, but as you can see, as I type it, the leaderboard is automatically sorted, right? And these scores are automatically calculated. So if we get to the end of the tournament. Let's just put these randomly here. We see, Oh, Gary wins. So let's say Gary, let's give them a little different score. There we go. By one point, Gary wins by one point. Now we can take either the leaderboard or. This one doesn't matter the order and put it in monthly, just copy paste values . And now automatically these are there. If it's different people or it's the same folks each time, you can put their scores each time. And it will automatically sort , find all the unique players, and then automatically sort them. So a lot of cool automations in this sheet. Americano Tournament Template With Four Automations How to Create Automatic Leaderboard in Google Sheets

Makes it super easy to use. Again, I made it very clear to be used on desktop, laptop, and mobile. Maybe an iPad as well. If you can click the image buttons, great. If you can't click the image buttons, we got you. We got you on the settings. We can create a new template . We can copy this template just by checking a box. That's really cool. And I hope you enjoyed this Americana tournament with four automations. Americano Tournament Template With Four Automations Americano Tournament Template With Four Automations

Better Sheets

Tournament Template With Four Automations in Google Sheets