SHEETS and SHEET NEW FORMULAS in Google Sheets

0:00 Very exciting new update, brand new formulas rolling out right now at this very moment in early 2026. We have sheets and sheet. Sheets offers us a count of every single tab in our spreadsheet file. So here we have equals sheets and we just type these in. Equal sheets just like any other formula . These are just new formulas. We type that in and we hit enter. And that's the number three because there's three spreadsheet tabs in here. If I hit add sheet , we can go back to our sheet one and see that it's updated. So, it's constantly looking for how many sheets there are. Let's delete sheet . And there it is. Three. There's no editing tricks here. I'm recording this real time.

0:45 These are really cool little things. You can add these formulas to do interesting calculations . For example, if you have months and every month you add a new tab and you want to know how many months have we been doing this, right? We can count this number of sheets this way. Also, sheet allows us to get the index number a particular sheet. So if we know the name Jan or Feb and we want to know at which index is it in our spreadsheet file index meaning sheet one in this particular case is number one January is number two February is number three but if we delete sheet one and now we have January and February sheet Jan is at index one again this is updating in real

1:30 time if I add another few sheets and I move January let's say past February now equals sheet Jan says hey it's number four. So this is a really interesting use case where we may want to know one does a sheet exist and if it does do something or if a sheet doesn't exist do something else in a formula setting but also we can check to say what is the order of these things. So if we go Jan Feb and we go equals sheet we go A1 that's four to A2 four. See this not working. What this is actually doing is saying what sheet is A2 on. So this is a

2:19 little weird because you would think it would look for February but it's not. If we do Feb, it's going to say three but it's actually looking at that exact range . 8. If we go January A2, it'll be here. If we go February A2, it's saying three. So, in order to see the index of the sheet, you can't reference it in another cell because that reference will be what it's actually giving you the reply of or the output to. So, that's very interesting. And I would make sure you're using this in the correct way and that you understand that this A1 is not looking at JAN. It's looking at the cell reference of A1. Hopefully that helps you use this and use it in an

3:06 interesting way. These two new formulas, sheets and sheet. You're watching Better Sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how-tos, get more out of your Google Sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is going to be your next Google Sheet.