Spread Formula Reference
Formula Functions / Functions R to S / SHEET
In This Topic
    SHEET
    In This Topic

    This function returns the sheet number of the reference sheet.

    Syntax

    SHEET(value)

    Arguments

    For the argument, the name of a sheet or a reference for which you want the sheet number. This argument is optional.

    Remarks

    The #REF! error value is returned if the value argument is an invalid value. The #NA error value is returned if the value argument is an invalid sheet name.

    Data Types

    Accepts string data. Returns numeric data.

    Examples

    SHEET(Products) gives the result 1, where Products is the name of the first sheet(Sheet1) in the workbook.

    SHEET("SheetFour") gives the result 4, where SheetFour is the name of the 4th sheet in the workbook.

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.