In a previous video I showed you how to automate something like sorting. And when this happens you may want to sort multiple sheets. So this video I'm gonna share with you how to edit your app script so that you can automate two separate sheets.

So false for descending. True for ascending. So how do you sort two columns? I'm gonna show you a few different ways here.

So we can't do that. What we could do is take this whole code and copy and paste it and then change 2026 to 2027.

So what I showed you before was creating a trigger , I think in the original video we want to say we want to automate this every day.

To add another trigger , we just go add trigger on the bottom right.

And here. We will call the function B column 2026, add parentheses and 2027, add parentheses if we want to execute both of those.

So now I have a trigger doing that. Pretty cool, right?

each time, and then stop when we don't have any more sheets left.

some information, it's not data .

Actually, sorry, I should select all sheets. Run. And now they're all sorted.

sheets than you ever have before. I'm excited to be making a ton more videos here.

Better Sheets

Automate Two Sheets