February 23, 2026
Two new functions in Google Sheets
We are adding two new functions to Google Sheets, =SHEET and =SHEETS. These additions help users manage and reference spreadsheets with multiple tabs more effectively.
The new functions operate as follows:
- =SHEET(value): Returns the sheet number of a specified sheet name or reference. If the argument is omitted, it returns the number of the sheet containing the function.
- =SHEETS(): Returns the number of all sheets in the spreadsheet.
Please note that the =SHEETS function in Google Sheets does not accept arguments (such as a range of tabs). Formulas containing arguments for this function will result in an error.
These functions allow you to perform calculations based on the structure of your spreadsheet. Both functions are dynamic and will recalculate when a sheet is added, deleted, moved, or renamed within a document. This ensures your data analysis remains accurate even as the organization of your spreadsheet changes.
Getting started
- Admins: There is no admin control for this feature.
- End users: Use =SHEET() or =SHEETS() in any Sheets document to get started with the feature. Visit the Help Center to learn more.
Rollout pace
- Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on February 23, 2026
Availability
- Available to all Google Workspace customers and users with personal Google accounts
Resources
- Google Help: Sheets Function