Info_Rows
Retrieve detailed row data, including cells, discussions, and attachments, for enhanced row-level analysis.
Table Specific Information
Select
This view returns a list of Sheet Rows. The SheetId parameter is always required.
Retrieve all Rows of a Sheet.
SELECT * FROM Info_Rows WHERE SheetId = '2940085806098308'
Retrieve details of a specified Row.
SELECT * FROM Info_Rows WHERE SheetId = '2940085806098308' AND Id = '8206230771525508'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for the row, assigned by Smartsheet. This value is guaranteed to be unique within the sheet. | |
| RowNumber | Integer | The sequential number of the row within the sheet, starting at 1. Useful for referencing rows in a user-friendly way. | |
| Version | Integer | Indicates the current version of the sheet. This number increments each time a modification is made to the sheet. | |
| FilteredOut | Boolean | Indicates if this row is excluded from view by an applied column filter. True means the row is hidden; False means it is visible. | |
| InCriticalPath | Boolean | True if this row is part of the critical path in a project sheet with dependencies enabled. Useful for project planning and scheduling. | |
| Locked | Boolean | Indicates if the row has been locked by the sheet owner or admin to prevent changes. | |
| LockedForUser | Boolean | Indicates if the row is locked for the current user based on their permissions. | |
| Expanded | Boolean | Shows whether the row is currently expanded to reveal child rows or collapsed to hide them. | |
| AccessLevel | String | Defines the user's access permissions to the sheet containing this row (for example, Viewer, Editor, Admin). | |
| Format | String | Describes the visual format applied to the row, such as font color, background color, and text styles. | |
| ConditionalFormat | String | Specifies the visual format applied to the row due to a conditional formatting rule. | |
| CreatedAt | Datetime | The timestamp when the row was initially created in Smartsheet. | |
| ModifiedAt | Datetime | The timestamp when the row was last modified. Helps track changes over time. | |
| Permalink | String | A permanent URL linking directly to this row in Smartsheet for easy access. | |
| ParentId | String | The unique identifier of the parent row, if this row is part of a hierarchical structure. | |
| SiblingId | String | The unique identifier of the previous sibling row at the same hierarchical level. Useful for determining row order. | |
| ToTop | Boolean | A flag indicating if the row should be moved or inserted at the top of the sheet. | |
| ToBottom | Boolean | A flag indicating if the row should be moved or inserted at the bottom of the sheet. | |
| Above | Boolean | A flag indicating if the row should be moved or inserted above another specified row. | |
| SheetId | String | The unique identifier of the sheet to which this row belongs. |