Google is making life a little easier for anyone who lives inside big, messy spreadsheets. The company is rolling out two new Google Sheets functions — =SHEET and =SHEETS — and they’re small, almost hidden additions that quietly solve a very real headache: dealing with workbooks that have dozens (or hundreds) of tabs.

At a basic level, the idea is simple. =SHEET gives you the sheet number for a given tab, while =SHEETS tells you how many sheets exist in the file. That might sound almost too trivial to matter, but if you’ve ever built a dashboard that pulls data from multiple tabs, or inherited a multi-sheet monster from a teammate, these functions plug a gap that users have worked around with hacks, scripts, or add-ons for years.

Here’s how they work in practice. The =SHEET function takes an optional argument: a sheet name or reference. If you point it at a specific tab — say, =SHEET(‘Q4_Report’!A1) — it returns that tab’s position in the workbook, like “7” if it’s the seventh sheet. If you leave the argument out and just write =SHEET(), Sheets returns the number of the sheet you’re currently in, which is surprisingly handy when you’re trying to make formulas that respond to where they’re placed instead of hard-coding everything.

=SHEETS, on the other hand, is even more straightforward: it doesn’t take any arguments, and it simply returns the total count of sheets in the file. Importantly, Google is explicit that =SHEETS in this rollout is argument-free — if you try to pass it a range or a subset of tabs, it will throw an error. That’s a deliberate constraint, and it keeps the function focused on what it’s meant to be: a structural indicator of how large your workbook is, not a targeted counter.

What makes both =SHEET and =SHEETS genuinely useful is that they’re dynamic. Any time you add, delete, move, or rename a sheet, these functions recalculate automatically. In real terms, that means you can build formulas that literally depend on the layout of your workbook. Imagine using the sheet number as part of an INDEX or INDIRECT setup, where each sheet represents a period — January, February, March, and so on — and you want a summary tab that adjusts as you insert new months. Instead of manually updating every reference, your formulas can hook into the structure of the file itself.

If you zoom out a bit, there’s a pattern here. Over the years, Google Sheets has been adding more “meta” functions that help you understand the spreadsheet as an object, not just the data inside cells — think of tools like QUERY, which lets you treat your sheet like a SQL table, or INFO-style functions that give context about the environment. SHEET and SHEETS slot neatly into that category: they don’t calculate your revenue or your churn; they tell you about how your workbook is built, so that you can make smarter formulas on top of it.

For power users, the most interesting possibilities show up when you pair these new functions with existing ones. Combine SHEETS() with SEQUENCE(), for example, and you can generate a list of sheet numbers dynamically, then use that list inside ARRAYFORMULA or INDEX to pull data programmatically from each tab. Or imagine a situation where your file always keeps “Summary” as the last sheet; you could use SHEETS() to find the current last position and then construct references that always stay one step before it, no matter how many working tabs get added in between.

These functions also play nicely with the ecosystem around Sheets. Many teams already lean on add-ons and scripts to consolidate data across multiple tabs or files, using functions like IMPORTRANGE, QUERY, or custom Apps Script functions to keep complex reporting setups alive. By exposing structural details like sheet count and sheet position, Google is effectively giving those workflows a bit more native support — fewer brittle assumptions, fewer hard-coded references, and a little more resilience when someone inevitably renames “Data_2025_Final” to “Data_2025_Final_v3.”

From a rollout perspective, Google is treating this as a standard Workspace feature launch. The new functions are arriving gradually across both Rapid Release and Scheduled Release domains, with the usual “up to 15 days for feature visibility” window, starting February 23, 2026. There’s nothing admins need to toggle; there’s no control switch in the admin console. As long as you have access to Sheets — whether that’s through a paid Workspace plan or a personal Google account — these functions will simply appear and work.

It’s also notable that Google continues to treat Sheets as a product that has to balance two very different audiences: casual users who just want to sum a column of expenses, and advanced users who are effectively building lightweight analytics systems inside a browser tab. SHEET and SHEETS clearly cater to the latter group. If you’re only ever working with one or two sheets, you may never touch them. But if your workflow involves multi-tab models, template-driven reporting, or anything where the workbook grows over time, these functions are the kind of incremental upgrade that quietly reduces friction.

In the broader landscape of spreadsheet tools, it’s another sign that Google is comfortable leaning into more advanced, Excel-style capabilities while still keeping Sheets approachable. Excel has long had a deep catalog of informational and structural functions, and Google has been steadily filling out its own roster — from LOOKUP and QUERY improvements to richer info functions and support for complex array formulas. Adding SHEET and SHEETS won’t grab headlines like a big AI feature, but it does send a clear signal: Google wants Sheets to be a serious, long-term home for complex workbooks, not just a convenient cloud spreadsheet you outgrow later.

For now, the actual “getting started” story is refreshingly simple. Open any spreadsheet, type =SHEET() or =SHEETS() into a cell, and you’re using the new features — no setup, no special permissions. If you’re curious about how to integrate them into more advanced formulas, Google’s function list and the broader Sheets help ecosystem have plenty of examples and patterns that show how structural functions can layer into more complex setups. It’s a small change, but for the people who push Sheets hardest, it’s one that’s likely to show up in a lot of templates and internal docs very quickly.