preferred-sources
X
Mail
Google Sheets
,

Google Sheets Adds New SHEET and SHEETS Functions

Key Points of This Article
  • Google is rolling out two new functions, “=SHEET” and “=SHEETS,” as additional features for Google Sheets.
  • “=SHEET (=SHEET(value))” is a function that returns the specified sheet name or sheet number within a Google Sheets file.
  • “=SHEETS (=SHEETS())” is a function that displays the total number of all sheets in a Google Sheets file.

On Monday, February 23, 2026, Google began rolling out two new functions, “=SHEET” and “=SHEETS,” as additional features for its spreadsheet service, Google Sheets.

“=SHEET (=SHEET(value))” is a function that returns the specified sheet name or sheet number in a Google Sheets file. If the argument is omitted, it displays the sheet number of the sheet containing the function.

“=SHEETS (=SHEETS())” is a function that displays the total number of sheets within a Google Sheets file. It is important to note that including an argument will result in an error.

The two new functions added to Google Sheets this time are widely available to all users, including personal Google account holders.

Source：Google

Share this article

Comments

コメントを残す

*This site uses affiliate advertising.