Returns the sheet number for a given cell reference.
Syntax
Remarks
The cell_ref cannot have more than one cell range as reference.
Examples
Formula |
Result |
=SHEET( SHEET.A1 ) |
16 |
=SHEET( ADDRESS.A10 ) |
1 |
=SHEET(Sales_data) |
4 |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com