SHEETS in Google Sheets: Count Workbook Tabs
Count workbook tabs with SHEETS(), compare a three-tab and four-tab example, and flag structural changes without confusing tab counts with data checks.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =SHEETS() returns the number of sheets in the spreadsheet containing the formula. Use it to check a workbook’s tab count, not the position of the current tab or the amount of data on it. Google’s SHEETS reference.
Verification: Documentation reviewed October 21, 2026. The example tab counts and comparisons were independently modeled, not executed in Google Sheets. Only the no-argument form is covered: Google’s help and launch announcement disagree about argument support.
Syntax and the argument discrepancy
=SHEETS()
Both official sources support this no-argument form. The function help also describes an optional reference, while the February 2026 launch announcement explicitly says arguments are not accepted and cause an error.
That disagreement is unresolved here. Do not add a cell reference, sheet name or tab range to reproduce these examples. No argument-dependent output or exact error message is asserted. In particular, another spreadsheet product’s SHEETS syntax is not evidence of Google’s behavior.
Example 1: count a three-tab practice workbook
Use a disposable workbook containing exactly these three ordinary, visible tabs:
- Summary
- Inputs
- Review
Rename the initial blank tab to Summary, then add Inputs and Review. Do not leave an extra default tab behind.
On Summary, enter Tab count in A1 and =SHEETS() in B1. The expected result is 3, because the fixture contains three sheets.
Now enter the same formula in Inputs!A1. Its expected result is also 3. Moving the formula’s location does not turn this workbook count into the current sheet’s position. Use the separate SHEET guide when position is the question.
Counting three tabs does not prove that they have the right names or contain the right records. For example, replacing Review with an unrelated tab could leave the count unchanged.
Example 2: flag an additional tab
Continue with the same three-tab fixture. On Summary, enter these values:
| Cell | Entry |
|---|---|
| A3 | Expected tab count |
| B3 | 3 |
| A4 | Count check |
| B4 | =IF(SHEETS()=B3,"Count matches","Review tab count") |
Initially, the expected B4 label is Count matches: the modeled comparison is 3=3.
Add one ordinary visible tab named Archive. After recalculation, the expected SHEETS result is 4, and B4 becomes Review tab count, because 4=3 is false. Renaming Archive to Notes leaves four tabs, so it does not restore the match.
If four tabs are intentionally required for your real workbook, update the expected-count input to 4 after reviewing that requirement. Do not change it merely to hide an unexplained extra tab. The check tests a count only; it is not an approval that the workbook’s formulas or records are correct.
Troubleshooting
- The result is one too high in this fixture: Count the tabs you actually created, including an unused initial blank tab. Start with exactly the three listed tabs before testing the change.
- The formula was copied from another product and fails: Reduce the test to
=SHEETS()in a blank cell. The unresolved argument documentation is a reason not to assume reference syntax transfers unchanged. - You expected the current tab’s number: SHEET and SHEETS answer different questions. A formula on the first tab of this fixture still has an expected workbook count of three.
- The check passes despite a missing data set: A count cannot verify tab identities, cell contents or calculation accuracy. Review those separately.
Google’s announcement describes recalculation after structural changes. This guide does not establish timing under every calculation setting, nor hidden-sheet, external-document or special-sheet behavior. Its worked fixtures use only ordinary visible tabs.
Availability and compatibility
Google announced SHEET and SHEETS on February 23, 2026, with a gradual rollout of up to 15 days starting then. Personal Google accounts were included alongside Workspace customers. That is an announced availability window, not a test of a particular account. Official launch details.
The examples target the rolling Google Sheets web service. No native account session, imported XLSX behavior, mobile interface or cross-product equivalence was verified for this guide.
Related guides
See SHEET for tab position, IF for the comparison label, and COUNTA when the intended subject is nonempty cells rather than sheets. Browse the Google Sheets function reference for the other function guides.